sql - 错误1046未选择数据库，如何解决？(Error 1046 No database Selected, how to resolve?)

Question

Error SQL query:

(错误的SQL查询：)

--
-- Database: `work`
--
-- --------------------------------------------------------
--
-- Table structure for table `administrators`
--
CREATE TABLE IF NOT EXISTS `administrators` (

`user_id` varchar( 30 ) NOT NULL ,
`password` varchar( 30 ) NOT NULL ) ENGINE = InnoDB DEFAULT CHARSET = latin1;

MySQL said:

(MySQL说：)

#1046 - No database selected

need some help here.

(在这里需要一些帮助。)

  ask by steph translate from so

Answer 1

You need to tell MySQL which database to use:

(您需要告诉MySQL要使用哪个数据库：)

USE database_name;

before you create a table.

(在创建表之前。)

In case the database does not exist, you need to create it as:

(如果数据库不存在，则需要按以下方式创建它：)

CREATE DATABASE database_name;

followed by:

(其次是：)

USE database_name;