show databases;
create database <db name>;
use <db name>;
show tables;
create table users; (id integer, description text, completed boolean);
//or create table - not null allowed (not empty)
create table users; (id integer PRIMARY KEY, description text NOT NULL, completed boolean NOT NULL);
//PRIMARY KEY = unique number (don't repeat it)
describe <table name>; //show tables description
drop table <table name>;
Categories: MySql