cmd命令行导入mysql数据

开始->运行->CMD,以下是mornone执行的命令记录。

本文关键字:
set names utf8;(防止乱码)
source(导入sql文件)

代码如下:

D:
cd D:\xampp\mysql\bin
mysql -uxxx -pxxx
create database xxx;
use xxx;
set names utf8;
source C:\Downloads\xxx.sql;

This entry was posted in Technology and tagged , , . Bookmark the permalink. 3,329 views

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *