Your statement is fine as it is. Only problem is, you can't use it like a normal query. Control structures like IF or WHILE are only allowed in stored procedures or functions. Fallout New Vegas Cracked Launcher. Just create a procedure like this: delimiter $$ create procedure select_or_insert() begin IF EXISTS (select * from users where username = 'something') THEN select id from users where username = 'something'; ELSE insert into users (username) values ('something'); END IF; end $$ and call it like this: call select_or_insert(); That's it. You can try like this:- if exists( select * from mytable where field = 'something') begin select somefield from mytable where field = 'something'; end else begin insert into users (username) values ('something'); end or if not exists( select * from mytable where field = 'something') begin insert into users (username) values ('something'); end else begin select somefield from mytable where field = 'something'; end Although both the above queries are same. Or try this using if: IF EXISTS (select * from mytable where users = 'something') select field from mytable where users = 'something' else into mytable (users) values ('something') Here is the.

List: From: Paul Chvostek Date: July 13 2003 1:52pm Subject: Re: query: if exists UPDATE else INSERT? On Sun, Jul 13, 2003 at 11:50:40AM +0200, Alexander Newald wrote: >>I'm looking for a solution to write a sql query that inserts a set of data if the >data id is not present and otherwise update the set.

Bleach Blade Battlers 2nd Ps2 Iso Free Download. We covered some of this in a thread named 'Bulk loading data' that started on July 8th. Two solutions were described in that thread. >I have a table with id (char(8)) and value (int(8)) >>To make my problem clear: >>There is no set with id = '20030713' >insert into table values ('20030713','10'); >>The next set is ('20030713','20') but as a set with 20030713 is already available I >like to have >update table set value = value + 20 where id = '20030713' You need to set your table up with id in a UNIQUE index (if it's the PRIMARY KEY, that's sufficient), then for each new record, you first do an update (which will fail if the record DOESN'T exist) and then do an insert (which will fail if the record DOES exist). $id='20030713'; $value='10'; $q = 'UPDATE table SET value=value+$value WHERE id='$id';'; $q.= 'INSERT INTO table (id,value) VALUES ('$id',$value)'; @mysql_query($q); Or if you want to be fancy (that is, more careful): $id='20030713'; $value='10'; $q1 = 'UPDATE table SET value=value+$value WHERE id='$id'; $q2 = 'INSERT INTO table (id,value) VALUES ('$id',$value)'; if (!@mysql_query($q1)) if (!@mysql_query($q2)) $err='Database failure for $id'; >Download Whatsapp Application For Nokia Asha 203. I tried the 'replace' command but I fail to get the 'value = value + 20' working.