This is from the manual. See the 3rd paragraph.
> The REPLACE and IGNORE keywords control handling of input records that duplicate
> existing records on unique key values.
>
> If you specify REPLACE, input rows replace existing rows (in other words rows that
> has the same value for a primary
[EMAIL PROTECTED] wrote:
> I'm load a CSV file with five fields into mysql. It loads up fine.
> Problem comes in when I try to refresh the data with updates.
>
> I grab this file and convert it to CSV every 12 hours. The data shows
> past 24 hours only, so basically I'm trying to make a permane
I'm load a CSV file with five fields into mysql. It loads up fine.
Problem comes in when I try to refresh the data with updates.
I grab this file and convert it to CSV every 12 hours. The data shows
past 24 hours only, so basically I'm trying to make a permanent archive.
I tried creating a PRI
Hi list!
I have a problem when trying to read data into tables with LOAD DATA LOCAL
INFILE.
I get this error:
ERROR 2013: Lost connection to MySQL server during query
When looking at the MySQL site it says that I should increase the
max_allowed_packet=# option (default 1M). However, my file is
