create database sql

1CREATE DATABASE databasename;

1CREATE TABLE example (
2    id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
3    username VARCHAR(50) NOT NULL UNIQUE,
4    password VARCHAR(255) NOT NULL,
5    created_at DATETIME DEFAULT CURRENT_TIMESTAMP
6
7);

1CREATE table songs (
2  id INTEGER PRIMARY KEY AUTOINCREMENT,
3  title TEXT,
4  artist TEXT,
5  mood TEXT,
6  duration INTEGER,
7  released INTEGER);
8INSERT INTO songs (title, artist, mood, duration, released)
9    VALUES ("Bohemian Rhapsody", "Queen", "epic", 60, 1975);
10INSERT INTO songs (title, artist, mood, duration, released)
11    VALUES ("Let it go", "Idina Menzel", "epic", 227, 2013);
12INSERT INTO songs (title, artist, mood, duration, released)
13    VALUES ("I will survive", "Gloria Gaynor", "epic", 198, 1978);
14INSERT INTO songs (title, artist, mood, duration, released)
15    VALUES ("Twist and Shout", "The Beatles", "happy", 152, 1963);
16INSERT INTO songs (title, artist, mood, duration, released)
17    VALUES ("La Bamba", "Ritchie Valens", "happy", 166, 1958);
18INSERT INTO songs (title, artist, mood, duration, released)
19    VALUES ("I will always love you", "Whitney Houston", "epic", 273, 1992);
20INSERT INTO songs (title, artist, mood, duration, released)
21    VALUES ("Sweet Caroline", "Neil Diamond", "happy", 201, 1969);
22INSERT INTO songs (title, artist, mood, duration, released)
23    VALUES ("Call me maybe", "Carly Rae Jepsen", "happy", 193, 2011);
24   SELECT * FROM songs;

1Creates a new database.
2Example: Creates a new database named ‘websitesetup’.
3CREATE DATABASE websitesetup;

1Create DATABASE HP;
2

1SHOW DATABASES;
2 DROP DATABASE testDB;
3 USE DatabaseName;
4 
5 SQL> CREATE TABLE CUSTOMERS(
6   ID   INT              NOT NULL,
7   NAME VARCHAR (20)     NOT NULL,
8   AGE  INT              NOT NULL,
9   ADDRESS  CHAR (25) ,
10   SALARY   DECIMAL (18, 2),       
11   PRIMARY KEY (ID)
12);
13
14DESC CUSTOMERS;