SQLite_3.0_数据库编程.ppt

插入多行数据 INSERT INTO TongXunLu (姓名,地址,电子邮件) SELECT SName,SAddress,SEmail FROM Students INSERT INTO 表名(列名) SELECT 列名 FROM 源表名 更新记录UPDATE UPDATE 表名 SET 列名 = 更新值 [WHERE 更新条件] UPDATE Students SET SSEX = 0 UPDATE Students SET SAddress =北京女子职业技术学校家政班 WHERE SAddress = 北京女子职业技术学校刺绣班 UPDATE Scores SET Scores = Scores + 5 WHERE Scores = 95 UPDATE Students SET remark = stu_name 删除表数据 DELETE FROM 表名 [WHERE 删除条件] DELETE FROM Students WHERE SName =张青裁 数据查询命令 单表查询 多表联表查询 分组聚合查询 嵌套子查询 查询集合操作 简单查询 语法 SELECT [*]|[列名] FROM [表名][,表名] WHERE [查询条件] 示例 select * from tab_student where stu_no=‘GN10