CREATE DATABASE schooljava;
USE schooljava;
CREATE TABLE student (
id INT(11),
name VARCHAR(25),
tel INT(11),
sex VARCHAR(6)
);
DESC student;
INSERT INTO student VALUES
-> (1,'张三',1234567890,'男'),
-> (2,'李四',1234567890,'男'),
-> (3,'王五',1234567890,'男'),
-> (4,'老六',1234567890,'男'),
-> (5,'小明',1234567890,'男'),
-> (6,'小红',1234567890,'女'),
-> (7,'小玲',1234567890,'女'),
-> (8,'小兰',1234567890,'女'),
-> (9,'小刘',1234567890,'男'),
-> (10,'小郑',1234567890,'男');