我写了个测试语句
update user2 set user2.name = user1.name
from user2 inner join user1 on user2.id = user1.id ;运行有错误,请问正确的应该怎么写??
update user2 set user2.name = user1.name
from user2 inner join user1 on user2.id = user1.id ;运行有错误,请问正确的应该怎么写??
解决方案 »
- Mysql 分区 查询未用到
- 数据库查询小问题
- 请教Lost connection to MySQL server at 'reading initial communication packet'
- 调用MySQL存储过程错误
- mysql引擎inodb与isam?
- 我想从A表里随机抽取若干条数据,每次抽取的不一样,我该怎么做?请高手帮忙呀!!多谢!!!
- sql查询问题
- 抗议MYSQL的默认字符集是 latin1_swedish_ci
- jdbc连mysql的中文显示问题,和驱动有关吗?急!!
- MySQL中localhost与127.0.01有什么区别?
- postgresql语句 处理数组的sql语句,高手请进
- ----------------求助,MySQL问题----------------
set user2.name = user1.name
update user2 ,user1 set user2.name = user1.name
where user2.id = user1.id
我记得好象可以用FROM的,所以想学习下这个方法?
Single-table syntax: UPDATE [LOW_PRIORITY] [IGNORE] tbl_name
SET col_name1=expr1 [, col_name2=expr2 ...]
[WHERE where_condition]
[ORDER BY ...]
[LIMIT row_count]Multiple-table syntax: UPDATE [LOW_PRIORITY] [IGNORE] table_references
SET col_name1=expr1 [, col_name2=expr2 ...]
[WHERE where_condition]