實例:
mysql>create database db2018 charset=utf8 collate utf8_general_ci;
mysql>create table tb1(id int,name varchar(20)) engine=myisam charset=utf8;
創(chuàng)建一個臨時表tbtemp,結(jié)構(gòu)與tb1一致
mysql>create table tbtemp like tb1;
實例:
mysql>create database db2018 charset=utf8 collate utf8_general_ci;
mysql>create table tb1(id int,name varchar(20)) engine=myisam charset=utf8;
創(chuàng)建一個臨時表tbtemp,結(jié)構(gòu)與tb1一致
mysql>create table tbtemp like tb1;