????????
???????????????????????????????????????????±??MYSQL????????????????
??????:
????CREATE TABLE tb_base(
????id INT NOT NULL PRIMARY KEY??
????name VARCHAR(10)??
????KEY ix_name (name))
????ENGINE='MyISAM'??CHARSET=utf8??COMMENT 'a' ;
????insert into tb_base() values(1??'a')??(2??'b');
???????LIKE????
????like??????????????????????????????????±????????????????????????????????洢??????
????CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name
????{ LIKE old_tbl_name | (LIKE old_tbl_name) }
????1.?????
????CREATE  TABLE IF NOT EXISTS tb_base_like (LIKE tb_base);
????2.????

?????????????????????????????
????????SELECT????
????CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name
????SELECT ...   (Some valid select or union statement)
????1.?????
????CREATE  TABLE IF NOT EXISTS tb_base_select SELECT * FROM tb_base;
????2.????

????like???????????????????????????????????????????洢???涼??и???
????????????
????like????:like??????????????????????????????????????????????????????????
????select?????????????select????????????????????????????????????????select???????????????????????select????κ?????????????????????????????????????????洢???楨??????????????????????????????????
???????
?????????????????????????LIKE????????????????????????????????洢???楨????????????????????select??????????????????????????????????????