SQLize Online / PHPize Online  /  SQLtest Online

create table alunos( id_aluno int not null primary key auto_increment, ra int not null unique, nome varchar(100) not null, nota decimal(3,1) ); -- show columns from alunos; insert into alunos values (null,123456,'José',9.8); insert into alunos values (null,123459,'Maria',10); select * from alunos; rename table alunos to aluno; show tables; alter table aluno add email varchar(40) not null; show columns from aluno; alter table aluno modify email varchar(60) not null; show columns from aluno;