load data local infile
Posted by:
bing li
Date: November 09, 2009 08:47AM
Hallo everyone.
I want to add the pet.txt into my MySql table. But it failed.Could someone explain why? Thank you.
pet.txt
snoppy thomas spec2 m 2008-01-02 NULL
load data local infile'C:/Users/bing/Documents/book/mysql_5_1/pet.txt'
All the columns screez into one column, which I dont want.
Subject
Views
Written By
Posted
load data local infile
4023
November 09, 2009 08:47AM
1793
November 20, 2009 06:26AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.