Error 1046 No database Selected, how to resolve?

Question

Error 1046 No database Selected, how to resolve?

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.

sql mysql-error-1046 mysql

4 years ago by vishaljlf39

2 Answers

Login / Signup to Answer the Question.

Login Signup

**aashaykumar** · Answer 1 · 2021-08-04T13:20:03

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;

**RoliMishra** · Answer 2 · 2021-08-05T12:41:55

You can also tell MySQL what database to use (if you have it created already):

mysql -u example_user -p --database=example < ./example.sql

C TUTORIAL

C PROGRAMS

INTERVIEW TESTS

EXECUTE CODE

C++ TUTORIAL

C++ PROGRAMS

INTERVIEW TESTS

EXECUTE CODE

PYTHON TUTORIAL

PYTHON HOW TOS

INTERVIEW TESTS

EXECUTE CODE

JAVA TUTORIAL

JAVA CODE EXAMPLES

SPRING TUTORIAL

MORE IN JAVA

COMPUTER ARCHITECTURE

COMPUTER NETWORK

OPERATING SYSTEM

DBMS & SQL

PL/SQL

MongoDB

EXECUTE SQL

ANDROID DEVELOPMENT

GO LANGUAGE

LINUX

DOCKER

HTML TAGS (A to Z)

CSS REFERENCES

SASS/SCSS

KOTLIN

GAME DEVELOPMENT

PHP

GIT GUIDE

JAVASCRIPT

ADVANCED DSA

Error 1046 No database Selected, how to resolve?

2 Answers

Login / Signup to Answer the Question.