CREATE TABLE a( NAME INT, age int );CREATE TABLE b( height INT, weight int );INSERT INTO a VALUES (1,2);INSERT INTO b VALUES (2,3);SELECT * FROM a;SELECT * FROM b;SELECT * FROM a;update a s, b c set s.name = c.height where s.age = c.height;
本文共 262 字，大约阅读时间需要 1 分钟。
CREATE TABLE a( NAME INT, age int );CREATE TABLE b( height INT, weight int );INSERT INTO a VALUES (1,2);INSERT INTO b VALUES (2,3);SELECT * FROM a;SELECT * FROM b;SELECT * FROM a;update a s, b c set s.name = c.height where s.age = c.height;
转载地址：http://fhpjl.baihongyu.com/