MySQL CREATE TABLE in PHPMyAdmin
Found in cPanel, XAMPP, and similar environments, PHPMyAdmin is a powerful interface, providing a visual MySQL working experience. I use PHPMyAdmin quite often in my day job, developing a LAMP stack application, and want to share some common, everyday uses. PHPMyAdmin beginners — like me — who continuously learn through online resources such as blog posts, videos, and how-to tutorials will benefit the most from this post. Keep reading to see how you can utilize PHPMyAdmin to carry out commands…
Self-Promotion:
If you enjoy the content written here, by all means, share this blog and your favorite post(s) with others who may benefit from or like it as well. Since coffee is my favorite drink, you can even buy me one if you would like!
The initial display for CREATE TABLE in PHPMyAdmin looks like this:
In this section, I choose the name of the table and how many columns it will have. In this example, I specify 6 columns for the ‘walking_stats’ table. You can add in additional columns, or take them away as you progress from here if desired.
However, I’ll move forward with the process by clicking the Go button, which proceeds to the next display.
In this display, all of the columns are defined. There are 12 Headers that comprise this structured interface, each…
