Database SQL2

Oi Guilherme, de boa ?

Cara você pode fazer quais são as tabelas que ele tem, para então fazer uma busca nele :

show tables;

Pois aparentemente ele não tem a tabela sql2, imagino que seu problema seja esse.

Abraços

guilherme, o erro indica que dentro do banco de dados 'sql2' não tem a tabela 'sql2'. Table 'sql2.sql2' doesn't exist

use o comando abaixo para verificar quais tabelas possui no banco sql2:

show tables;

Confirme se a tabela que procura está lá.

No caso estou fazendo a instalação do SQL 2 da aula 1, o path do prompt já está direcionado para pasta correta, porém era para a table ser apresentada , o que não é indicando que foi instalada.

Enter password: ************
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 116
Server version: 5.7.17-log MySQL Community Server (GPL)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show tables;
ERROR 1046 (3D000): No database selected
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| controle_compras   |
| mysql              |
| performance_schema |
| sql2               |
| sys                |
+--------------------+
6 rows in set (0.00 sec)

mysql> use sql2;
Database changed
mysql> show tables;
Empty set (0.00 sec)

mysql> select * from;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
mysql>

C:\Users\GUILHERME>path
PATH=C:\Program Files\MySQL\MySQL Server 5.7\bin

Guilherme,

Aparentemente ele criou o banco de dados.

O que pode ter ocorrido é que esse dump, se é que usou um, não tinha tabelas embutidas.

Como assim?

Só estou querendo instalar o arquivo sql2.sql do seguinte diretório :

https://cursos.alura.com.br/course/banco-de-dados-e-sql-complexas/task/4148

Guilherme,

Você usou algum arquivo para gerar esse banco, não foi ?

Quando a gente usa um arquivo ele joga tudo que estiver no arquivo para nosso banco.

Caso você não tenha usado, e tenha criado na mão o banco de dados, ainda é necessário criar as tabelas, nesse caso acredito que o curso deva te ajudar.

Abraços

Matheus o arquivo é do seguinte curso :

https://cursos.alura.com.br/course/banco-de-dados-e-sql-complexas/task/4148

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> mysql -u root -p sql2 < sql2.sql
    -> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql -u root -p sql2 < sql2.sql' at line 1
mysql> mysql -u root -p sql2 < sql2.sql
    -> show databases;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql -u root -p sql2 < sql2.sql
show databases' at line 1
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| controle_compras   |
| mysql              |
| performance_schema |
| sql2               |
| sys                |
+--------------------+
6 rows in set (0.00 sec)

mysql>

Guilherme,

https://s3.amazonaws.com/caelum-online-public/sql2/sql2.sql

Você baixou esse arquivo ?

Se sim, você está no mesmo diretório que o arquivo no seu terminal ?

Guilherme, uma outra forma de usar o import do banco é usar o comando source localdoarquivo.sql diretamente no banco de dados. Então, acesse o banco sql2 use sql2 Em seguida: source nomedoarquivo.sql

Pode demorar um pouco se houver muita informação.

Sim, está. O diretório é a pasta :

C:\Program Files\MySQL\MySQL Server 5.7\bin

E o prompt :

C:\Users\GUILHERME>path PATH=C:\Program Files\MySQL\MySQL Server 5.7\bin

João , Fiz conforme o indicado , porém não tive sucesso;

insira seu código aqui ```ysql> use sql2; Database changed mysql> source C:\Program Files\MySQL\MySQL Server 5.7\bin\sql2.sql Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.06 sec)

Query OK, 0 rows affected (0.28 sec)

Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 5 rows affected (0.05 sec) Records: 5 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.13 sec)

Query OK, 0 rows affected (0.05 sec)

Query OK, 0 rows affected (0.29 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 4 rows affected (0.05 sec) Records: 4 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.23 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 31 rows affected (0.08 sec) Records: 31 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.05 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.30 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 5 rows affected (0.05 sec) Records: 5 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.27 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 27 rows affected (0.05 sec) Records: 27 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.06 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected (0.25 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 27 rows affected (0.06 sec) Records: 27 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.08 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.25 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 16 rows affected (0.05 sec) Records: 16 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected, 2 warnings (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

mysql> source C:\Program Files\MySQL\MySQL Server 5.7\bin\sql2.sql; ERROR: Unknown command '\P'. ERROR: Unknown command '\M'. ERROR: Unknown command '\M'. ERROR:

Unknown command '\b'.

C:\Program Files\MySQL\MySQL Server 5.7\bin\mysql.exe Ver 14.14 Distrib 5.7.17, for Win64 (x86_64)

Connection id: 122 Current database: sql2 Current user: root@localhost SSL: Not in use Using delimiter: ; Server version: 5.7.17-log MySQL Community Server (GPL) Protocol version: 10 Connection: localhost via TCP/IP Server characterset: utf8 Db characterset: utf8 Client characterset: utf8 Conn. characterset: utf8 TCP port: 3306 Uptime: 7 days 3 hours 35 min 57 sec

Threads: 1 Questions: 639 Slow queries: 0 Opens: 133 Flush tables: 1 Open tables: 106 Queries per second avg: 0.001

ERROR: Failed to open file 'C:\Program Files\MySQL\MySQL Server 5.7\binql2.sql', error: 2 mysql> source C:\Program Files\MySQL\MySQL Server 5.7\bin\sql2.sql Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.41 sec)

Query OK, 0 rows affected (0.41 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 5 rows affected (0.08 sec) Records: 5 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.08 sec)

Query OK, 0 rows affected (0.17 sec)

Query OK, 0 rows affected (0.30 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 4 rows affected (0.06 sec) Records: 4 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.13 sec)

Query OK, 0 rows affected (0.28 sec)

Query OK, 0 rows affected (0.38 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 31 rows affected (0.13 sec) Records: 31 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected (0.17 sec)

Query OK, 0 rows affected (0.50 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 5 rows affected (0.03 sec) Records: 5 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.11 sec)

Query OK, 0 rows affected (0.17 sec)

Query OK, 0 rows affected (0.27 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 27 rows affected (0.03 sec) Records: 27 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.05 sec)

Query OK, 0 rows affected (0.27 sec)

Query OK, 0 rows affected (0.29 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 27 rows affected (0.11 sec) Records: 27 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.05 sec)

Query OK, 0 rows affected (0.17 sec)

Query OK, 0 rows affected (0.31 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 16 rows affected (0.05 sec) Records: 16 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.05 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected, 2 warnings (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | controle_compras | | mysql | | performance_schema | | sql2 | | sys | +--------------------+ 6 rows in set (0.00 sec)

mysql> select * from sql2; ERROR 1146 (42S02): Table 'sql2.sql2' doesn't exist mysql>

```

Guilherme, usa o banco sql2 e vê quais são as tabelas que estão lá. Cola o resultado aqui, por favor.

use sql2;
show tables

Guilherme, conseguiu?

Não , consegui João,

mysql> use sql2;
Database changed
mysql> show tables;
+----------------+
| Tables_in_sql2 |
+----------------+
| aluno          |
| curso          |
| exercicio      |
| matricula      |
| nota           |
| resposta       |
| secao          |
+----------------+
7 rows in set (0.00 sec)

mysql>

Faça um select em algumas das tabelas e veja se estão com informaçōes. Se estiverem, funcionou. Aí você pode fechar o tópico. Acho que você confundiu o comando, ao tentar fazer um select * sql2. Sql2 é o banco, que contém as tabelas.