|
|
Inserting into mysql table from a file with column names - Mysql
|
Views : 368
|
|
Tagged in : Mysql
|
|
|
Report This Scrap as Inappropriate
We request you to choose the appropriate categroy and subcategory that suits your
objectionable concern about the scrap, So that our team can review and find out whether it violates our Guidelines or the
scrap is not suitable for all viewers.
|
The following command can be used to import data from a file into a mysql database table.
LOAD DATA INFILE 'file.txt'
INTO TABLE t1
(column1, column2)
here the content of file file.txt will be imported into table t1 on fields column1 and column2.
We can also specify the terminating characters.
|
|
By - raja, On - 2009-11-11 |
|
|
|
