- Welcome to Journal web site.
- 开发无止境 -
Data: 2021-09-28 19:37:03Form: JournalClick: 0
MySql 增删查改| 关键词 | 描述 |
|---|---|
SELECT | 查询 |
INSERT | 添加 |
UPDSTE | 修改 |
DELETE | 删除 |
MySql 查询WHERE 条件SELECT * FROM article WHERE `class` = 'PHP';
SELECT title,img,date,class FROM article WHERE `class` = 'PHP';
LIMIT 分页SELECT title,img,date,class FROM article WHERE `class` = 'PHP' LIMIT 2;
SELECT title,img,date,class FROM article WHERE `class` = 'PHP' LIMIT 0,2;
ORDER BY 排序语句SELECT * FROM article WHERE `class` = 'PHP' ORDER BY `date` DESC;
MySql 插入INSERT INTO article (`title`,`img`,`content`,`date`,`class`)VALUES('PHP是很好的编程语言','','PHP是很好的编程语言','2021-03-03','PHP');
MySql 修改UPDATE article SET `title`='PHP中文网', `content`='PHP中文网' WHERE `title`='PHP是很好的编程语言';
MySql 删除DELETE FROM article WHERE `title`='PHP中文网';
| 关键词 | 描述 |
|---|---|
WHERE | 条件（查询、修改、删除） |
LIMIT | 分页（查询） |
ORDER BY | 排序（查询） |
