Re: mysql query and maximum characters in sql statement
| From: | Chris | Date: | Fri, 02 May 2008 06:56:56 +0000 |
| Subject: | Re: mysql query and maximum characters in sql statement | ||
| References: | 1 2 3 4 5 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-273796@lists.php.net to get a copy of this message | ||
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 at the end of the LOAD DATA
INFILE statement, input lines are expected to contain a field for each
table column. If you want to load only some of a table's columns,
specify a column list:
LOAD DATA INFILE 'persondata.txt' INTO TABLE persondata (col1,col2,...);
But load data infile requires extra mysql privileges.
--
Postgresql & php tutorials
http://www.designmagick.com/