MySQL增删查改

-- SELECT * FROM student ORDER BY score DESC;//排序ORDER升序 DESC降序


-- SELECT * FROM student;--查询所有
-- SELECT * FROM student WHERE sex='0';--按照条件来查找
-- SELECT * FROM student WHERE sex='0' and name='小红';--多条件
-- SELECT * FROM student WHERE sex='0' and name LIKE '%小红';--模糊查询
-- SELECT * FROM student WHERE name LIKE '小_';--模糊查询
-- SELECT name FROM student;
-- SELECT sex FROM student;
-- 
-- INSERT INTO student VALUES(4,'小刚',1,95);--插入新的一行
-- INSERT INTO student (id,name,score)VALUES(6,'小四',90);--自定义插入列
-- INSERT INTO student (id,sex,score)VALUES(7,'0',88);


-- DELETE FROM student WHERE name = '小四' or name = '小三';--删除
-- 
-- UPDATE student SET NAME = '王晓刚',sex='0' WHERE name = '王晓刚';


--创建和删除数据库
-- CREATE DATABASE test;
-- DROP database test;


--创建表
-- CREATE TABLE weapon(
-- id INT PRIMARY KEY,
-- name VARCHAR(10),
-- attack INT,
-- rate INT
-- );
--删除表
-- DROP TABLE weapon;