From: [EMAIL PROTECTED]
Operating system: Windows2000 Professornal
PHP version: 4.1.1
PHP Bug Type: MySQL related
Bug description: mysql_query("LOAD DATA LOCAL INFILE 'd:\\txt\\data.txt' INTO TABLE
maindata")
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 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]
