计算机二级《MySQL数据库程序设计》知识点总结.docxVIP

MySQL知识点总结 .数据操作：检索、排序、过滤、分组、汇总、计算、联接、子查询与组合查询 .表操作：表的创建、修改、删除和重命名、表数据的插入、更新和删除 .索引（含主、外键）、视图 .难度编程：存储过程与存储函数、触发器与事件、PHP .数据库管理：事务处理、用户与权限、备份与还原、数据库维护 检索数据：select…from… Select [distinct] prod_id,prod_name from products [limit 4,5]; 检索排序：order by… Select * from products order by prod_id [asc|desc],prod_name [asc|desc]; 过滤数据：where 字句 = != = = between （1）普通where 字句 Select prod_id,prod_name from products where prod_name=’liyang’; Select prod_id,prod_name from products where prod_id between 10 and 50; Select prod_id,prod_name from products where prod_name is [not] null; （2）组合where字句：使用AND