FsseInfo: mysql import

Revision [1225]

Last edited on 2012-01-10 04:07:31 by FsseInfo

Additions:

you can import csv data into mysql by running the mysqlimport command
--ignore-lines=1 --fields-terminated-by=',' --fields-enclosed-by='"' --fields-escaped-by='\\' \

Deletions:

you can import csv data into mysql by running the MySqlImport command
--fields-terminated-by=',' --fields-enclosed-by='"' --fields-escaped-by='\\' \

Revision [1224]

Edited on 2012-01-10 03:35:01 by FsseInfo

Additions:

dbname --local tblname.csv

Deletions:

~~dbname tblname --local mydata.csv~~

Revision [1223]

Edited on 2012-01-10 03:32:59 by FsseInfo

Additions:

$ mysqlimport -h host -u user -p \

Deletions:

~~$ mysqlimport -u user -p --local -h host \~~

Revision [1222]

Edited on 2012-01-10 03:32:04 by FsseInfo

Additions:

dbname tblname --local mydata.csv

Deletions:

~~dbname --local mydata.csv~~

Revision [1221]

Edited on 2012-01-10 02:54:20 by FsseInfo

Additions:

===mysqlimport===
$ mysqlimport -u user -p --local -h host \
--fields-terminated-by=',' --fields-enclosed-by='"' --fields-escaped-by='\\' \
dbname --local mydata.csv
===see also===
MySqlExport

Deletions:

~~$ mysqlimport -u user -p --local -h host --fields-terminated-by=',' --fields-enclosed-by='"' --fields-escaped-by='\\' dbname --local mydata.csv~~

Revision [1219]

Edited on 2011-11-22 09:34:03 by FsseInfo

Additions:

$ mysqlimport -u user -p --local -h host --fields-terminated-by=',' --fields-enclosed-by='"' --fields-escaped-by='\\' dbname --local mydata.csv

Deletions:

~~$ mysqlimport -u user -p --local -h host dbname --local mydata.csv~~

Revision [1218]

Edited on 2011-11-22 09:27:42 by FsseInfo

Additions:

$ mysqlimport -u user -p --local -h host dbname --local mydata.csv

Deletions:

~~$ mysqlimport -u user -p -h host dbname /full/path/to/mydata.csv~~

Revision [1217]

Edited on 2011-11-22 09:18:46 by FsseInfo

Additions:

$ mysqlimport -u user -p -h host dbname /full/path/to/mydata.csv

Deletions:

~~$ mysqlimport -u user -p -h host dbname mydata.csv~~

Revision [1216]

Edited on 2011-11-22 09:15:46 by FsseInfo

Additions:

you can import csv data into mysql by running the MySqlImport command
$ mysqlimport -u user -p -h host dbname mydata.csv

Deletions:

import data by running the MySqlLoad command for you
$ mysqlimport -u user -p -h host dbname textfile

Revision [1215]

Edited on 2011-11-22 08:53:50 by FsseInfo

Additions:

$ mysqlimport -u user -p -h host dbname textfile

Deletions:

~~$ mysqlimport~~

Revision [1201]

Edited on 2011-10-17 07:20:22 by FsseInfo

Additions:

%%
$ mysqlimport
%%

Revision [1198]

Edited on 2011-10-17 07:16:14 by FsseInfo

Additions:

>>http://dev.mysql.com/doc/refman/5.5/en/mysqlimport.html
>>======mysql import======

Deletions:

~~======mysql import======~~

Revision [1197]

The oldest known version of this page was created on 2011-10-17 07:15:57 by FsseInfo