复制表

xiaoxiao2021-02-28  90

1. 复制一张表, (结构+表中的内容)

create table teacher_bak as select * from teacher;

2.插入来自其他表的记录

insert into A表 select a,b,c from B表;

3. 只复制一张表的结构

create table teacher_bak as select * from teacher where 1=2;

转载请注明原文地址: https://www.6miu.com/read-26051.html

最新回复(0)