设置mysql的环境变量:
windows 7:
%MYSQL_HOME%=D:\Java\mysql-5.6.40-winx64
Path=%MYSQL_HOME%\bin
1
2
3
4
5
windows7:
%MYSQL_HOME%=D:\Java\mysql-5.6.40-winx64
Path=%MYSQL_HOME%\bin
win+R 输入 cmd 进入dos
输入登录命令:mysql -u root -p 默认root密码为空 无需输入
C:\Users\Administrator>mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 19
Server version: 5.6.40 MySQL Community Server (GPL)
Copyright (c) 2000, 2018, 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.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
C:\Users\Administrator>mysql-uroot-p
Enterpassword:
WelcometotheMySQLmonitor.Commandsendwith;or\g.
YourMySQLconnectionidis19
Serverversion:5.6.40MySQLCommunityServer(GPL)
Copyright(c)2000,2018,Oracleand/oritsaffiliates.Allrightsreserved.
OracleisaregisteredtrademarkofOracleCorporationand/orits
affiliates.Othernamesmaybetrademarksoftheirrespective
owners.
Type'help;'or'\h'forhelp.Type'\c'toclearthecurrentinputstatement.
输入显示数据库命令:show databases;
注:末尾加上;
mysql> show databases;
+------------------------+
| Database |
+------------------------+
| information_schema |
| insight |
| mysql |
| performance_schema |
| small_loan_supervision |
| test |
+------------------------+
6 rows in set (0.00 sec)
1
2
3
4
5
6
7
8
9
10
11
12
13
mysql>showdatabases;
+------------------------+
|Database|
+------------------------+
|information_schema|
|insight|
|mysql|
|performance_schema|
|small_loan_supervision|
|test|
+------------------------+
6rowsinset(0.00sec)
输入命令:use small_loan_supervision;
mysql> use small_loan_supervision;
Database changed
1
2
3
mysql>usesmall_loan_supervision;
Databasechanged
输入导入文件命令:source d:\script\test.sql
注:无需加上; 如果文件名包含中文则可能导入不成功
mysql> source d:\script\月报年报.sql
ERROR:
Failed to open file 'd:\script\月报年报.sql', error: 2
mysql> source d:\script\test.sql
Query OK, 0 rows affected (0.13 sec)
Query OK, 0 rows affected (0.22 sec)
Query OK, 0 rows affected (0.13 sec)
1
2
3
4
5
6
7
8
9
10
mysql>sourced:\script\月报年报.sql
ERROR:
Failedtoopenfile'd:\script\月报年报.sql',error:2
mysql>sourced:\script\test.sql
QueryOK,0rowsaffected(0.13sec)
QueryOK,0rowsaffected(0.22sec)
QueryOK,0rowsaffected(0.13sec)
Query OK, 0 rows affected (0.20 sec)
作者:Gent_Chen
来源:CSDN
原文:https://blog.csdn.net/java1230123/article/details/81099383
版权声明:本文为博主原创文章,转载请附上博文链接!