Check out example codes for "create database sql". It will help you in understanding the concepts better.

Code Example 1

CREATE DATABASE databasename;

Code Example 2

CREATE DATABASE database;

Code Example 3

SHOW DATABASES;
 DROP DATABASE testDB;
 USE DatabaseName;
 
 SQL> CREATE TABLE CUSTOMERS(
   ID   INT              NOT NULL,
   NAME VARCHAR (20)     NOT NULL,
   AGE  INT              NOT NULL,
   ADDRESS  CHAR (25) ,
   SALARY   DECIMAL (18, 2),       
   PRIMARY KEY (ID)
);

DESC CUSTOMERS;

Code Example 4

CREATE TABLE example (
    id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
    username VARCHAR(50) NOT NULL UNIQUE,
    password VARCHAR(255) NOT NULL,
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP

);

Learn ReactJs, React Native from akashmittal.com