MySQL学习笔记3

MySQL学习笔记 3
– 创建数据库
CREATE DATABASE ch_3_db;
– 连接数据库
USE ch_3_db;
CREATE TABLE test_1
(
a TINYINT,
b SMALLINT,
c MEDIUMINT,
d INT,
e BIGINT
);
DESC test_1;
INSERT INTO test_1 VALUES (123,1234,123456,1234567,12345678);
select * from test_1;

CREATE TABLE test_2
(
a TINYINT(2),
b SMALLINT(2),
c MEDIUMINT(2),
d INT(2),
e BIGINT(2)
);
DESC test_2;
INSERT INTO test_2 VALUES (123,1234,123456,1234567,12345678);
select * from test_2;

CREATE TABLE mp_1
(
X FLOAT(5,1),
Y DOUBLE(5,2),
Z DECIMAL(5,3)
);
DESC mp_1;
INSERT INTO mp_1 VALUES(3.141,3.14159,3.14119);
select * from mp_1;
– year
create table temp3(a year);
insert into temp3 values(‘10:10:10’);
select * from temp3;
– time
create table temp4(a time);
insert into temp4 values(‘10:10:10’);
select * from temp4;
insert into temp4 values(10:10:10);
insert into temp4 values(‘23:23’); (0.01 sec);
select * from temp4;
– date
create table temp5(b date);
insert into temp5 values(1999-11-31);
insert into temp5 values(‘1999-11-30’);
select * from temp5;
insert into temp5 values(19991120);
select * from temp5;