Struggling with PHPAdmin SQL

Today, I managed to install Xampp. My intent is to be able to test all my code on my local machine before moving it to my web hosting service; thus avoiding using the web host to test my code. I still have much to learn about this process, but I can do no testing until I have a database and some sample data created.

The first thing I tried to do with Xampp was create the tables needed for my database. I was able to get phpMyAdmin to create the name of the database and one table. The table will have 20+columns. I got phpMyAdmin to display a screen with the number of columns and even entered all the datanames, types, lengths, etc. I saved it and got an error.

The error

The column it burped on has type=date with a length of 10. I guessed at this length, but the error says nothing to indicate to me that the length value is wrong. I then found and clicked on ther Save button. I got no error.

Now, when I try to display the database to see that it did set up all the columns, I find there are only 2 columns of the 20+ that I entered. This tells me tht Save command failed, but there were no errors.

3 things:

  • Can anyone suggest what I failed to do or did wrong to lose all the work creating that first table?
  • Can anyone tell me where Xampp stored the database I created? I cannot find it in File Explorer
  • Is there a better ui for creating tables in the SQL that comes with Xampp thn the phpMyAdmin ui?

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.