ID: 15077
Comment by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
Status: Open
Bug Type: MySQL related
Operating System: Windows2000 Professornal
PHP Version: 4.1.1
New Comment:
Oh,sorry,
I have just found the answer, it was my wrong syntax.
The correct syntax is,
mysql_query("LOAD DATA LOCAL INFILE 'd:/data/data.txt' INTO TABLE
maindata");
Thanks.
kanaka
2002-01-17
Previous Comments:
------------------------------------------------------------------------
[2002-01-16 22:22:33] [EMAIL PROTECTED]
Hi,phpers,
Thank you all for your moil.
I have a txt file,and I wanna load the data from the file to my
database,so I write the sentences following.But I found that the last
sentence did not fetch anything, the table that named maindata is
null.
Why?
////////////////////////////////////////////////////////////
mysql_connect("localhost", "admin", "") ;
mysql_query("DROP DATABASE IF EXISTS stage");
mysql_query("CREATE DATABASE stage");
mysql_query("USE stage");
mysql_query("CREATE TABLE maindata (id VARCHAR(14), materiel
VARCHAR(20), counts INT(8))");
mysql_query("LOAD DATA LOCAL INFILE 'Z_P.txt' INTO TABLE
maindata");
////////////////////////////////////////////////////////////
kanaka,2002-01-17
------------------------------------------------------------------------
Edit this bug report at http://bugs.php.net/?id=15077&edit=1
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
