create table EXPERIENCE_CASE(
ID int primary key not null auto_increment,
BUSINESS_ID int,
CASE_CODE varchar(100),
CASE_NAME varchar(300),
CASE_PRIORITY int,
CASE_RESULT int,
EXECUIT_PEOPLE int,
EXECUIT_PEOPLE_PHONE varchar(32),
EXECUIT_TIME datetime,
ISERROR int,
REMARK text,
ISTEMPORARY int,
MANUFACTURER_EXCHANGE varchar(500),
PROBLEM_PROPERTY varchar(300),
USER_INFLUENCE varchar(500),
SOLUTION varchar(300),
MANUFACTURER_REPLY varchar(1000),
TRANSACTOR_REPLY varchar(1000),
TEM_TIME datetime,
OPERATOR_REPLY varchar(1000),
COM_MODELS varchar(1000),
BASE_CASEINFO_ID int,
FAULT_SIGN int,
foreign KEY (BUSINESS_ID) references BUSINESS_INFO(BUSINESS_ID)
)engine=innodb default character set =utf8;mysql建表时报
Can't create table 'ttms.experience_case' (errno: 150)
这个错误是怎么回事?
ID int primary key not null auto_increment,
BUSINESS_ID int,
CASE_CODE varchar(100),
CASE_NAME varchar(300),
CASE_PRIORITY int,
CASE_RESULT int,
EXECUIT_PEOPLE int,
EXECUIT_PEOPLE_PHONE varchar(32),
EXECUIT_TIME datetime,
ISERROR int,
REMARK text,
ISTEMPORARY int,
MANUFACTURER_EXCHANGE varchar(500),
PROBLEM_PROPERTY varchar(300),
USER_INFLUENCE varchar(500),
SOLUTION varchar(300),
MANUFACTURER_REPLY varchar(1000),
TRANSACTOR_REPLY varchar(1000),
TEM_TIME datetime,
OPERATOR_REPLY varchar(1000),
COM_MODELS varchar(1000),
BASE_CASEINFO_ID int,
FAULT_SIGN int,
foreign KEY (BUSINESS_ID) references BUSINESS_INFO(BUSINESS_ID)
)engine=innodb default character set =utf8;mysql建表时报
Can't create table 'ttms.experience_case' (errno: 150)
这个错误是怎么回事?
解决方案 »
- Mysql中,判断表是否存在。
- 请教一个简单的查询问题
- 库名不同如何做复制
- load data infile的局限性
- 关于load data local 问题?
- mysql-front的汉化显示问题
- mysql如何同时支持简体中文和繁体中文
- why?
- 我下载了phptriad(php4+mysql3.2+apache),但我运行C:\apache\php\php.exe,却提示:Error parsing ./browscap/browscap.ini on line 8206,请高手帮忙,多谢!
- MySQL用语句导入txt文件的问题
- MySQL是否支持类似PL/SQL方式的查询
- 关于两表数据相减
create table EXPERIENCE_CASE(
ID int primary key not null auto_increment,
BUSINESS_ID int(10),
CASE_CODE varchar(100),
CASE_NAME varchar(300),
CASE_PRIORITY int,
CASE_RESULT int,
EXECUIT_PEOPLE int,
EXECUIT_PEOPLE_PHONE varchar(32),
EXECUIT_TIME datetime,
ISERROR int,
REMARK text,
ISTEMPORARY int,
MANUFACTURER_EXCHANGE varchar(500),
PROBLEM_PROPERTY varchar(300),
USER_INFLUENCE varchar(500),
SOLUTION varchar(300),
MANUFACTURER_REPLY varchar(1000),
TRANSACTOR_REPLY varchar(1000),
TEM_TIME datetime,
OPERATOR_REPLY varchar(1000),
COM_MODELS varchar(1000),
BASE_CASEINFO_ID int,
FAULT_SIGN int,
foreign KEY (BUSINESS_ID) references BUSINESS_INFO(BUSINESS_ID)
)ENGINE=MyISAM DEFAULT CHARSET=utf8;