SQL 简单的语法

• 简单的搜索功能

SELECT name,age FROM school;

• 搜索一些特定的内容，其中name IN ('hha','qq') 也可以写为name = 'hha' OR name = 'qq'

SELECT name,age FROM school WHERE name IN ('hha','qq');

• 降序排列，如果没有DESC的话就是默认升序

SELECT name,age FROM school ORDER BY school DESC;

SELECT name,age FROM school WHERE age BETWEEN 10 and 30;

SELECT name,age FROM school WHERE (parents = 'ha' OR parents = 'j') AND age >= 10;

SELECT name FROM school WHERE NOT name = 'q';

SELECT name FROM school WHERE name LIKE '%kabi%';

SELECT name,age FROM school ORDER BY age;