MySql与Sql Server Update语句

来源：互联网发布：二手貂皮大衣淘宝网编辑：程序博客网时间：2024/06/09 18:09

MySql:

UPDATE TableAINNER JOIN tableB ON TableA.ITEMNO = tableB.ITEMNOSET TableA.column1 = tableB.column1, TableA.STATUS = IFNULL(    tableB.ITEMSTATUS,    'ITEMSTATUS')WHERE    ID = 'ID'AND IFNULL(TableA.ITEMNO, '') <> ''AND IFNULL(TableA.column1, '') = ''

Sql Server：

UPDATE TableASET TableA.column1 = tableB.column1, TableA. STATUS = ISNULL(    tableB.ITEMSTATUS ,'ITEMSTATUS')FROM    TableAINNER JOIN tableB ON TableA.ITEMNO = tableB.ITEMNOWHERE    ID ='ID'AND ISNULL(TableA.ITEMNO, '') <> ''AND ISNULL(TableA.column1, '') = ''

下面是MySql更新语法
1、单表的UPDATE语句

UPDATE [LOW_PRIORITY] [IGNORE] tbl_nameSET col_name1=expr1 [, col_name2=expr2 ...][WHERE where_definition][ORDER BY ...][LIMIT row_count]

2、多表的UPDATE语句

UPDATE [LOW_PRIORITY] [IGNORE] table_referencesSET col_name1=expr1 [, col_name2=expr2 ...][WHERE where_definition]

作者：jiankunking 出处：http://blog.csdn.net/jiankunking

1 0