Bug #15077 Updated: mysql_query("LOAD DATA LOCAL INFILE 'd:\\txt\\data.txt' INTO TABLE maindata")

ID: 15077 Comment by: leng@haier.com Reported By: leng@haier.com 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] 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