Re: updating db with csv

2007-06-13 Thread Captain Paralytic
On 13 Jun, 06:35, Tim Roberts <[EMAIL PROTECTED]> wrote: > Captain Paralytic <[EMAIL PROTECTED]> wrote: > >On 11 Jun, 07:37, Tim Roberts <[EMAIL PROTECTED]> wrote: > >| Not in standard SQL. MySQL supports a REPLACE extension that does > >| an UPDATE if the key already exists, and an INSERT if it d

Re: updating db with csv

2007-06-12 Thread Tim Roberts
Captain Paralytic <[EMAIL PROTECTED]> wrote: >On 11 Jun, 07:37, Tim Roberts <[EMAIL PROTECTED]> wrote: >| Not in standard SQL. MySQL supports a REPLACE extension that does >| an UPDATE if the key already exists, and an INSERT if it does not. >| There is also an extension clause to the INSERT stat

Re: updating db with csv

2007-06-11 Thread Captain Paralytic
On 11 Jun, 07:37, Tim Roberts <[EMAIL PROTECTED]> wrote: | Not in standard SQL. MySQL supports a REPLACE extension that does an | UPDATE if the key already exists, and an INSERT if it does not. There is | also an extension clause to the INSERT statement called "ON DUPLICATE KEY | UPDATE xxx" that

Re: updating db with csv

2007-06-10 Thread Tim Roberts
[EMAIL PROTECTED] wrote: > >#1 If any one familiar with godaddy hosting. They have apparently have >a hosing server i.e.(scripts, html files etc.), and a server for >databases. How can I import from my script, with a csv. if the db is >on a different server than the script server. What does this

updating db with csv

2007-06-07 Thread moishyyehuda
#1 If any one familiar with godaddy hosting. They have apparently have a hosing server i.e.(scripts, html files etc.), and a server for databases. How can I import from my script, with a csv. if the db is on a different server than the script server. #2 I would like to update and insert with the