mysql语句

增加操作

1. 增加一行(多行)

INSERT INTO table (name,imgPath) VALUES ('wyx','1.jpg'),('xjh','2.jpg');

删除操作

1. * 根据条件删除一行

DELETE FROM TABLE where name='xjh';

2. * 删除配合模糊

DELETE FROM TABLE where name LIKE ''%w%';

查询操作

1. * 根据条件查询一条

SELECT name FROM table where id=1;

2. *模糊查询('a%','%a',_代表一个字符占位)

SELECT id,name FROM table where name LIKE '%烨鑫%';

3. *模糊加排序

SELECT id,name,imgPath FROM table where name LIKE '%烨鑫%' ORDER BY id;
SELECT id,name,imgPath FROM table where name LIKE '%烨鑫%' ORDER BY name DESC;

4. *模糊加排序加限制数量

SELECT id,name FROM table where name LIKE'%烨鑫%' ORDER BY id LIMIT 3;
SELECT id,name FROM table where name LIKE'%烨鑫%' ORDER BY name DESC LIMIT 4;

5. *模糊加排序加限制数量加偏移(用来做分页)

SELECT id,name FROM table where name LIKE'%烨鑫%' ORDER BY name LIMIT 4 OFFSET 2;
//OFFSET只能配合LIMIT使用
6. ### 查询去重
SELECT name COUNT() FROM table GROUP BY imgPath ORDER BY id;

更新

1. UPDATE table SET name="烨鑫呀！" where name='烨鑫';