ID: 15077
User updated by: [EMAIL PROTECTED]
Old Summary: mysql_query("LOAD DATA LOCAL INFILE 'd:\\txt\\data.txt'
INTO TABLE maindata")
Reported By: [EMAIL PROTECTED]
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] [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]

Reply via email to