java_w的专栏

搭建数据库主从集群并且初始化数据库192.168.10.243 #cetus192.168.10.250 #M192.168.10.251 #S#开启延迟检测需要创建心跳表create database if not exists proxy_heart_beat; use proxy_heart_beat; CREATE TABLE if not exists tb_h...

sqlserver创建新表和数据select * into newtable  from oldtable where col=xxx插入数据insert into table1 （col1,col2） select (col1,col2) from table2条件成功复制表结构和数据 不成功只是复制表结构

showglobalvariableslike'%general%';set global general_log=on;set global log_output=table;select * from mysql. general_log\G;altertablegeneral_logengine=myisam;set global gene...

SELECT   IFNULL(Sdate,"总计") AS Sdate ,COUNT(DISTINCT orderDeputyID) AS '下单数',SUM(ticketCount) AS '票张数',COUNT(DISTINCT payorderDeputyID ) '支付订单数',SUM(payticketCount) '支付票单数',COUNT(DISTINCT

多行转列SELECT id,GROUP_CONCAT(CONCAT_WS(',',id,num,sid,NAME) ORDER BY id DESC SEPARATOR '. ') FROM T_group_concat  GROUP BY id;