当我尝试将SQL文件上传到PHPMyAdmin时，我收到了此错误。
SQL query: Dumping data for table data
INSERT INTO `data` (`id`, `name`, `dt`, `console`, `age`) VALUES
(1, 'abc', '1/june/2015', 'abc','123'),
;
MySQL said: Documentation
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 '' at line 6
phpMyAdmin SQL转储
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `datasorter`
--
-- --------------------------------------------------------
--
-- Table structure for table `data`
--
CREATE TABLE IF NOT EXISTS `data` (
`id` int(20) NOT NULL AUTO_INCREMENT,
`name` varchar(1000) NOT NULL,
`dt` varchar(500) NOT NULL,
`console` varchar(1000) NOT NULL,
`age` varchar(1000) NOT NULL, PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
--
-- Dumping data for table `data`
--
INSERT INTO `data` (`id`, `name`, `dt`, `console`, `age`) VALUES
(1, 'abc', '1/june/2015', 'abc','123'),
;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
删除分号前的逗号：
INSERT INTO `data` (`id`, `name`, `dt`, `console`, `age`) VALUES
(1, 'abc', '1/june/2015', 'abc','123'),
;
应为：
INSERT INTO `data` (`id`, `name`, `dt`, `console`, `age`) VALUES
(1, 'abc', '1/june/2015', 'abc','123');
SqlFiddleDemo
将dt存储为VARCHAR是非常糟糕的做法。请考虑使用正确的数据类型。
Age应该是计算/生成的列，除非您想每年更新它。
删除'age') 后的逗号
INSERT INTO `data` (`id`, `name`, `dt`, `console`, `age`) VALUES (1, 'abc', '1/june/2015', 'abc','123');
您的查询末尾有一个额外的逗号：
INSERT INTO `data` (`id`, `name`, `dt`, `console`, `age`) VALUES
(1, 'abc', '1/june/2015', 'abc','123'),;
^^
Here
只需将其更改为：
INSERT INTO `data` (`id`, `name`, `dt`, `console`, `age`) VALUES
(1, 'abc', '1/june/2015', 'abc','123');