mysql笔记（9.26）

字节Byte 通，短 高电平，低电平 0，1

211 11001101 位数=byte=两种状态 1，0小b

1Byte = 8 byte 11100001

汉字 = 2~3字节Byte

1024Byte = 1KB

1KB *1024 =1MB

1MB*1024 =1GB

 

 

create_date timestamp default current_timestamp ——时间戳

create table user(

id int primary key auto_increment COMMENT'主键',

name varchar(32),

age INT,

price double(5,2),

create_date TIMESTAMP default CURRENT_TIMESTAMP);

create table user( id int primary key auto_increment COMMENT'主键', name varchar(32), age INT, price double(5,2), create_date TIMESTAMP default CURRENT_TIMESTAMP);

select * from user;

insert into user(name,age,price) values('丁真',18,18.18); insert into user(name,age,price) values('芝士雪豹',16,16.16), ('锐刻',3,3.33);

update user set name='锐刻五代' where id=3;

delete from user where id>3;

select*from user;

create table user1 as select * from user where id>3;

create table user2 as select * from user where 1=2;

create table user3 as select * from user;

select * from user1;

select * from user2;

select * from user3;