Changes

Jump to: navigation, search

SRA840 Lab7

4 bytes added, 23:43, 16 July 2012
no edit summary
To insert some records into the table created above, you might use:
"insert into people (id,name,city,country) values (0,'Gregory Katherine Masseau','Toronto','Canada');
insert into people (id,name,city,country) values (0,'Mark Fernandes','Toronto','Canada');"
*change some of the records into the table you created
To change some records in this table, you might use:
"update people SET city='North York' where name='Gregory Katherine Masseau';"
*delete records from the table you created

Navigation menu