发布时间:2022-09-06 16:00
show databases;
CREATE DATABASE ssh;
use ssh;
show tables;
select * from tbl_user;
create table tbl_user(
username varchar(50) not null PRIMARY KEY comment'用户名',
password varchar(50) not null comment'密码',
gender int(11) default'0' comment'性别',
birthDate date default null comment'出生日期',
tel varchar(255) default null comment'联系电话',
email varchar(255) default null comment'Email',
url varchar(255) default null comment'个人首页'
)ENGINE=InnoDB DEFAULT CHARSET=gb2312 comment='用户信息表';