masuwen博客

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

-- 要查找包含五个字符的名称 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...

# ************************************************************ # 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 MySQL sudo /usr/local/mysql/support-files/mysql.server stop Start it in safe mode: sudo mysqld_safe --skip-grant-tables This 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 ...

BEGIN DECLARE 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

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

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.html MySQL 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