mysql - 将 .sql 导入 phpMyAdmin 数据库时出错

Question

我想将 SQL 文件导入到我的 phpMyAdmin 数据库中，该文件包含有关餐厅应用程序的表和有关管理员登录的表，但我有 2 个意外错误，我真的不明白到底出了什么问题？。这是错误消息:

2 errors were found during analysis.

An opening bracket followed by a set of values was expected. (near "CREATE" at position 109)
Unexpected token. (near "CREATE" at position 109)
SQL query:

INSERT INTO `adminlogin` (`id`, `Username`, `Password`, `right`) VALUES (1, 'admin@gmail.com', '123', 1), CREATE TABLE IF NOT EXISTS `tbl_food` ( `id` int(11) NOT NULL AUTO_INCREMENT, `food_type` varchar(50) NOT NULL, `food_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1

MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `tbl_food` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
' at line 6

这是显示错误的两个表。对此有何见解？谢谢

CREATE TABLE IF NOT EXISTS `adminlogin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Username` varchar(100) NOT NULL,
  `Password` varchar(50) NOT NULL,
  `right` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `adminlogin`
--

INSERT INTO `adminlogin` (`id`, `Username`, `Password`, `right`) VALUES
(1, 'admin@gmail.com', '123', 1),

-- --------------------------------------------------------

--
-- Table structure for table `tbl_food`
--

CREATE TABLE IF NOT EXISTS `tbl_food` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `food_type` varchar(50) NOT NULL,
  `food_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

Answer 1

INSERT 语句末尾有一个逗号，而不是分号。