Slide 5.17: SQL (Structured Query Language) (cont.)

Slide 5.16: SQL (Structured Query Language)
Slide 5.18: SQL SELECT statement
Home

SQL (Structured Query Language) (Cont.)

INSERT INTO  table-name
  [ ( list-of-column-names ) ]  VALUES ( data-items )

SQL> insert into  student  values (
  2    '1', 'Jones', 'Allan', 2, '555-1234' );

The values of the respective tuple are the data items separated by commas. If new values are to be entered for certain attributes but not for all, the respective columns must be indicated explicitly; the remaining columns are filled with null values.

DELETE

DELETE FROM  table-name [ WHERE  condition ]

SQL> DELETE FROM  student  WHERE  student_id = '2';

UPDATE

UPDATE  table-name  SET  column-name-1 = expression-1
  [, column-name-2 = expression-2 ] ... [ WHERE  condition ]

SQL> UPDATE  student  SET  phone = '777-2415'
  2    WHERE  class = 2;

SELECT

Subselect general form

SELECT [ ALL | DISTINCT ]  expression-1 {, expression-2 }
  FROM  table-name-1 [ corr-name-1 ] {, table-name-2 [ corr-name-2 ] }
  [ WHERE  condition-1 ]
  [ GROUP BY  column-name-1, {, column-name-2 } ]
  [ HAVING  condition-2 ]

Full select general form

Subselect
  { UNION [ ALL ]  Subselect }
  [ ORDER BY  result_column-1 [ ASC | DESC ] {, result_column-2 [ ASC | DESC ] } ]

Slide 5.16: SQL (Structured Query Language)
Slide 5.18: SQL SELECT statement
Home

Never bite the hand that feeds you.