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
