1、创建数据库名:school
create database school;
2、查看所有数据库
show databases;
3、使用数据库:school
use school;
4、创建学生表:students
create table students(
id int not null primary key,
name varchar(20),
sex varchar(3),
age smallint,
create_time date,
height float,
weight float,
class varchar(20)
);
5、插入数据
insert into students
(id,name,sex,age,create_time,height,weight,class)
values
(1, ‘李白’, ‘男’, 18, ‘2019-10-5’,180.4, 100, ‘测试开发一班’),
(2, ‘韩信’, ‘男’, 18, ‘2019-10-5’,179.4, 102, ‘测试开发二班’),
(3, ‘露娜’, ‘女’, 16, ‘2019-10-2’,172.4, 90, ‘测试开发二班’),
(4, ‘镜’ , ‘女’, 17, ‘2019-10-1’,175.4, 91, ‘测试开发二班’),
(5, ‘耀’, ‘男’, 15, ‘2019-10-1’,170.4, 100, ‘测试开发二班’),
(6, ‘云中君’, ‘男’, 18, ‘2019-10-2’,179.4, 92, ‘测试开发一班’),
(7, ‘瑶’, ‘女’, 16, ‘2019-10-2’,165.4, 80, ‘测试开发一班’),
(8, ‘西施’ , ‘女’, 17, ‘2019-10-1’,172.4, 91, ‘测试开发二班’),
(9, ‘玄
Mysql语言的基础知识
最新推荐文章于 2023-05-19 11:55:09 发布