• mysql 表结构的复制


    复制结构:仿照student表结构复制一张new_student表,新表是空的:

    create table new_student like student;

    复制数据:但是没主键,结构不重要:

    create table new_student2 as
    (    
        select * from student
    );

    复制表结构与数据,一模一样:

    insert into new_student3 select * from student;
  • 相关阅读:
    053587
    053586
    053585
    053584
    053583
    053582
    053581
    053580
    053579
    053578
  • 原文地址:https://www.cnblogs.com/shuai06/p/12397491.html
Copyright © 2020-2023  润新知