![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
数据库
chang_nimo
这个作者很懒,什么都没留下…
展开
-
curl_setopt
// 创建一个新cURL资源 $ch = curl_init(); curl_setopt($ch, CURLOPT_HEADER, FALSE); // 设置URL和相应的选项 curl_setopt($ch, CURLOPT_URL, "http://www.example.com/");//CURLOPT_RETURNTRA...原创 2024-05-09 17:22:52 · 218 阅读 · 1 评论 -
工作中常用到的sql语句
-- 将获取到的数据重新组合-- INSERT into keyword(keyword) select keyword from keyword_copy1 GROUP BY keyword-- INSERT into keyword(keyword) select keyword from infos GROUP BY keyword-- INSERT into result7_info(keyword,title,info,createtime) select keyword,title,..原创 2020-12-01 10:13:56 · 186 阅读 · 1 评论 -
mysql ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER privilege(s) for this
原因:ONLY_FULL_GROUP_BY,需要去掉sql_mode ="ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"修改为:sql_mode ="ST...原创 2019-01-19 14:27:15 · 19112 阅读 · 0 评论 -
mysql too many connection
打开配置文件 添加一下配置vi /etc/my.cnfwait_timeout = 600interactive_timeout = 6001.mysql -u root -p回车输入密码进入mysql2.show processlist;查看连接数,可以发现有很多连接处于sleep状态,这些其实是暂时没有用的,所以可以kill掉3.show variab...转载 2019-07-29 16:36:54 · 2046 阅读 · 0 评论 -
union order by问题
一、要求:将两个表 (table1 table2)合并 并且按照一定顺序进行排序 和limti进行限制显示SELECT * FROM ( SELECT * FROM ( SELECT id, mobile, order_sn AS out_trade_no, type AS pay_type, money AS total_amount , pay_time AS order_complete...原创 2019-09-23 17:37:18 · 132 阅读 · 0 评论