写给将要实习的你-实习前你必须知道的几件事-SQL命令(二)

之前介绍过SQL命令(一)：http://blog.youkuaiyun.com/dtlscsl/article/details/46606047

下面介绍第二部分，主要是mysql的sql命令，介绍DML.

在之前创建的student表进行DML数据操作：

CREATE TABLE `student` (
  `user_id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL,
  `sex` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--增

1.插入一条数据

INSERT INTO test.student VALUES(1,'zhang','boy');

2.插入两条数据

INSERT INTO test.student VALUES(2,'li','boy'),(3,'wang','boy');

3.也有这种用户

INSERT INTO test.student SELECT * from test.student WHERE user_id = 1;

--删

DELETE FROM test.student WHERE user_id = "2" OR user_id = "3";

--改

1.修改多个字段

UPDATE test.student SET `name` = "zhangsan",sex = "b" WHERE user_id ='1';

--查

1.所有查询

SELECT * FROM test.student;

2.多条件查询

SELECT * FROM test.student WHERE name like "%zhang%" and sex = "boy";