Making field concat of autoincrement column and other values?

From: Date: Mon, 02 Dec 2002 03:24:06 +0000
Subject: Making field concat of autoincrement column and other values?
Groups: php.db 
Request: Send a blank email to php-db+get-23756@lists.php.net to get a copy of this message
I'm trying to make a field in my database table a concat of an autoincrement value and some other values. I'm trying: insert into table set val1='val1',val2='val2',concatfield=concat('whatever',id,'whatever'), but it doesn't work. Is there another way, or will I have to update the row directly after inserting? -- The above message is encrypted with double rot13 encoding. Any unauthorized attempt to decrypt it will be prosecuted to the full extent of the law.

« previous php.db (#23756) next »