Updating a database

[johno77]

Could someone please inform me if it is possible to code the following statement so if there is no record with name equal to bni the statement inserts the details as a new record.

Many thanks

UPDATE tab SET eng="50" seq="30" where name="bni"

 

[BitFuzzy]

something like that is best left to a perl,c,or php script

 

[r937]

syntax:

INSERT [LOW_PRIORITY | DELAYED] [IGNORE]
[INTO] tbl_name [(col_name,...)]
VALUES ((expression | DEFAULT),...),(...),...
[ ON DUPLICATE KEY UPDATE col_name=expression, ... ]
example:

insert into tab ( eng, seq, name )
values ( 50, 30, 'bni' )
on duplicate key update eng=50,seq=30


assumes primary or unique key declared on name

works in mysql 4.1.0

rudy

http://r937.com/

SQL Consulting