求大神~ MySQL数据库导入失败

错误
SQL 查询:

-- phpMyAdmin SQL Dump
-- version 4.0.10.7

-- http://www.phpmyadmin.net

-- 涓绘-------------------------------------

-- 琛ㄧdmin', 0, '', 0, 0, 'blank', 'Y-m-d', 0, 'line', 'a:2:{s:5:"style";s:4:"dash";s:5:"items";s:2:"10";}', 10, 0, '', 0, 0, 1444481460, 0, 0),
( 488, 'html_html', 0, '', '', '', '


', 1, 'admin', 0, '', 0, 0, 'blank', '', 0, 'line', 'a:2:{s:5:"style";s:4:"dash";s:5:"items";s:1:"0";}', 10, 0, '', 0, 0, 1444481460, 0, 0 ) , ( 489, 'html_html', 0, '', '', '', '
', 1, 'admin', 0, '', 0, 0, 'blank', '', 0, 'line', 'a:2:{s:5:"style";s:4:"dash";s:5:"items";s:1:"0";}', 10, 0, '', 0, 0, 1444481459, 0, 0 ) ;

MySQL 返回:

#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 '488, 'html_html', 0, '', '', '', '


', 1, 'admin', 0, '', 0, 0,' at line 9

5个回答

LZ先选择好数据库名,然后SOURCE导入
mysql> USE 数据库名;
mysql> SOURCE d:/test.sql;

错误
SQL 查询:

-- Table structure for table pre_addon_download_attachment

DROP TABLE IF EXISTS pre_addon_download_attachment ;

MySQL 返回:

#1046 - No database selected

先选择database 然后再倒入数据到表

没选择数据库,No database selected不是写着的

没有选中数据库,use 数据库名
然后在进行操作

Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
立即提问