编辑代码

CREATE DATABASE test;
use test;
CREATE TABLE student (
	id int,
	name varchar(255),
    age int,
	sex varchar(255),
	city varchar(255)
);

INSERT INTO student VALUES (42403827, '刘文博',18,'男','新疆');
INSERT INTO student VALUES (42403844, '易志强',18,'男', '重庆');
INSERT INTO student VALUES (42403904, '肖斌',18,'男', '重庆');
INSERT INTO student VALUES (42403923, '王华宇',20,'男', '山东');
INSERT INTO student VALUES (42403944, '王凯',18,'男', '成都');
INSERT INTO student VALUES (42404019, '胡雅青',18,'女', '自贡');
INSERT INTO student VALUES (42404344, '申佳',18,'女', '遂宁');
INSERT INTO student VALUES (42404648, '蒋雪',18,'女', '广安');
INSERT INTO student VALUES (42404735, '周悦',18,'女', '达州');

 
SELECT * FROM student;



SELECT * from student where name like '%王%';