Error 1046 No database Selected, how to resolve?

Question

Error SQL query:

--

-- 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:

#1046 - No database selected

need some help here.

Answer 1

Before creating the table, you need to specify which database you are using in MYSQL. 

USE db_name;

Are you interested in learning SQL from the basics! Refer to this video on SQL provided by Intellipaat:

If in case the database does not exist, then you should create it as:

CREATE DATABASE db_name;

Which needs to be followed by:

USE db_name;