-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathagenda_insert.sql
37 lines (34 loc) · 2.16 KB
/
agenda_insert.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
INSERT INTO agenda_usuario VALUES
(NULL, 'Gabriel Lima','[email protected]', 0, '12345678'),
(NULL, 'Guilherme Lima','[email protected]', 0, '12345678'),
(NULL, 'Arthur Lima','[email protected]', 0, '12345678'),
(NULL, 'Julia Lima','[email protected]', 0, '12345678'),
(NULL, 'Maria DB','[email protected]', 0, '12345678');
SELECT*FROM agenda_usuario;
INSERT INTO agenda_eventos VALUES
(NULL, 'Aula de RC1', '2023-01-23 10:00:56', 'Uma aula massa!', 0, 1),
(NULL, 'Aula de RC1', '2023-01-23 10:00:56', 'Uma aula massa!', 0, 1),
(NULL, 'Aula de MPS', '2023-01-23 10:00:56', 'Uma aula massa!', 0, 1),
(NULL, 'Aula de ED2', '2023-01-23 10:00:56', 'Uma aula massa!', 0, 1),
(NULL, 'Aula de PLP', '2023-01-23 10:00:56', 'Uma aula massa!', 0, 1),
(NULL, 'Aula de RC1', '2023-01-23 10:00:56', 'Uma aula massa!', 0, 5),
(NULL, 'Aula de ED2', '2023-01-23 10:00:56', 'Uma aula massa!', 0, 5),
(NULL, 'Aula de BD1', '2023-01-23 10:00:56', 'Uma aula massa!', 0, 5),
(NULL, 'Aula de ED2', '2023-01-23 10:00:56', 'Uma aula massa!', 0, 5),
(NULL, 'Aula de BD1', '2023-01-23 10:00:56', 'Uma aula massa!', 0, 5),
(NULL, 'Aula de PLP', '2023-01-23 10:00:56', 'Uma aula massa!', 0, 4),
(NULL, 'Aula de PLP', '2023-01-23 10:00:56', 'Uma aula massa!', 0, 4),
(NULL, 'Aula de RC1', '2023-01-23 10:00:56', 'Uma aula massa!', 0, 4),
(NULL, 'Aula de PLP', '2023-01-23 10:00:56', 'Uma aula massa!', 0, 4),
(NULL, 'Aula de BD1', '2023-01-23 10:00:56', 'Uma aula massa!', 0, 4),
(NULL, 'Aula de BD1', '2023-01-23 10:00:56', 'Uma aula massa!', 0, 3),
(NULL, 'Aula de ED2', '2023-01-23 10:00:56', 'Uma aula massa!', 0, 3),
(NULL, 'Aula de RC1', '2023-01-23 10:00:56', 'Uma aula massa!', 0, 3),
(NULL, 'Aula de PLP', '2023-01-23 10:00:56', 'Uma aula massa!', 0, 3),
(NULL, 'Aula de RC1', '2023-01-23 10:00:56', 'Uma aula massa!', 0, 3),
(NULL, 'Aula de MPS', '2023-01-23 10:00:56', 'Uma aula massa!', 0, 2),
(NULL, 'Aula de BD1', '2023-01-23 10:00:56', 'Uma aula massa!', 0, 2),
(NULL, 'Aula de RC1', '2023-01-23 10:00:56', 'Uma aula massa!', 0, 2),
(NULL, 'Aula de ED2', '2023-01-23 10:00:56', 'Uma aula massa!', 0, 2),
(NULL, 'Aula de MPS', '2023-01-23 10:00:56', 'Uma aula massa!', 0, 2);
SELECT*FROM agenda_eventos;