Shulou(Shulou.com)06/01 Report--

(1) update one column: update T_Person set Age=30 (2) update multiple columns: update T_Person set Age=30,Name='Tom' (3) update part of the data: update T_Person set Age=30 where Name='Tom', uses where statement to update only rows where Name is' Tom', note that SQL equals to judge with a single =, not = =. (4) complex logic judgment can also be used in where: update T_Person set Age=30 where Name='Tom' or Age=,), etc.

Original address: http://bbs.delit.cn/thread-156-1-1.html

Please indicate the source of the reprint:

Written by: measurement Technology http://www.delit.cn

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.