Bug #15077: mysql_query("LOAD DATA LOCAL INFILE 'd:\\txt\\data.txt' INTO TABLE maindata")
| From: | leng at haier dot com | Date: | Thu, 17 Jan 2002 03:22:33 +0000 |
| Subject: | Bug #15077: mysql_query("LOAD DATA LOCAL INFILE 'd:\\txt\\data.txt' INTO TABLE maindata") | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-77310@lists.php.net to get a copy of this message | ||
From: leng@haier.com
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