1、数据库批量更新
UPDATE 数据库名.表名 t SET t.business_no = CONTACT(值,SUBSTR(数据库字段,起始位置)),t.update_time = NOW() WHERE 主键 = 目标值
2、数据库之select执行顺序(这个是转载,但是记不得地址了23333)
8) SELECT (9) DISTINCT (11) <TOP_specification> <select_list>
--(1) FROM <left_table>
--(3) <join_type> JOIN <right_table>
--(2) ON <join_condition>
--(4) WHERE <where_condition>
--(5) GROUP BY <group_by_list>
--(6) WITH {CUBE | ROLLUP}
--(7) HAVING <having_condition>
--(10) ORDER BY <order_by_list>