Re: Referencing other columns at INSERT

[Xeon Masters]

Hi,

Hmm, what if the table have other columns which doesn't involves the primary key, like this:

CREATE TABLE somename (
ID INT NOT NULL AUTO_INCREMENT,
data1 VARCHAR(32),
data2 VARCHAR(32),
est_time DATE,
name VARCHAR(32),
PRIMARY KEY(ID)
);

mysql> insert into A
VALUES
(NULL, 'blah1', 'blah2', ..., CONCAT_WS('_','somethingfancy',LAST_INSERT_ID()+1));

Will the above works?

TIA