MySQL Imports multiple statements

Sometimes you need to import multiple text data to the database, each time waiting for a very waste of time, so write your own SQL script, so that the program automatically executes, there is no need to wait.

Command:

Mysql-u ROOT-PROOTP Testt <a.sql

650) this.width=650; "src=" http://s5.51cto.com/wyfs02/M02/83/6C/wKioL1dzOB2wxuWxAAAOoyF2eVE888.jpg "title=" 1.jpg " alt= "Wkiol1dzob2wxuwxaaaooyf2eve888.jpg"/>

-U followed by database user name

-P followed by the database password

TESTT is a database

A.sql is the SQL script I want to execute.

I want to test the content:

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M02/83/6C/wKioL1dzOMehoyY2AADQDWAP90E739.jpg-wh_500x0-wm_3 -wmp_4-s_953461883.jpg "title=" 2.jpg "alt=" Wkiol1dzomehoyy2aadqdwap90e739.jpg-wh_50 "/>

Test results:

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M00/83/6D/wKiom1dzORLB-woWAAArgkGiVTI694.jpg-wh_500x0-wm_3 -wmp_4-s_189930931.jpg "title=" 3.jpg "alt=" Wkiom1dzorlb-wowaaargkgivti694.jpg-wh_50 "/>

Reference Links:

Http://www.oschina.net/question/227902_163001 for Dead Water Fox

This article is from the "Enlightened Grocery store" blog, please be sure to keep this source http://wutou.blog.51cto.com/615096/1793901

MySQL Imports multiple statements