A表的reviewhost = B表的hostplan时,将B表的hostname拷贝到A表的hostname
挺复杂的,不知道怎么写
挺复杂的,不知道怎么写
解决方案 »
- count(*)出現錯誤 #1062 - Duplicate entry 'SPP-Online-NE5532AD' for key 1 ?
- 外键约束的InnoDB数据如何备份和恢复还原
- 关于mysql记录获取问题?急
- 按where条件插入的数据操作?
- perl(Class::MethodMaker) is needed by 怎么处理
- 很急的问题,用SQL计算当月的天数
- 怎么看MySQL当前的连接数?
- 急问,postgresql如何与kylix3的dbexpress连接阿
- Can't create/write to file '/tmp/#sql_994_0.MYI'的错误怎么解决?
- where后使用case when的问题
- 问个小问题,insert插入语句也错了
- mysql-bin.log not found
set a.hostname=b.hostname
update a set hostname=b.hostname
where a.reviewhost=b.hostplan
update a inner join b on a.reviewhost = b.hostplan
set a.hostname=b.hostname and a.hostname !=""
这样报错
update a inner join b on a.reviewhost = b.hostplan
set a.hostname=b.hostname where a.hostname !=""
set a.hostname=b.hostname
or
update a inner join b on a.reviewhost = b.hostplan
set a.hostname=b.hostname
where a.hostname<>""
update a inner join b on a.reviewhost = b.hostplan
set a.hostname=b.hostname where a.hostname !=""