sql92语句(国外英语资料).docVIP

sql92语句(国外英语资料) SQL 92 standard 2008-03-17 20:02-- statement function -- data manipulation SELECT -- retrieve data rows and columns from a database table When searching by date condition: select *, from, mytab3, where, F4, 10/1/1980 INSERT -- adding new data rows to a database table DELETE -- deletes rows of data from the database table UPDATE -- update the data in the database table -- data definition CREATE TABLE - create a database table DROP TABLE -- delete tables from the database ALTER TABLE - modify the database table structure CREATE VIEW - create a view DROP VIEW -- delete views from