masuwen博客

　7月5日消息，据国外媒体报道，全球知名开源软件拥护者、MySQL数据库创始人迈克尔·维德纽斯（Michael Widenius）已于7月2日向卢森堡欧洲法院提出上诉，对欧盟反垄断机构在“今年年初甲骨文公司收购Sun微系统公司问题上”开绿灯的做法表示反对。　　今年1月份，欧盟反垄断机构批准甲骨文收购Sun交易后仅六天，两家公司就完成了合并。鉴于欧洲最高反垄断机构已经批准这次收购交易的现状，维德纽斯的上诉并不能对该收购事件造成实质性的影响，但对欧盟委员会作出相关决策过程的透明化进程

# ************************************************************# Sequel Pro SQL dump# Version 4541## Host: 127.0.0.1 (MySQL 5.7.15)# Database: menagerie# Generation Time: 2019-08-31 04:15:19 ...

Stop MySQLsudo /usr/local/mysql/support-files/mysql.server stopStart it in safe mode:sudo mysqld_safe --skip-grant-tablesThis will be an ongoing command until the process is finished so open an...

--查询父级SELECT T2.jgid, T2.`sjjgid` ,t2.`jgmc`FROM ( SELECT @r AS _id, (SELECT @r := sjjgid FROM `yygl_jgxx` WHERE jgid = _id) AS 2v2, @l := @l + 1 AS lvl ...

BEGINDECLARE a,b,c VARCHAR(32);DECLARE IS_FOUND INT;DECLARE cur1 CURSOR FOR SELECT id, paper_name,paper_fraction FROM examination_paper;DECLARE CONTINUE HANDLER FOR NOT FOUND SET IS_FOUND=0;...

INSERT into examination_score_info (student_code,student_name,class_id,class_name)  SELECT student_id,paper_id,score from e功能说明: 把一个表的字段查询出来插入到另外一个表中 ....

遇到这个问题,与mysql版本有关, 5.5 能通过,5.7通不过;解决办法: 把 limit 放在order by后面, limit 不要与 union 出现在同一个位置.

典型的行转列-- mysql 行函数SELECT SUM(CASE MONTH(jxfp_cxptcj.kprq) WHEN '1' THEN 1 ELSE 0 END) AS 一月份, SUM(CASE MONTH(jxfp_cxptcj.kprq) WHEN '2' THEN 1 ELSE 0 END) AS 二月份, SUM(CASE MONTH(jxfp_cxpt

DELIMITER $$USE `test`$$DROP FUNCTION IF EXISTS `nextval`$$CREATE DEFINER=`root`@`localhost` FUNCTION `nextval`(seq_name VARCHAR(50)) RETURNS INT(11)    DETERMINISTICBEGIN    

DELIMITER $$USE `test`$$DROP FUNCTION IF EXISTS `currval`$$CREATE DEFINER=`root`@`localhost` FUNCTION `currval`(seq_name VARCHAR(50)) RETURNS INT(11)    READS SQL DATA    DETERMI

-- mysql 查询一级菜单SELECT DISTINCT d.id AS "id", d.pid AS "pid", d.name AS "name", d.icon AS "icon", d.description AS "description", d.url AS "url", d.ordernum AS "orderNum", is_leaf_res

1,命令 查找my.cnf文件sudo find / -name my.cnf;登录localhost./mysql -uroot -p -hlocalhost登录192.168.26.27./mysql -uroot -p -h192.168.26.27登录127.0.0.1./mysql -uroot -p -h127.0.0.1./

描述：mysql5.7执行sql语句导入时报错mysql 5.7 Error : Incorrect datetime value: '0000-00-00 00:00:00' 报错。因为mysql 5.7后The TIMESTAMP data type is used for values that contain both date and time parts. TI

https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.htmlMySQL 5.7.6 and later:ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';MySQL 5.7.5 and earlier:SET PASS

<br />在mysql安装目录下，找到my.ini 文件，查找 default-character-set,值修改为 GBK就OK了。<br /> 

前一段时间好用，但过了一段时间后，sql server服务管理器不能正常启动了。//解决办法， 创建批处理文件，StartMSSQLService.bat@echo offset nowtime=%dateecho 2008-08-22|datesc start MSSQLSERVERping -n 5 127.1>nulecho %nowtime%|dateexi

-- 要查找包含五个字符的名称SELECT * FROM pet WHERE name LIKE '_____'-- Claws Gwen cat m 1994-03-17 NULL--查询名称以b开头的动物SELECT * FROM pet WHERE name REGEXP '^b';-- 查找名称以fy结束的动物SELECT * FROM pet WHERE name...