MySQL little knowledge point (about database Import Export for Windows)

For an existing data, how do we package it into a. sql property file?

Make these two statements directly:

1 D:\Program files\mysql\mysql\bin>-->D://str  . SQL2* * *

Thus, a str.sql file was generated

But we generated a SQL procedure, how to draw it into the database?? This is just a operation for MySQL!!

First, we enter CMD---mysql-uroot-p***;

Then do such an operation,mysql> source D://str.sql

This can be imported into the database!!!!

Query OK, 0 rows affected (0.05 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 (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)

ERROR 1046 (3d000): No Database selected
Query OK, 0 rows Affected (0.00 sec)

Query OK, 0 rows Affected (0.00 sec)

ERROR 1046 (3d000): No Database selected
Query OK, 0 rows Affected (0.00 sec)

ERROR 1046 (3d000): No Database selected
ERROR 1046 (3d000): No Database selected
ERROR 1046 (3d000): No Database selected
ERROR 1046 (3d000): No Database selected
Query OK, 0 rows Affected (0.00 sec)

ERROR 1046 (3d000): No Database selected
Query OK, 0 rows Affected (0.00 sec)

Query OK, 0 rows Affected (0.00 sec)

ERROR 1046 (3d000): No Database selected
Query OK, 0 rows Affected (0.00 sec)

ERROR 1046 (3d000): No Database selected
ERROR 1046 (3d000): No Database selected
ERROR 1046 (3d000): No Database selected
ERROR 1046 (3d000): No Database selected
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 (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>

MySQL little knowledge point (about database Import Export for Windows)