our approach|new tutorials|contact us

MySQL Basics In Pictures

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

Create a record

1. Type:
   INSERT INTO name (id, first, last) VALUES (NULL, 'George', 'Washington');
   then press ENTER.
   The window should look like this:

   

   This command string creates the first record in the table name. It reads much like a sentence:
   INSERT INTO the table name (which has the fields id, first, and last) the corresponding VALUES NULL, George, and Washington.