MySQL

-- 创建数据库
create database python_test charset=utf8;

-- 查看数据库
show databases;

-- 使用数据库
use python_test;

-- 显示当前使用那个数据库
select database();

-- 创建一个数据表  存0 1时使用bit 就行  bit(2)可以存4种 tinyint = bit(8)  2^8 = 256
create table studuent(
    id int unsigned primary key auto_increment not null,
    name varchar(20) default ‘‘,
    age tinyint unsigned default 0,
    height decimal (5,2),
    gender enum(, , 中性, 保密) default 保密,
    cls_id int unsigned default 0,
    is_delete bit default 0
);

create table class(
    id int unsigned auto_increment primary key not null,
    name varchar(30) not null
);

-- 向表中插入数据
insert into studuent values
    (0,小明,18,168.00,2,1,0),
    (0,小黄,17,175.00,1,2,0),
    (0,小红,14,177.00,2,3,0),
    (0,小汉,11,180.00,3,4,0),
    (0,小八,12,187.00,3,5,0),
    (0,小九,13,182.00,4,6,0),
    (0,小十,18,188.00,3,7,0),
    (0,小之,17,186.00,2,8,0),
    (0,小一,10,188.00,2,9,0),
    (0,小二,15,182.00,3,9,0),
    (0,小三,18,184.00,2,6,0),
    (0,小四,19,185.00,4,4,0),
    (0,小五,13,190.00,2,3,0),
    (0,小六,14,189.00,2,4,0),
    (0,小七,15,178.00,2,5,0),
    (0,十一,15,167.00,1,7,0),
    (0,十二,18,176.00,1,2,0);

insert into class values
    (0, "python01期"),
    (0, "python02期"),
    (0, "python04期");

show tables ;

desc class;

select * from studuent;

 

MySQL

上一篇:Oracle 19c快速安装部署


下一篇:docker mysql5.7主从复制搭建(双主双从)