Saturday, 17 August 2013

Mysql "select if exist else insert" basically

Mysql "select if exist else insert" basically

if select * from mytable where field = 'something' then
select somefield from mytable where field = 'something'
else insert into mytable (the fields i have data for) values (values)
any help would be greatly appreciated

No comments:

Post a Comment