SQLize | PHPize | SQLtest

create table addresses( id int, house_number int, city varchar(20), postcode varchar(7) ); create table people( id int, first_name varchar(20), last_name varchar(20), address_id int ); create table pets( id int, name varchar(20), species varchar(20), owner_id int ); show tables; describe addresses; alter table addresses add primary key (id); describe addresses; alter table addresses drop primary key; describe addresses; alter table addresses modify id int; describe addresses; describe people; alter table people add primary key(id); describe people; alter table addresses add primary key (id); describe addresses; describe addresses; describe people; alter table people add constraint fk_peopleaddress foreign key(address_id) references addresses(id); describe people; alter table people drop foreign key fk_peopleaddress, drop index fk_peopleaddress; describe people; describe pets; alter table pets add constraint u_species unique (species); describe pets; alter table pets drop index u_species; describe pets; alter table pets change species animal_type varchar(20); describe pets; alter table pets rename column animal_type to species; describe pets; alter table pets rename column species to `animal type`; describe pets; describe addresses; alter table addresses change column city city varchar(30); describe addresses; alter table addresses modify city char(25); describe addresses;