Bug #15077 Updated: mysql_query("LOAD DATA LOCAL INFILE 'd:\\txt\\data.txt' INTO TABLE maindata")
| From: | leng at haier dot com | Date: | Thu, 17 Jan 2002 04:05:56 +0000 |
| Subject: | Bug #15077 Updated: mysql_query("LOAD DATA LOCAL INFILE 'd:\\txt\\data.txt' INTO TABLE maindata") | ||
| References: | 1 | Groups: | php.dev |
| Request: | Send a blank email to php-dev+get-77312@lists.php.net to get a copy of this message | ||
ID: 15077
User updated by: leng@haier.com
Old Summary: mysql_query("LOAD DATA LOCAL INFILE 'd:\\txt\\data.txt'
INTO TABLE maindata")
Reported By: leng@haier.com
Old Status: Open
Status: Closed
Bug Type: MySQL related
Operating System: Windows2000 Professornal
PHP Version: 4.1.1
Previous Comments:
------------------------------------------------------------------------
[2002-01-16 22:22:33] leng@haier.com
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