最近在公司搞的2个SQL,做个笔记

INSERT INTO `enmysql`.`destoon_exhibit` (

`itemid` ,

`catid` ,

`areaid` ,

`level` ,

`title` ,

`style` ,

`fee` ,

`introduce` ,

`keyword` ,

`pptword` ,

`hits` ,

`thumb` ,

`username` ,

`addtime` ,

`fromtime` ,

`totime` ,

`city` ,

`address` ,

`postcode` ,

`homepage` ,

`hallname` ,

`sponsor` ,

`undertaker` ,

`truename` ,

`addr` ,

`telephone` ,

`mobile` ,

`fax` ,

`email` ,

`qq` ,

`msn` ,

`remark` ,

`editor` ,

`edittime` ,

`ip` ,

`template` ,

`status` ,

`linkurl` ,

`filepath` ,

`note` ,

`note_sp1` ,

`note_sp2` ,

`note_sp3` ,

`cat`

)

VALUES (

NULL , '0', '0', '0', '', '', '0', '', '', '', '0', '', '', '0', '0', '0', '', '', '', 'dffd', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', '', '0', '0', '', '', '', '', '', '', '0'

);

UPDATE `enmysql`.`destoon_exhibit` SET `linkurl` = concat('show.php?itemid=',(select LAST_INSERT_ID())) where `itemid`=(select LAST_INSERT_ID());




step1:
UPDATE `destoonlzh`.`destoon_exhibit` SET `title` = concat('我是一个很不常见字符',title);
step2:
UPDATE `newcn`.`destoon_buy` SET `title` =replace(title,'我是一个很不常见字符vietnam','');
step3:
UPDATE `newcn`.`destoon_buy` SET `title` =replace(title,'我是一个很不常见字符','');
FINISH~


清除某表的数据
truncate table ****