INSERT
INSERT

The following statement puts a row into a table Salespeople, using a table value constructor. 

AN EXAMPLE

       INSERT INTO Salespeople
              (id_num, lname, fname, city, country) 
       VALUES (1023, 'Blanco','Mercedes','Barcelona',
               'Spain');

  • The statement "INSERT" inserts rows of information directly into a table.
  • The word VALUE must precede the list of data to be inserted.


Salespeople.

EXERCISE:

Write SQL INSERT statement for the table created in the following example CREATE A TABLE

Back to SQL statements.