how to create sql database

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;

1#TO Create a DB :
2CREATE DATABASE <DB_NAME>;
3#example : CREATE DATABASE MyDataBase ;
4#To Create a Table :
5CREATE TABLE <TB_NAME>(
6    <Elem 0> <Type_of_Elem created> <ADD_PROPRETIES>, #Don't forget the comma
7  	...
8  	...
9  	...
10    <Elem n> <Type_of_Elem created> #last elems don't need a comma 
11);
12/*example :
13CREATE TABLE city (
14    id int  NOT NULL IDENTITY(1, 1),
15    city_name char(128)  NOT NULL,
16    lat decimal(9,6)  NOT NULL,
17    long decimal(9,6)  NOT NULL,
18    country_id int  NOT NULL,
19    CONSTRAINT city_pk PRIMARY KEY  (id)
20);
21*/
22

1Create DATABASE HP;
2