SQL Database
To establish a new SQL database, use the CREATE DATABASE statement.
CREATE DATABASE databasename;
A database named “testDB” is created with the SQL query that follows:
CREATE DATABASE testDB;
Tip: Before creating any databases, confirm that you have administrator privileges. After a database is created, use the following SQL query to view it in the list of databases: Show databases;
CodingAsk.com is designed for learning and practice. Examples may be made simpler to aid understanding. Tutorials, references, and examples are regularly checked for mistakes, but we cannot guarantee complete accuracy. By using CodingAsk.com, you agree to our terms of use, cookie, and privacy policy.
Copyright 2010-2024 by Refsnes Data. All Rights Reserved.