н¨±ísqlÓï¾äÈçÏ£¬ÔÚnavicat for mysql ÖÐÔËÐУ¬±¨´í¡£
CREATE TABLE `t_article`(
`bh` bigint(20) NOT NULL PRIMARY KEY AUTO_INCREMENT COMMENT '񅧏',
`wztm` varchar(100) DEFAULT NULL COMMENT 'ÎÄÕÂÌâÄ¿',
`wznr` text COMMENT 'ÎÄÕÂÄÚÈÝ',
`lb` char(1) DEFAULT NULL COMMENT 'ÎÄÕÂÀà±ð',
`tjsj` datetime DEFAULT NULL COMMENT 'Ìύʱ¼ä',
`zz` char(50) DEFAULT NULL COMMENT '×÷Õß',
`shzt` char(1) DEFAULT '1' COMMENT 'ÉóºË״̬',
`fbsj` datetime DEFAULT NULL COMMENT '·¢²¼Ê±¼ä',
`gqsj` datetime DEFAULT NULL COMMENT '¹ýÆÚʱ¼ä',
`sfzd` char(1) DEFAULT NULL COMMENT 'ÊÇ·ñÖö¥',
`zdsj` datetime DEFAULT NULL COMMENT 'Öö¥Ê±¼ä',
`shsj` datetime DEFAULT NULL COMMENT 'ÉóºËʱ¼ä',
`shry` char(12) DEFAULT '' COMMENT 'ÉóºËÈËÔ±',
`scwjlj` varchar(100) DEFAULT NULL COMMENT ' ÉÏ´«Îļþ·¾¶',
`wztp` char(50) DEFAULT NULL COMMENT 'ÎÄÕÂͼƬ',
`djcs` int(11) DEFAULT NULL COMMENT 'µã»÷´ÎÊý',
`tzlb` char(20) DEFAULT NULL COMMENT '֪ͨÀà±ð(²¿ÃűàºÅ)',
`tzlbmc` char(40) DEFAULT NULL COMMENT 'ËùÊô²¿ÃÅÃû³Æ',
`bz` varchar(10) DEFAULT NULL,
)ENGINE=InnoDB AUTO_INCREMENT=105 DEFAULT CHARSET=utf8 COMMENT='±í22£ºÎÄÕÂÐÅÏ¢±í';
´íÎóÈçÏ£º
[Err] 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 ¡®)ENGINE=InnoDB AUTO_INCREMENT=105 DEFAULT CHARSET=utf8 COMMENT=¡¯±í22£ºÎÄÕÂ?¡¯ at line 21
½â¾ö£ºÈ¥µô¡°bz varchar(10) DEFAULT NULL,¡±Öеġ°£¬¡±¡£