MySQL??????
???????????? ???????[ 2016/7/7 10:22:42 ] ????????????? MySQL
????????
???????????????????????????????????????????±??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??????????????????????????????????????
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11