MySql(1204)建表查表

MySql(1204)建表查表

create  database F_S;
use F_S;
create table user_profile(
    id int,
    device_id char(4),
    gender varchar(2),  #COMMENT'这里是2的话，字节不够，无法写入'（运行删除注释）
    age int,
    university varchar(6),
    province varchar(10)
);
alter table user_profile modify gender varchar(8);    #comment'这里修改了数据类型，变成了可变字符8'
desc user_profile;
insert into user_profile(id,device_id,gender,age,university,province) values(1,'2138','male',21,'北京大学','Beijing'),
      (2,'3214','male',null,'复旦大学','Shanghai'),
      (3,'6543','female',20,'北京大学','Beijing'),
      (4,'2315','female',23,'浙江大学','ZheJiang'),
      (5,'5432','male',25,'山东大学','ShangDong');
select id,device_id,gender,age,university,province from user_profile;

最后一句等价于 “select * from user_profile”

输出