摘要:
1.根据B表的关键字段更新A表的字段 UPDATE A,B SET A.age = B.age ,A.name = B.name WHERE A.id = B.id; 阅读全文
posted @ 2021-06-02 16:05
stuka
阅读(371)
评论(0)
推荐(1)
摘要:
1.mysql 复制表结构 CREATE TABLE book_tmp AS SELECT * FROM book WHERE 1 = 2; 阅读全文
posted @ 2021-06-02 16:02
stuka
阅读(200)
评论(0)
推荐(0)