Appserv代码错误#1064-You have an error in your SQL syntax;check the manual that corr
CREATE TABLE amercement('AmerceNO'number, 'BorrowNO'number, 'StudentNO'VARCHAR, 'Detail'VARCHAR( 20 ) NOT NULL , 'Mulct'number( 5, 2 ) NOT NULL , 'Pay'number( 1 ) default 0, 'PayTime'varchar( 20 ) , PRIMARY KEY ( 'AmerceNO' ) , FOREIGN KEY ( 'BorrowNO' ) REFERENCES borrow_list( 'BorrowNO' ) ON DELETE CASCADE , FOREIGN KEY ( 'StudentNO' ) REFERENCES student( 'StudentNO' ) ON DELETE CASCADE
) ENGINE = MYISAM
MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''AmerceNO' number , 'BorrowNO' number, 'StudentNO' VARCHAR, 'Detail' VARCH' at line 3
最新回答
晴时不见荷
2025-06-26 04:45:05
1、不能用
单引号
(‘)应该用(`)，也可以不用引号。2、VARCHAR类型必须指定大小。
3、mysql中用的是numeric而不是number。
修改后的sql
CREATE TABLE amercement(
`AmerceNO` numeric,
`BorrowNO` numeric,
`StudentNO` VARCHAR(20),
`Detail` VARCHAR(20) NOT NULL,
`Mulct` numeric(5, 2) NOT NULL,
`Pay` numeric(1) default 0,
`PayTime` VARCHAR(20),
PRIMARY KEY (`AmerceNO`) ,
FOREIGN KEY (`BorrowNO`) REFERENCES borrow_list(`BorrowNO`) ON DELETE CASCAD,
FOREIGN KEY (`StudentNO`) REFERENCES student(`StudentNO`) ON DELETE CASCADE
) ENGINE = MYISAM
随风而去
2025-06-26 05:54:12
追问
抄错代码了，改过来还是不对啊
星恋影随
2025-06-26 00:10:39
风伴终生
2025-06-26 03:27:49
热门标签
