MySql throw no database selected, select the default DB to be used by double-clicking its name

Dung Do Tien Mar 05 2022 29

Hello, I have created a database name is 'chromenotification' in MySql. 

I used MySQL Workbench 8.0 CE to create the database and run the command below to create a table:

CREATE TABLE `notifyhistory` (
   `NotifyHistoryId` int NOT NULL AUTO_INCREMENT,
   `UserId` int DEFAULT NULL,
   `PushDate` datetime DEFAULT NULL,
   `Status` bit(1) DEFAULT NULL,
   `Message` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `Title` varchar(100) DEFAULT NULL,
   `Link` varchar(150) DEFAULT NULL,
   PRIMARY KEY (`NotifyHistoryId`),
   UNIQUE KEY `NotifyHistoryId_UNIQUE` (`NotifyHistoryId`)
 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci

But I got an exception No database selected. Select the default DB to be used by double-clicking its name in the SCHEMAS list in the sidebar.

Error Code: 1046. No database selected
Select the default DB to be used by double-clicking its name in the SCHEMAS list in the sidebar.    0.063 sec

How can I select the default database, I find but have not found any dropdown or anything to help set the default database.

Thanks for any help.

Have 2 answer(s) found.
  • S

    Saurabh Shukla Mar 05 2022

    You can run the command USE Your_DB_Name; first. For example:

    USE chromenotification;

CREATE TABLE `notifyhistory1` (
   `NotifyHistoryId` int NOT NULL AUTO_INCREMENT,
   `UserId` int DEFAULT NULL,
   `PushDate` datetime DEFAULT NULL,
   `Status` bit(1) DEFAULT NULL,
   `Message` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
   `Title` varchar(100) DEFAULT NULL,
   `Link` varchar(150) DEFAULT NULL,
   PRIMARY KEY (`NotifyHistoryId`),
   UNIQUE KEY `NotifyHistoryId_UNIQUE` (`NotifyHistoryId`)
 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci    

    You only need run USE command once time.

  • s

    swarupa Mar 05 2022

    It's so easy, you can add more DB name before the name of the table.

    CREATE TABLE `googlenotification`.`notifyhistory`();

    it will be worked for you.

Related Q&A May You Like

  1. How to generate whole sql database script in MySql Workbench
  2. Error querySrv ENODATA _mongodb._tcp.456d in MongoDB Compass
  3. What is best way to convert datetime to date in Sql Server?
  4. How to compare date without time with now() in PostgreSQL?
  5. MySQL Error Code: 1175. safe update mode update a table without a WHERE
  6. ERROR 1819 (HY000): Your password does not satisfy the current policy requirements in MySQL
  7. ERROR: column must appear in the GROUP BY clause or be used in an aggregate function in PostgreSQL
  8. Calculating distance between two positions(lat, long) in SQL Server
  9. MySQL Error: 'Access denied for user 'root'@'localhost'
  10. Error: /opt/lampp/bin/mysql.server: 264: kill: No such process
  11. How to get the total of current connection in PostgreSQL?
  12. How to backup and restore MSSQL Server database in Ubuntu
  13. ERROR: OFFSET must not be negative in PostgreSQL
  14. How to update top N records for a table in PostgreSQL?
  15. PostgreSQL Error: Terminating connection due to administrator command
Leave An Answer
* NOTE: You need Login before leave an answer

* Type maximum 2000 characters.

* All comments have to wait approved before display.

* Please polite comment and respect questions and answers of others.

Most Quizs Popular

Start Test

Javascript - Functions
Start Test

Asp.Net Core - Exam test 01
Start Test

Asp.Net Core - Exam test 02
Start Test

C# - Level Beginner

Popular Tips

This site uses cookies so that we can remember you and understand how you interact with our website. This allows us to improve and customize your browsing experience. See our Cookies Policy.
X Close