本节课学习的东西总结

约定关键字统一用大写

1、增加数据用INSERT INTO

INSERT INTO `user` (`name`, `sex`, `age`, `email`, `password`, `status`, `create_time`)
VALUES ('碧瑶', '1', '22', 'by@php.cn', sha1('123456'), '1', '12124233');

2、删除数据 DELETE

DELETE FROM `user` WHERE ((`id` = '1'));

3、修改数据 UPDATE

UPDATE `user` SET `age` = '16' WHERE `id` = '2';

4、查询数据 SELECT

SELECT * FROM `user`;

5、删除主键 alter table

这个还不太了解，课后补习