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. 2,992 views

Related Posts

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>