照sql教程书上打的例子,但是在mysql中报错
#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 'TNAME char(20) NOT NULL, TITLE char(20), Primary key(T#) )' at line 4
请教下到底是哪里的问题呀
CREATE TABLE T
(
T# char(4) NOT NULL,
TNAME char(20) NOT NULL,
TITLE char(20),
Primary key(T#)
);
#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 'TNAME char(20) NOT NULL, TITLE char(20), Primary key(T#) )' at line 4
请教下到底是哪里的问题呀
CREATE TABLE T
(
T# char(4) NOT NULL,
TNAME char(20) NOT NULL,
TITLE char(20),
Primary key(T#)
);
(
T char(4) NOT NULL,
TNAME char(20) NOT NULL,
TITLE char(20),
Primary key(T)
);
-> (
-> `T#` char(4) NOT NULL,
-> TNAME char(20) NOT NULL,
-> TITLE char(20),
-> Primary key(`T#`)
-> );
Query OK, 0 rows affected (0.06 sec)
(
T char(4) NOT NULL,
TNAME char(20) NOT NULL,
TITLE char(20),
Primary key(T)
);
(
T char(4) NOT NULL,
TNAME char(20) NOT NULL,
TITLE char(20),
Primary key(T)
);
CREATE TABLE `fx_car_message` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`cartype` varchar(20) COLLATE gb2312_chinese_ci NOT NULL DEFAULT '',
`carbrand` varchar(20) COLLATE gb2312_chinese_ci NOT NULL DEFAULT '',
`type` varchar(20) COLLATE gb2312_chinese_ci NOT NULL DEFAULT '',
`timeforbuy` varchar(100) COLLATE gb2312_chinese_ci NOT NULL DEFAULT '',
`carid` varchar(100) COLLATE gb2312_chinese_ci DEFAULT NULL,
`cartag` varchar(100) COLLATE gb2312_chinese_ci DEFAULT NULL,
`ownerofcar` varchar(100) COLLATE gb2312_chinese_ci NOT NULL DEFAULT '',
`phone` varchar(20) COLLATE gb2312_chinese_ci NOT NULL DEFAULT '',
`workid` varchar(100) COLLATE gb2312_chinese_ci NOT NULL DEFAULT '',
`department` varchar(100) COLLATE gb2312_chinese_ci NOT NULL DEFAULT '',
`status` tinyint(2) NOT NULL DEFAULT '0',
`comment` longtext COLLATE gb2312_chinese_ci,
PRIMARY KEY (`id`),
UNIQUE KEY `fx_car_uix` (`carid`),
UNIQUE KEY `fx_car_uix2` (`cartag`),
KEY `fx_car_typ2_ix` (`type`),
KEY `fx_car_own_ix` (`ownerofcar`),
KEY `fx_car_wk_ix` (`workid`),
KEY `fx_car_apt_ix` (`department`),
KEY `fx_car_stu_ix` (`status`)
)ENGINE=InnoDB DEFAULT CHARSET=gb2312 COLLATE=gb2312_chinese_ci
COMMENT='One record for each car'