2 u012513463 u012513463 于 2016.03.12 00:14 提问

求大神~ 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个回答

qq423399099
qq423399099   Ds   Rxr 2016.03.12 10:04
已采纳

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

u012513463
u012513463   2016.03.12 00:18

错误
SQL 查询:

-- Table structure for table pre_addon_download_attachment

DROP TABLE IF EXISTS pre_addon_download_attachment ;

MySQL 返回:

#1046 - No database selected

oyljerry
oyljerry   Ds   Rxr 2016.03.12 09:21

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

qq_25093755
qq_25093755   2016.03.12 11:07

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

qq_30408111
qq_30408111   2016.03.12 17:01

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

Csdn user default icon
上传中...
上传图片
插入图片
准确详细的回答,更有利于被提问者采纳,从而获得C币。复制、灌水、广告等回答会被删除,是时候展现真正的技术了!