表A
dlid matname1 jsnum
123 D9 0
234 C9 0
456 T3 0表B
jscode jsnumber
D9 0.178
C9 0.179
T3 0.19请问如何将表B的Jsnumber值更新到表A的jsnum里面呢?
Update语句应该如何编写???
dlid matname1 jsnum
123 D9 0
234 C9 0
456 T3 0表B
jscode jsnumber
D9 0.178
C9 0.179
T3 0.19请问如何将表B的Jsnumber值更新到表A的jsnum里面呢?
Update语句应该如何编写???
解决方案 »
- 在MySql中怎么不能插入汉中呢 数字和字母都可以 就是汉中不行 我用的是Navicat for Mysql
- Excel VBA 连接 MySQL
- 编号从新排序后,表内数据排列就乱了,
- 实现阿拉伯数字转为中文的MYsql函数
- Linux平台上我的Mysql启动不了了
- mysql查询一个月所有员工 全部任务中每类任务 完成几次
- 是SHELL出错还是SQL出错。。。
- 请问在win2000下为何和mysql数据库连不上
- mysql查询表中全部字段中有无某个字符
- 求救,mysql行级锁释放后的问题!!!
- mysql + php 诡异的乱码。另my.ini在linux哪个文件夹里?
- MYSQL中VARCHAR字段排序的问题
update A,B set A.jsnum = B.jsnumber where A.matname1 = B.jscode;
+------+--------+
| ccc | ddd |
+------+--------+
| C9 | 0.1780 |
| D9 | 0.1980 |
| T9 | 1.1780 |
+------+--------+
3 rows in set (0.02 sec)mysql> select * from T2;
+------+------+
| aaa | bbb |
+------+------+
| C9 | NULL |
| D9 | NULL |
| T9 | NULL |
+------+------+
3 rows in set (0.01 sec)mysql> update T1,T2 set T2.bbb=T1.ddd where T1.ccc=T2.aaa;
ERROR 1064: You have an error in your SQL syntax near 'T2 set T2.bbb=T1.ddd where T1.ccc=T2.aaa' at line 1
按照两位的做法,都出错了。。——!!
ERROR 1109: Unknown table 't1' in where clause
+------+--------+
| a | b |
+------+--------+
| C9 | 0.1780 |
| D9 | 0.1780 |
| T9 | 0.1900 |
| T3 | 0.1820 |
+------+--------+
4 rows in set (0.01 sec)mysql> select * from t2;
+------+--------+
| c | d |
+------+--------+
| D9 | 0.0000 |
| C9 | 0.0000 |
| T9 | 0.0000 |
+------+--------+
3 rows in set (0.01 sec)mysql> update t2 set d=t1.b where t1.a=t2.b;
ERROR 1109: Unknown table 't1' in where clause
+------+--------+
| a | b |
+------+--------+
| C9 | 0.1780 |
| D9 | 0.1780 |
| T9 | 0.1900 |
| T3 | 0.1820 |
+------+--------+
4 rows in set (0.00 sec)mysql> select * from t2;
+------+--------+
| c | d |
+------+--------+
| D9 | 0.0000 |
| C9 | 0.0000 |
| T9 | 0.0000 |
+------+--------+
3 rows in set (0.01 sec)mysql> update t2 inner join t1 on(t1.a=t2.c) set t2.d=t1.b;
ERROR 1064: You have an error in your SQL syntax near 'inner join t1 on(t1.a=t2.c) set t2.d=t1.b' at line 1
mysql>
from A,B
where A.matname1 = B.jscode;