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