If you specify ON DUPLICATE

lynnabbyy — Sat, 22 Jun 2013 07:36:37 +0000

If you specify ON DUPLICATE KEY UPDATE , and a row is inserted that would cause a duplicate value in a UNIQUE index or PRIMARY KEY

for insert- insert into

RohanJaiswal — Wed, 24 Apr 2013 05:48:40 +0000

for insert- insert into tablename values('abs', 23, 'retye', 30);
for update-update tablename set attribute1=value1 where some_attribute=some_value;

GOd I love this forum

princeromoe — Fri, 02 Nov 2012 12:06:10 +0000

GOd I love this forum

$insert_query="insert into

David26 — Thu, 15 Mar 2012 12:21:44 +0000

$insert_query="insert into puppybasket (number_of_puppies,color) values ('val1','val2')"; //val1 has the number and val2 has the color
mysql_query($insert_query);
$update_query="update basket set total=total+'val1' where condition"; // total will be updated to total+number of new puppies added.
mysql_query($update_query);

Dear i m sending you two

jhnbrwn — Fri, 06 May 2011 01:39:25 +0000

Dear i m sending you two mysql queries just check it, hope you will be satisfied.
1.insert into myUserTable (userId,login_time) values(3421,432432);

update myUserTable set logged_counts=logged_counts+1;
2.insert into myUserTable (userId,login_time)values(3421,3122) on DUPLICATE KEY UPDATE logged_counts=logged_counts+1;

-- if the table is empty it will insert 0 as the first value, as long as u do not have default as 1.
just try it

i think shaggy has posted the

adairace — Wed, 23 Dec 2009 12:44:54 +0000

i think shaggy has posted the most exact answer near to me.
i really appreciate his little effort.

You have to have a

Megatron — Thu, 21 May 2009 18:07:52 +0000

You have to have a relatively newer MySQL server... I think on duplicate key became available on mysql 4.1

Thanks to this thread it

n1tr0b — Fri, 24 Apr 2009 12:22:30 +0000

Thanks to this thread it really helped me.... for updating some of my content

Thats going to save a lot of

altweb — Mon, 23 Mar 2009 03:58:50 +0000

Thats going to save a lot of time! I should be reading the mysql docs instead of the forums. Thanks for the tip!

Works perfect. Thanks

serpico — Wed, 18 Feb 2009 08:20:34 +0000

Works perfect. Thanks Shaggy!