SQL - Create Database

Overview

Creating a database differs slightly by engine. SQLite creates a database as a file when you connect.

CREATE DATABASE company;
-- then select it
USE company;

CREATE DATABASE company;
GO
USE company;
GO

-- SQLite: database is a file; from CLI, open or create it:
-- $ sqlite3 company.db
-- Then create tables within it.

Live Check (SQLite)

Local DB path: /home/u688631385/domains/eezytutorials.com/public_html/sql/includes/../localdb/company.db

Connection OK: Yes