mysql
小年轻呀
你猜...
展开
-
腾讯云开放3306端口还是无法连接数据库
仅限自己安装的mysql.1、先登录mysql,输入mysql -uroot -p密码2、开启远程连接,输入命令GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘密码’ WITH GRANT OPTION;3、刷新权限FLUSH PRIVILEGES;原创 2020-12-23 13:33:57 · 1841 阅读 · 0 评论 -
主表先查出数据再左连接
select d.*,v.phone, (SELECT real_name FROM tableb WHERE d.user_id= user_id AND del_flag = '0') as approvalUserName from (SELECT d.* FROM tablea d WHERE 1=1 limit #{currIndex} , #{pageSize} )as d .原创 2020-11-17 15:15:36 · 526 阅读 · 0 评论 -
MySQL查询距离当前时间最近的记录
SELECT * FROM TABLE WHERE 1 = 1 ORDER BY abs(DATEDIFF(now(), time)) ASC原创 2020-10-14 09:37:45 · 1857 阅读 · 0 评论 -
mysql查询今天的数据
select k.goods_id,k.goods_name,k.skill_price,k.skill_number,k.skill_time,k.skill_state,i.goods_image,g.goods_price oldPrice from nmr_secondkill k,nmr_goods_images i,nmr_goods g,nmr_store s where原创 2016-06-30 09:01:42 · 601 阅读 · 0 评论 -
mysql查询以前的数据(mysql查询七天前/半小时前等)
FRAC_SECOND。表示间隔是毫秒SECOND。秒MINUTE。分钟HOUR。小时DAY。天WEEK。星期MONTH。月QUARTER。季度YEAR。年 select * from nmr_egiftcard_order where TIMESTAMPDIFF(day,from_unixtime(egco_last_give_time/1000),原创 2016-11-14 09:50:12 · 8834 阅读 · 0 评论 -
mysql一个字段多个值关联另一张表
A表的id字段是以'1,2,3,4,5'...这样的形式存的,它关联字典表B的id字段,此时需求是要查出name SQL:SELECTa.id,(SELECTGROUP_CONCAT(b.NAME)FROMtableb bWHEREFIND_IN_SET(b.id,a.id))idnameFROMtablea aWHERE原创 2017-04-13 19:23:29 · 10072 阅读 · 2 评论 -
MySQL给查出来的数据加序号
SELECT @rowNum := @rowNum+1 AS rownum,u.id FROM sys_user u,(SELECT @rowNum:=0) r原创 2018-09-14 15:51:09 · 2992 阅读 · 0 评论 -
mysql5.7忘记root密码
第一步,打开cmd进入到MySQL安装目录的bin下。第二步,输入use msql第三步,输入update user set authentication_string = password(“123456”) where user = “root”;搞定。...原创 2018-12-12 16:51:11 · 109 阅读 · 0 评论 -
mysql根据子节点查父节点
<select id="id" resultMap="BaseResultMap" > SELECT t2.* FROM ( SELECT @r AS _id, ...原创 2019-08-12 09:09:34 · 1362 阅读 · 0 评论