02- DDL
Data definition language.
CREATE TABLE
create table pokemons( id int auto_increment, name varchar(32) not null unique, type varchar(32) not null, strength int not null, staming int not null, speed int not null, accuracy int not null, PRIMARY KEY(id), trainer_id int, FOREIGN KEY(trainer_id) REFERENCES trainers(id) );
ALTER TABLE FK:
ALTER TABLE pokemons ADD FOREIGN KEY(trainer_id) REFERENCES trainers(id);
ALTER TABLE RENAME COLUMN:
ALTER TABLE pokemons CHANGE nickname name VARCHAR(32) NOT null UNIQUE;
ALTER TABLE ADD COLUMN:
ALTER TABLE pokemons ADD COLUMN color VARCHAR(16);
DROP TABLE:
DROP TABLE gyms;
ALTER TABLE DROP COLUMN:
ALTER TABLE pokemons DROP COLUMN color;
ALTER TABLE ADD COLUMN AFTER COLUMN:
ALTER TABLE pokemons ADD COLUMN color VARCHAR(16) AFTER accuracy