mysql 建立表格是要用反引号`(Esc键的下方),引用字段时也要用反引号`,而插入数据时用单引号'(L键的右边)
如:
--
-- Definition of table `tb_uploadFile`
--
DROP TABLE IF EXISTS `tb_uploadFile`;
CREATE TABLE `tb_uploadFile`(
`id` int(11) NOT NULL AUTO_INCREMENT,
`path` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=gbk;
--
-- Dumping data for table `tb_uploadFile`
--
/*!40000 ALTER TABLE `tb_uploadFile` DISABLE KEYS */;
INSERT INTO `tb_uploadFile` (`id`,`path`) VALUES
(1,'201004201340260341.jpg'),
(2,'201004201342270110.jpg'),
(3,'201004201359330922.jpg'),
(4,'201004201400560420.jpg'),//这些字符串要用单引号'
(5,'201004201401400092.jpg');
/*!40000 ALTER TABLE `tb_uploadFile` ENABLE KEYS */;
要不会出错,出现mysql unknown column in field list情况