Database UPDATE statement related issues

Database UPDATE statement issues
Update table name set column name = string + table id+ string how to write

------Solution--------------------
Update table name set column name = ' segment string ' + table id+ ' string ';
------Solution--------------------
Hehe, #1 building Good Humor:)

Should I use CONCAT ()? ......
------Solution--------------------
discuss

Hehe, #1 building Good Humor:)

Should I use CONCAT ()? ......

------Solution--------------------
Update table name set column Name 1 = ' String 1 ', column name 2 = ' String 2 ', column name 3 = ' String 3 ' ....
------Solution--------------------
Update is a change data operation
------Solution--------------------
followed by where id= ' 1 '
------Solution--------------------
Use. Connection
------Solution--------------------
What he meant was to update the data in a known id= ' 1 ' data
------Solution--------------------
I don't know
------Solution--------------------
Update tablename set Name= '. $name. ' Where id=1;
------Solution--------------------
discuss

Update Winiis_c_fileaq set pageup= '. /aq/1207/index_ ' +cast (c_id-1 as varchar) + '. html '
I wrote it myself.

