SELECT `name`, `nickname` FROM `students`;
SELECT `name`, `nickname` FROM `students` WHERE `sex`='男';
DESC 倒序排列
SELECT `name`, `nickname` FROM `students` WHERE `sex`='男' ORDER BY `id`
DESC;
LIMIT 分页(偏移值 每页数据量) 偏移值=(页数-1)*每页数据量
SELECT `name`, `nickname` FROM `students` WHERE `sex`='男' ORDER BY `id`
DESC LIMIT 0,2;
SELECT `name`, `nickname` FROM `students` WHERE `sex`='男' ORDER BY `id`
DESC LIMIT 2,2;
3.改
-- 修改sex不为NUll,将男改为女
UPDATE `students` SET `sex` = '女' WHERE `sex` = '男';
-- 不加where把所有的 sex改为女,nickname改为没有昵称
UPDATE `students` SET `sex` = '女', `nickname` = '没有昵称';
UPDATE `students` SET `sex` = '男' WHERE `id` > 4;