INSERT questions

[Alex]

2 questions:

Assuming you have a table:

CREATE TABLE `global` (
`id` int(11) unsigned NOT NULL auto_increment,
`name` varchar(64) NOT NULL default '',
`value` text,
PRIMARY KEY (`id`)
) TYPE=MyISAM;

1. I want to insert a new row using:

INSERT INTO global (name, value) VALUES ('name','value');

id will be set automatically, but is there any way to get the id used in the insert without having to do a complex SELECT (like SELECT id from global where name='name' and 'value='value')


2. Is there a way to do an UPDATE when a row exists, if not INSERT without having to do a SELECT first?


Thanks.