1. save ur excel sheet into a csv file.2. mysql -hhostname -Pportnumber -uusername -ppassword -Ddatabasename --local-infile=yourfilename not very sure.. i left the right statement in office..
看MySQL的文档就知道了,MySQL可以导入txt文件的: LOAD DATA LOCAL INFILE yours.txt INTO TABLE yours;
ya, there are two ways.. becuase im working in linux and do everything by bash files instead of do the mysql internal operation, i do not prefer the way using "load data ..." :)
use "load data", well... I want to know how to format the .txt. I mean .how to add info into the txt. ---------the syntax!!!!
LOAD DATA LOCAL INFILE yours.txt INTO TABLE yours;
working in linux and do everything
by bash files instead of do the
mysql internal operation, i do not
prefer the way using "load data ..."
:)
well...
I want to know how to format the .txt.
I mean .how to add info into the txt. ---------the syntax!!!!