![](https://img-blog.csdnimg.cn/20201014180756913.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
有衡
这个作者很懒,什么都没留下…
展开
-
mysql left join多张表连表查询并分页
SELECT t1.*,t2.refund_id,t3.reason FROM hq_order AS t1 LEFT JOIN hq_refund AS t2 ON t1.order_id=t2.order_id LEFT JOIN hq_refund_log AS t3 ON t2.refund_id=t3.refund_id WHERE t1.order_status=4 LIMIT 0,10mysql语句介绍:连接hq_order、hq_refund、hq_refund_log三张表查询hq原创 2020-08-17 15:55:26 · 1940 阅读 · 0 评论 -
mysql left join连表条件查询指定字段
SELECT t1.*,t2.order_status FROM hq_refund AS t1 LEFT JOIN hq_order AS t2 ON t1.order_id=t1.order_id WHERE t1.order_id='2020080915969502173022139'mysql语句介绍:查询hq_refund和hq_order表hq_refund别名为t1,hq_order别名为t2查询t1的所有内容,查询t1的order_status字段hq_refund的order原创 2020-08-14 17:27:43 · 3999 阅读 · 0 评论 -
开启关闭mysql中的严格模式
1.开启通过语句来开启:set sql_mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION";通过修改mysql的配置文件来开启,如果在my.ini中找不到sql-mode则在[mysqld]下加入即可sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,N...原创 2020-02-25 12:43:38 · 974 阅读 · 0 评论 -
mysql蠕虫复制
蠕虫复制能快速的添加表中的数据//将test表中的name和age字段进行蠕虫复制insert into test(name,age) select name,age from test;原创 2020-02-01 14:13:52 · 118 阅读 · 0 评论