Skip to content

Instantly share code, notes, and snippets.

@ed1rac

ed1rac/aluno.sql

Last active November 24, 2022 22:56
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save ed1rac/099f53e8f9a95a47fab74eba60853f01 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save ed1rac/099f53e8f9a95a47fab74eba60853f01 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. ed1rac revised this gist Nov 24, 2022. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion aluno.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -2,7 +2,7 @@
    create database if not exists aulaprogweb;
    use aulaprogweb;

    --definir o charset
    -- definir o charset
    alter database aulaprogweb character set utf8 collate utf8_general_ci;

    -- create table tab-aluno nome, matricula, nota1, nota2, nota3
  2. ed1rac created this gist Nov 23, 2022.
    30 changes: 30 additions & 0 deletions aluno.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,30 @@
    -- create database aula-prog-web;
    create database if not exists aulaprogweb;
    use aulaprogweb;

    --definir o charset
    alter database aulaprogweb character set utf8 collate utf8_general_ci;

    -- create table tab-aluno nome, matricula, nota1, nota2, nota3
    create table if not exists tab_aluno (
    cod_aluno int not null auto_increment primary key,
    nome varchar(50),
    matricula varchar(10),
    nota1 float,
    nota2 float,
    nota3 float);

    -- inserir dados de teste no banco aluno
    insert into tab_aluno values ('', 'Joao', '123', 10, 9, 10);
    insert into tab_aluno values ('', 'Maria', '456', 10, 8, 10);
    insert into tab_aluno values ('', 'Jose', '789', 10, 10, 9);
    insert into tab_aluno values ('', 'Pedro', '101', 10, 10, 7);
    insert into tab_aluno values ('', 'Ana', '102', 10, 9, 10);
    insert into tab_aluno values ('', 'Jonatas', '123', 10, 10, 9);
    insert into tab_aluno values ('', 'Mariana', '456', 10, 10, 10);
    insert into tab_aluno values ('', 'Joseilton', '789', 10, 9, 10);
    insert into tab_aluno values ('', 'Petra', '101', 10, 9, 10);
    insert into tab_aluno values ('', 'Analice', '102', 10, 10, 10);
    insert into tab_aluno values ('', 'Joalisson', '123', 10, 10, 9);
    insert into tab_aluno values ('', 'Marialice', '456', 9, 10, 10);
    insert into tab_aluno values ('', 'Josenir', '789', 10, 10, 9);