SQLize Online / PHPize Online  /  SQLtest Online

CREATE table cliente( id int not null primary key AUTO_INCREMENT, nome varchar(10), email varchar(10) ); alter table cliente add cep char(9) not null; alter table cliente add apelido varchar(50) not null; alter table cliente drop column apelido; alter table cliente MODIFY COLUMN email varchar(50) not null unique; alter table cliente RENAME COLUMN nome to nomes; alter table cliente add cpf char(14) not null; alter table cliente add CONSTRAINT cpf_uniq unique(cpf); insert cliente(id,nomes,email,cep,cpf) values(1,'Carlos','carlos@gmail.com','0800-7000','12345678912345'); insert cliente(id,nomes,email,cep,cpf) values(2,'Douglas','douglas@gmail.com','0700-1244','12323234225346'); select * from cliente /* insert into cliente (id,nome,email) values(2, "Carlos","carlos@.com"); insert into cliente (nome,email) values ('Helio', 'ovo@gmail.com'); insert into cliente (nome,email) values (7,'Beto', 'ovg@mail.com'); insert into cliente (nome,email) values ('Edna', 'o@il.com'); select * from cliente; */