56,677
社区成员
发帖
与我相关
我的任务
分享
错误码: 1025
Error on rename of '.\zly\#sql-5c8_1' to '.\zly\login' (errno: 150 - Foreign key constraint is incorrectly formed)
Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000
CREATE TABLE login (
username VARCHAR(20) PRIMARY KEY ,
userpassword VARCHAR(20) NOT NULL,
LEVEL TINYINT(4) NOT NULL,DEFAULT 0,
POINT INT(11) DEFAULT 0,
NAME VARCHAR(20) UNIQUE,
dgtime DATETIME NOT NULL);
准备建立的表CREATE TABLE images (
image_id INT AUTO_INCREMENT PRIMARY KEY,
image_user VARCHAR(20),
image_path VARCHAR(30),
FOREIGN KEY (image_user) REFERENCES login(username) ON DELETE CASCADE);