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; desc client; #######################################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;