Insert Into用途： 在表中插入新行语法：插入一行数据:Insert Into table_name Values(value1, value2,....)插入一行数据在指定的字段上:Insert Into table_name(column1, column2,...) Values(value1, value2,....)   例：&l

Update用途：更新表中原有数据语法：Update table_name Set column_name = new_value Where column_name = some_value 例：“Person”表中的原始数据:LastNameFirstNameAddressCityNilsenFredKirkegt 56StavangerR

选取全部栏位select * from ct(表名称)选取部分栏位select name,notes,times from ct改变栏位名称select name as 姓名,notes as  备注,birthday as 生日 from ct条件运算式一1.针对数字类型的栏位select * from ct where times>5条件运算式二针对字符串s