MySQL 基础知识增删改查基本操作

最新推荐文章于 2024-09-24 08:39:48 发布

aobu6889

最新推荐文章于 2024-09-24 08:39:48 发布

阅读量85

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/yuyu99/p/6368110.html

版权

增删改查=CRUD

增 insert
INSERT car VALUES('字符','name','brand','1990-02-02 00:00:00') 添加一条

INSERT car (`code`,`name`)VALUES('1','2') 单独添加

删除 DELETE 不常用
DELETE FROM car 删除表的所有信息
DELETE FROM car WHERE `Code`='字符' AND `Name`='name'
DELETE FROM car WHERE `Code`='字符' OR `Name`='name'

前台的删除数据库中不删用isdelect标记

改 UPDATE
UPDATE car SET pic='1' 所有的pic字段变为1
UPDATE car SET pic='1' WHERE ??=??

查 SELECT
SELECT * FROM car
SELECT Code,Name FROM car WHERE Code='c001'
SELECT * FROM car WHERE Name LIKE '%A6L%'
SELECT * FROM car ORDER BY Exhaust DESC 从大到下
SELECT * FROM car ORDER BY Exhaust ASC ,Price ASC 从小到大如果Exhaust相同 Price排列从小到

转载于:https://www.cnblogs.com/yuyu99/p/6368110.html