摘要:
条件(模糊)查询 SELECT * FROM stu WHERE english IS NOT NULL;//模糊查询SELECT * FROM stu WHERE NAME LIKE '马%';//马后无所谓多少用%SELECT * FROM stu WHERE NAME LIKE '___';/ 阅读全文
摘要:
增加数据范例:INSERT INTO student (id,NAME,age) VALUES(11,'呀哈哈',10000); 增删表中数据 修改数据:UPDATE student SET age = 111,score = 100 WHERE id = 11; 字段排序语法 聚合函数 count 阅读全文