Database update statement problems update table name set column name a String + table id + string how to write ------ solution ---------------- update table name set column name a String + table id + string; ------ solution ------------------ hehe, #1 floor humorous :) should I use CONCAT? ...... ---- Database update statement problems
Update table name set column name = A String + table id + how to write a string
------ Solution --------------------
Update table name set column name = 'string' + table id + 'string ';
------ Solution --------------------
Hehe, # humor on the first floor :)
Should I use CONCAT ?......
------ Solution --------------------
Discussion
Hehe, # humor on the first floor :)
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 data change operation.
------ Solution --------------------
Add where ID = '1'
------ Solution --------------------
Connect.
------ Solution --------------------
It means to update the data in a known ID = '1 '.
------ Solution --------------------
I don't know either.
------ Solution --------------------
Update tablename set name = '. $ name.' where id = 1;
------ Solution --------------------
Discussion
Update winiis_c_fileaq set pageup = '../aq/1207/index _' + cast (c_id-1 as varchar(201_1_1_'.html'
I wrote it myself.