Brian Dunning wrote:
I have a table where I want to update each record with today's date as
it's hit, or add the record if it's not in there:
+--+-++
| id | creation_date | last_hit |
+--+-++
I'm trying to do this with a min
Hi All,
there is not-so-used format of SQL format that is
INSERT INTO table SET col1=data1, col2=data2... ON DUPLICATE KEY UPDATE
col1=data1, col2=data2...;
you have to define a primary or unique key in the table and all will
work well. for more info
http://dev.mysql.com/doc/refman/4.1/en/
Good advice , Thank you!
--
Paul Nowosielski
Webmaster
On Friday 30 June 2006 15:45, Adam Zey wrote:
> Paul Nowosielski wrote:
> > On Friday 30 June 2006 14:37, Brian Dunning wrote:
> >> I have a table where I want to update each record with today's date
> >> as it's hit, or add the record if
Paul Nowosielski wrote:
On Friday 30 June 2006 14:37, Brian Dunning wrote:
I have a table where I want to update each record with today's date
as it's hit, or add the record if it's not in there:
+--+-++
| id | creation_date | last_hit |
+--+-
On Friday 30 June 2006 14:37, Brian Dunning wrote:
> I have a table where I want to update each record with today's date
> as it's hit, or add the record if it's not in there:
>
> +--+-++
>
> | id | creation_date | last_hit |
>
> +--+-+-
>
> I have a table where I want to update each record with today's date
> as it's hit, or add the record if it's not in there:
>
> +--+-++
> | id | creation_date | last_hit |
> +--+-++
>
> I'm trying to do this with a minimu
I have a table where I want to update each record with today's date
as it's hit, or add the record if it's not in there:
+--+-++
| id | creation_date | last_hit |
+--+-++
I'm trying to do this with a minimum of hits to the d
7 matches
Mail list logo