SQL experts, can you please help. - GoFuckYourself.com

Just Alex · 05-23-2012, 01:46 PM

Ok, so I have primary key thats AUTO_INCREMENT. There's another field file_name that I need to populate with number from primary key plus file extension

So right now its like this and I need to run an update query to populate file_name fields

File_Id File_name
1 NULL
2 NULL
3 NULL

To be

File_Id File_name
1 1.jpg
2 2.jpg
3 3.jpg

What's correct structure of update query?

Thank you

Brujah · 05-23-2012, 02:10 PM

UPDATE table SET File_name = CONCAT( File_id, '.jpg' );

Just Alex · 05-23-2012, 02:13 PM

Quote:

Originally Posted by Brujah

UPDATE table SET File_name = CONCAT( File_id, '.jpg' );

Huh, it worked. Im so stupid adding convert(varchar(100) to this thinking numeric field cant be concatenated in text fields.

Thank you very much!

05-23-2012, 01:46 PM	#1
Just Alex Liv Benson to You, Bitch Industry Role: Join Date: Aug 2007 Location: Maryland and WV Posts: 6,060	SQL experts, can you please help. Ok, so I have primary key thats AUTO_INCREMENT. There's another field file_name that I need to populate with number from primary key plus file extension So right now its like this and I need to run an update query to populate file_name fields File_Id File_name 1 NULL 2 NULL 3 NULL To be File_Id File_name 1 1.jpg 2 2.jpg 3 3.jpg What's correct structure of update query? Thank you __________________

05-23-2012, 02:10 PM	#2
Brujah Beer Money Baron Industry Role: Join Date: Jan 2001 Location: brujah / gmail Posts: 22,157	UPDATE table SET File_name = CONCAT( File_id, '.jpg' ); __________________ Free Premium Domain Lists and Tools at Clickmojo.com For Sale: Obscenity.com