our approach|contact us

MySQL Basics In Pictures

• Starting
• Administration
• Tables
• Queries
• Security
• Web

2. Type:
   CREATE TABLE name (id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, first CHAR(25), last CHAR(25));
   then press ENTER.
   The window should look like this:

   

   This string of commands is used to CREATE a TABLE called name with three fields: id, first, and last.
   CREATE TABLE name (id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, first CHAR(25), last CHAR(25));