Knight-ZXW的博客

下载mysql 示例数据库http://www.mysqltutorial.org/mysql-sample-database.aspx 下载数据库示例文件导入数据库http://www.mysqltutorial.org/how-to-load-sample-database-into-mysql-database-server.aspx

introduction to MYSQL SELECT statemention　　The SELECT statement controls which columns and rows that you want to see. For example ,if you are only interested int the firs name,last name, and job title

Introduction to MYSQL DISTINCT clauseWhen querying data from table, you may get duplicate rows. In order to remove these duplicate rows, you use th DISTINCT clause in the SELECT statementThe syntax of

DELIMITERDELIMITER 用于重置分隔符，默认情况下Mysql解释器会在遇到分隔符时就自动执行；但是在默写情况下，我们可能会输入多条相关语句，希望解释器呢能够在多条语句全部输入完成后才执行。这时我们可以先把分隔符重置成其他符号，再正常输入多条语句后，执行整段语句；再将分隔符重置回来。例子我们以定义一个 分页查询的存储过程 举例DROP PROCEDURE IF EXISTS `sel