phpmyadmin导入数据库错误 [英] phpmyadmin import database error

问题描述

我尝试通过phpmyadmin在本地主机上导入MySQL数据库，并且收到此错误.这是什么意思?而我该如何解决呢?有什么想法吗?

I try to import a MySQL database on the localhost through phpmyadmin and i receive this error. what it means? and how can i solve it? any ideas?

SQL query:

--
-- Database: `casasdl_mag`
--
--
-- Database: `casasdl`
--
-- --------------------------------------------------------
--
-- Table structure for table `admin_assert`
--
CREATE TABLE IF NOT EXISTS  `admin_assert` (

 `assert_id` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT  'Assert ID',
 `assert_type` VARCHAR( 20 ) DEFAULT NULL COMMENT  'Assert Type',
 `assert_data` TEXT COMMENT  'Assert Data',
PRIMARY KEY (  `assert_id` )
) ENGINE = INNODB DEFAULT CHARSET = utf8 COMMENT =  'Admin Assert Table' AUTO_INCREMENT =1;

MySQL said: Documentation

#1046 - No database selected  

推荐答案

创建表时，需要选择要插入该表的数据库

When you create a table you need to select a database for that table to insert into

USE databaseName;

在脚本之前运行

USE casasdl;
CREATE TABLE IF NOT EXISTS  `admin_assert` (

 `assert_id` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT  'Assert ID',
 `assert_type` VARCHAR( 20 ) DEFAULT NULL COMMENT  'Assert Type',
 `assert_data` TEXT COMMENT  'Assert Data',
PRIMARY KEY (  `assert_id` )
) ENGINE = INNODB DEFAULT CHARSET = utf8 COMMENT =  'Admin Assert Table' AUTO_INCREMENT =1;

这篇关于phpmyadmin导入数据库错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！