全部博文(471)
发布时间:2014-06-20 19:30:11
select * from table where name not like '%aa%'......【阅读全文】
发布时间:2014-06-17 15:57:06
DELIMITER $$CREATE /*[DEFINER = { user | CURRENT_USER }]*/ PROCEDURE `yoyo`.`bb`(IN circleId VARCHAR(36),IN newhostId VARCHAR(36)) /*LANGUAGE SQL &nb.........【阅读全文】
发布时间:2014-06-17 11:17:50
UPDATE tf_categorySET NAME=REPLACE(NAME,"\r","")WHERE 1=1UPDATE tf_categorySET NAME=REPLACE(NAME,"\n","")WHERE 1=1mySQL去除换行字符和填充一张表的数据到另一张表对应的条目中mysql去除换行UPDATE dede_archives SET description=REPLA.........【阅读全文】