Hi
As the subject says really, where do i start in uploading a csv file so i can run an insert against my db. I really have zero ideas about this so all the help you guys can give me will be brill
Cheers
Chrisio
:wave:
Printable View
Hi
As the subject says really, where do i start in uploading a csv file so i can run an insert against my db. I really have zero ideas about this so all the help you guys can give me will be brill
Cheers
Chrisio
:wave:
It is possible, you need to use a LOAD DATA INFILE query. The following query will load a windows CSV file into your database:
Code:LOAD DATA INFILE 'c:\\path\\to\\file.csv' INTO TABLE tbl_name
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\r\n';