以前的SQL学习笔记 希望对新手有帮助.学无止境   2003-5-1 11:24************************************************数据管理*****************************************{insert into table_name(id1,id2,id3) values(_,_,_);insert into table_name(id1,id2,id3) select id1,id2,id3 from othertable_name where ..;update table_name set id1=value1,id2=value2,id3=value3;update table_name set id1=value1,id2=value2,id3=value3 where serch_condition;update table_name set id1=value1,id2=value2,id3=value3 from table_list where serch_condition;delete from table_name where condition;————————————————-create database database_name;create table table_name(field1 datatype[not null],field2 datatype[not null],field3 datatype[not null]);create table table_name(field1,field2,field3) as (select field1,field2,field3 from old_table);alter table table_name add column_name [...]