Basic SQL Tutorial

SQL Language Tutorial
SQL Introduction
SQL Syntax
SQL Create Database
SQL Create Table (CREATE TABLE)
SQL Constraints (Constraints)
SQL Insert Data (INSERT INTO)
SQL Query Data (Select)
SQL WHERE
SQL AND & OR
SQL IN & BETWEEN
SQL ORDER By
SQL TOP/LIMIT
SQL DISTINCT
SQL Update Data (UPDATE)
SQL Delete Data (DELETE)
SQL Truncate Table (TRUNCATE TABLE)
SQL Drop Table (DROP)

SQL Join (Join)

SQL Join Query (Join)
SQL INNER JOIN
SQL LEFT JOIN
SQL RIGHT JOIN
SQL FULL JOIN
SQL CROSS JOIN

Advanced SQL Tutorial

SQL UNION
SQL LIKE
SQL Alter Table (ALTER TABLE)
SQL Aliases (Aliases)
SQL GROUP BY
SQL HAVING
SQL Create View (CREATE VIEW)
SQL Create Index (CREATE INDEX)
SQL Date and Time
SQL Copy Table
SQL Temporary Table
SQL Subquery
SQL Injection (Injection)

SQL Reference Manual

MySQL Data Types
SQL Server Data Types
Comprehensive List of SQL Built-in Functions
SQL Keywords Quick Reference

SQL Keywords Quick Reference

Usage and Examples of SQL DATABASE Keyword

SQL Keywords Reference

CREATE DATABASE (Create Database)

The CREATE DATABASE command is used to create a new SQL database.

The following SQL creates a database named "testDB":

Example

CREATE DATABASE testDB;

Tip:Before creating any database, make sure you have administrative privileges. After creating a database, you can use the following SQL command to check it in the list of databases: SHOW DATABASES;

DROP DATABASE (Delete Database)

The DROP DATABASE command is used to delete an existing SQL database.

The following SQL deletes the database named "testDB":

Example

　　DROP DATABASE testDB;

Note:Be careful before deleting a database. Deleting a database will result in the loss of all information stored in the database!

SQL Keywords Reference

SQL Keywords Quick Reference