MySQL数据类型
create database dbname;
create database if not exits `dbshop` default charset utf8;
show databases;
use dbname;
select CURRENT_USER,user(),database(),now();
show tables
create table t_user(
id int(3) UNSIGNED ZEROFILL auto_increment,
name varchar(10) not null,
age tinyint UNSIGNED default 18,
address varchar(50),
primary key(id)
)engine=innodb charset=utf8 auto_increment=10
show tables;
select * from t_user;
insert into t_user value(null,'李四',22,'河南郑州');
insert t_user set name='张三丰',address='北京朝阳区';
drop table if exists `t_user`;
show tables
create table tt1(
c1 tinyint(6) UNSIGNED ZEROFILL,
c2 bigint,
c3 decimal(6,2)
)
insert tt1 value(5,6,7);
insert tt1 value(5.5,6.6,7.7);
insert tt1 value(5.5,6.6,10000);
select * from tt1;
本人也正在学习,如有不当或错误之处,恳请您的指正,谢谢!!!