MySQL错误1046：未选择数据库
16lz
2021-01-22
I've created my first database for a lab, and when I try to run it in MySQL, I keep getting the same 1046 error: No database selected.
我已经为实验室创建了我的第一个数据库,当我尝试在MySQL中运行它时,我一直得到相同的1046错误:没有选择数据库。
First, I run source (scriptfilename).sql and get:
首先,我运行source(scriptfilename).sql并获取:
MariaDB [(none)]> source McClureLab1.sql;
ERROR 1046 (3D000) at line 1 in file: 'McClureLab1.sql': No database selected
ERROR 1046 (3D000) at line 5 in file: 'McClureLab1.sql': No database selected
ERROR 1046 (3D000) at line 12 in file: 'McClureLab1.sql': No database selected
ERROR 1046 (3D000) at line 18 in file: 'McClureLab1.sql': No database selected
+-----------------------------+
| @lastID := LAST_INSERT_ID() |
+-----------------------------+
| 0 |
+-----------------------------+
1 row in set (0.00 sec)
ERROR 1046 (3D000) at line 21 in file: 'McClureLab1.sql': No database selected
ERROR 1046 (3D000) at line 23 in file: 'McClureLab1.sql': No database selected
+-----------------------------+
| @lastID := LAST_INSERT_ID() |
+-----------------------------+
| 0 |
+-----------------------------+
1 row in set (0.00 sec)
ERROR 1046 (3D000) at line 26 in file: 'McClureLab1.sql': No database selected
ERROR 1046 (3D000) at line 28 in file: 'McClureLab1.sql': No database selected
The same thing happens when I try to show my tables:
当我尝试显示表格时会发生同样的事情:
ERROR 1046 (3D000): No database selected
I'm not sure if there is something wrong with the database I've created, or if I'm entering commands incorrectly in MySQL.
我不确定我创建的数据库是否有问题,或者我在MySQL中输入的命令是否错误。
1 个解决方案
#1
1
Have you tried to select your DB first?
您是否尝试过首先选择数据库?
USE yourDB;
If you need to create it:
如果您需要创建它:
CREATE DATABASE yourDB;
创建数据库yourDB;
更多相关文章
- ajax php bomt头 utf-8带来的奇怪问题。。返回值false 判断也是f
- 社交登录实现的数据库结构？
- Symfony2 -从数据库中提取数据并以表单形式显示
- Mysql使用高流量数据库上的过滤器计算行数
- 解析错误:语法错误，E:\xampp\htdocs\online\viewhistory >中
- 使用PHP和MySQL开发“测试”Web应用程序的数据库设计
- 数据库布局更新是否仍在Magento中使用？
- PHP:在类中使用数据库
- 纯真ip数据库查询的php实现（补充分组查询）