mysql 复制表结构、内容

    def create_and_copy_table(self,new_table,from_table):
        # sql = "create table {new_table} select * from {from_table} ;".format(new_table='sign_event', from_table='sign_event_copy1')
        sql_create ='''create table {new_table} like {from_table}  ;'''.format(new_table=new_table, from_table=from_table)
        self.cursor.execute(sql_create)
        self.connectiong.commit()
        sql_copy = '''INSERT into {new_table} SELECT * from {from_table}  ;'''.format(new_table=new_table, from_table=from_table)
        self.cursor.execute(sql_copy)
        self.connectiong.commit()
        

先复制表结构，再复制内容。