SDB101 » Populating Tables
 
Adding a row to an existing table
  • "INSERT INTO" statement
  • Specifies table name, attribute names and values
  • Example:
      • INSERT INTO River(Name, Origin, Length) VALUES(‘Mississippi’,
      ‘USA’, 6000)
Related statements
  • SELECT statement with INTO clause can insert multiple rows in a table
  • DELETE statement removes rows
  • UPDATE statement can change values within selected rows

Última modificación: Thursday, 17 de November de 2005, 16:58