创建表是报错 1067 找不到什么地方错呀

Question

DROP TABLE IF EXISTS `goods`;
CREATE TABLE `goods` (
  `gdID` int(11) NOT NULL AUTO_INCREMENT,
  `tID` int(11) DEFAULT NULL,
  `gdCode` varchar(50) DEFAULT NULL,
  `gdName` varchar(100) NOT NULL,
  `gdPrice` float DEFAULT '0',
  `gdQuantity` int(11) DEFAULT '0',
  `gdSaleQty` int(11) DEFAULT '0',
  `gdCity` varchar(100) DEFAULT '长沙',
  `gdInfo` longtext NOT NULL,
  `gdAddTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `gdHot` tinyint(11) DEFAULT '0',
  `gdImage` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`gdID`),
  KEY `FK_Reference_10` (`tID`),
  CONSTRAINT `FK_Reference_10` FOREIGN KEY (`tID`) REFERENCES `goodstype` (`tID`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

报错ERROR 1067 (42000): Invalid default value for 'gdCity'

 

 

Answer 1

"长沙" 双引号