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 apelido varchar(50) not null; alter table cliente add cep char(9) not null; -- alter table cliente drop column email; -- alter table cliente drop column apelido; alter table cliente MODIFY COLUMN nome varchar(50) not null; alter table cliente MODIFY COLUMN email varchar(100) not null; alter table cliente rename column nome to nomes; alter table cliente MODIFY COLUMN nomes varchar(120) not null; alter table cliente add cpf char(4); alter table cliente add CONSTRAINT cpf_uniq unique(cpf); insert into cliente(nomes,email, apelido, cep, cpf) values ('Marechal Deodoro', 'mardeodor@md.com', "Deodor", 29930392, 2458); insert into cliente(nomes,email, apelido, cep, cpf) values ('Dom Pedro II', 'donpedron@dp.com', "Pedron", 25473897, 8746); insert into cliente(nomes,email, apelido, cep, cpf) values ('Santa Cecília', 'saintceli@sc.com', "Cecily", 41578326, 3400); insert into cliente(nomes,email, apelido, cep, cpf) values ('Guilhermina Esperança', 'guiminspe@ge.com', "Guilhi", 78960053, 8016); select * from cliente; #######################################INSERT /* insert into cliente(id,nome,email) values (2, 'Bete', 'bet@b.com'); insert into cliente(nome,email) values ('Helio', 'heli@h.com'); insert into cliente(id,nome,email) values (6, 'Bonny', 'bonn@b.com'); insert into cliente(nome,email) values ('Edna', 'ed@n.com'); insert into cliente(id,nome,email) values (4, 'Dolly', 'doll@y.com'); insert into cliente(nome,email) values ('Cana', 'ca@n.com'); select * from cliente;