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

You need to tell MySQL which database to use:

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;