PHP MySQL Tutorial: Create a Database and Table in phpMyAdmin -HD-



In this tutorial, you will learn how to create a database and table within phpMyAdmin.

Be sure to SUBSCRIBE because there will be a new tutorial every week.

Follow me on Twitter @RiverCityGraphx

Like us on on facebook:

Suggest tutorials at

For project files, help forums, and more check out the website at

For business related inquires contact us at rivercitygraphix@yahoo.com

, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

46 thoughts on “PHP MySQL Tutorial: Create a Database and Table in phpMyAdmin -HD-

  1. Saying "basically" every three seconds makes you sound super dumb, I know you're probably thinking that all the nerds are using it adn they are smart, but just trust me, stop it and be normal.

  2. i have problem bro its really sucks i never have this kind of error i know this is very common but i couldn't solve it

    #1064 – You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') NOT NULL , `infor` VARCHAR(150) NOT NULL , `address` VARCHAR(150) NOT NULL )' at line 1

  3. i got an error, #1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0) NOT NULL DEFAULT 'a' , `email_activation` ENUM(0) NOT NULL DEFAULT '0' , ' at line 1

    help please.

  4. #1064- You have an error in you SQL syntax; check the manual that corresponds to your MainDB server version for the right syntax to use near '.'b'.'c' NOT NULL DEFAULT 'a' , 'email_activation' ENUM('0'.'1') NOT NULL DEFA' at line 1                                                                                                                                                                                                                                           that's the error I get when I click save. can somone please help

  5. I wouldn't recommend using VARCHAR for a numbers field as it takes up 8x as much space on the host. also, if you need to require a certain amount of characters to be entered, use CHAR instead of VARCHAR. For example, if you wanted every username to be exactly 8 characters long, you could use char and write code to listen for errors in the database.

Leave a Reply

Your email address will not be published. Required fields are marked *