CREATE DATABASE escola ;, USE escola ;, CREATE TABLE alunos (...) ;, id INT AUTO_INCREMENT PRIMARY KEY , nome VARCHAR (50), SELECT * FROM alunos ;, INSERT INTO alunos ( nome , idade ) VALUES ( 'Maria' , 16 ) ;, DELETE FROM alunos WHERE id = 7 ;, UPDATE alunos SET idade = 16 WHERE id = 1 ;, SELECT nome FROM alunos ;, SELECT * FROM alunos ORDER BY nome ;, TRUNCATE TABLE alunos ;, DROP TABLE alunos ;, CREATE TABLE nota (...) ;, ALTER TABLE nota RENAME TO notas ;, id_nota INT AUTO_INCREMENT PRIMARY KEY , id_aluno INT , id_disciplina INT, valor_nota DECIMAL (4,2) ,
0%
Comandos SQL
Share
Share
by
Giorneselisa7
1ª EM
Técnico
Edit Content
Print
Embed
More
Assignments
Leaderboard
Show more
Show less
This leaderboard is currently private. Click
Share
to make it public.
This leaderboard has been disabled by the resource owner.
This leaderboard is disabled as your options are different to the resource owner.
Revert Options
Unjumble
is an open-ended template. It does not generate scores for a leaderboard.
Log in required
Visual style
Fonts
Subscription required
Options
AI Enhanced: This activity contains content generated by AI.
Learn more.
Switch template
Show all
Open results
Copy link
QR code
Delete
Continue editing:
?
