Databases Create New Database CREATE DATABASE database; Set default database USE DATABASE database; Show Databases SHOW DATABASES; Tables Create CREATE TABLE [IF NOT EXISTS] tablename( col1 AS STRING, col2 AS INT, col3 AS VARCHAR(255) ) Example: CREATE TABLE [IF NOT EXISTS] users( id INT NOT NULL AUTO_INCREMENT, name STRING, age INT, color VARCHAR(25), PRIMARY KEY(id) ..

Read more