崩溃了.......
mysql 为什么没有像mssql那样的查询分析器啊,找了个可视化操作的软件 MySql-Front ,可写了段sql 语句却不能找错,我实在看不出来.
我写的一段SQL语句
create table user_info(
user_id varchar(10) primary key,
user_name_EN varchar(20) not null,
user_name_CN varchar(10) not null,
user_sex enum('男','女') not null default '男',
user_birth date not null,
user_photo varchar(20) not null,
user_email varchar(50) ,
user_password varchar(16) not null,
user_xi varchar(50) not null,
user_suo varchar(50) not null,
user_xueyuan varchar(50) not null,
user_xuekefangxiang varchar(50) not null,
user_xueli varchar(50) not null,
user_xuewei varchar(50) not null,
user_biyeyuanxiao varchar(50) not null,
user_biyeshijian date not null,
user_zhicheng varchar(50) not null,
user_shuodao enum('是','否') not null default '否',
user_jianjie varchar(255),
user_privilege_level varchar(10) not null,
user_quanxian_special varchar(10),
user_lunwen_shuliang int(3) not null,
user_xiangmu_shuliang int(3) not null,
user_huodong_shuliang int(3) not null,
creator varchar(20) not null,
create_time datetime not null,
shenhe_flag enum('已审核','未审核') not null default '未审核',
shenheren_name varchar(20),
shenheren_time datetime
)
charset=gbk collate=gbk_chinese_ci;
谁有mysql 能差错功能的软件,非常感谢!