Re: [PHP] mysql query and maximum characters in sql statement

2008-05-08 Thread Chris
Sanjeev N wrote: > Hi Jim Lucas, > > You are correct... i want to run in the same way. > > but as my 2 tables, column name are different i cant run the LOAD DATA > infile. If you're inserting the same data, then use LOAD DATA INFILE to load it into a temporary table, then use INSERT SELECT's to

Re: [PHP] mysql query and maximum characters in sql statement

2008-05-08 Thread Sanjeev N
Hi Jim Lucas, You are correct... i want to run in the same way. but as my 2 tables, column name are different i cant run the LOAD DATA infile. And the example you mentioned for break at 100, also i thought to use in that way. but one of the column had the text type which we cant predict about th

Re: [PHP] mysql query and maximum characters in sql statement

2008-05-01 Thread Chris
Jim Lucas wrote: > Waynn Lue wrote: >> Wouldn't using LOAD DATA INFILE be better than writing your own script? >> > > depends, does the data file match the table column for column? Doesn't have to. http://dev.mysql.com/doc/refman/5.0/en/load-data.html By default, when no column list is provided

Re: [PHP] mysql query and maximum characters in sql statement

2008-05-01 Thread Jim Lucas
Waynn Lue wrote: Wouldn't using LOAD DATA INFILE be better than writing your own script? depends, does the data file match the table column for column? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] mysql query and maximum characters in sql statement

2008-05-01 Thread Waynn Lue
Wouldn't using LOAD DATA INFILE be better than writing your own script? On 5/1/08, Jim Lucas <[EMAIL PROTECTED]> wrote: > Jim Lucas wrote: > > Sanjeev N wrote: > >> Hi, > >> I have written a program which imports the tab delimited file and > >> insert all > >> the line from file to the mysql lin

Re: [PHP] mysql query and maximum characters in sql statement

2008-05-01 Thread Jim Lucas
Jim Lucas wrote: Sanjeev N wrote: Hi, I have written a program which imports the tab delimited file and insert all the line from file to the mysql line by line. I am succeding in the above case. but problem with the above method is its taking to too much time while inserting into the databas

Re: [PHP] mysql query and maximum characters in sql statement

2008-05-01 Thread Jim Lucas
Sanjeev N wrote: Hi, I have written a program which imports the tab delimited file and insert all the line from file to the mysql line by line. I am succeding in the above case. but problem with the above method is its taking to too much time while inserting into the database. The file's size wil

Re: [PHP] mysql query and maximum characters in sql statement

2008-05-01 Thread Wolf
Sanjeev N <[EMAIL PROTECTED]> wrote: > Hi, > I have written a program which imports the tab delimited file and insert all > the line from file to the mysql line by line. > I am succeding in the above case. but problem with the above method is its > taking to too much time while inserting int