SQL Columns: UID, ID, First Name, Filename
该文件名将以下划线为"名字",按UID遵循,按照下划线跟随,按ID遵循。因此:
UID = 2
ID = 1
First Name = John
Filename = John_2_1.jpg
我尝试了:
Update Members Set Filename='First Name'.'_'.'UID'.'_'.ID.'.jpg'
Update Members Set Filename='First Name'&'_'&'UID'&'_'&ID&'.jpg'
使用 concat
Update Members Set Filename=concat(`First Name`,'_',`UID`,'_',`ID`,'.jpg')
或
Update Members Set Filename=concat_ws('_',`First Name`,`UID`,`ID`,'.jpg')