mysql的查询进行新增，修改，删除

最新推荐文章于 2024-09-22 20:25:27 发布

学习的路上不只有你

最新推荐文章于 2024-09-22 20:25:27 发布

阅读量1k

点赞数

分类专栏： java 文章标签： mysql 数据库 database

本文链接：https://blog.csdn.net/qq_39558517/article/details/125216244

版权

java 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

新增：新增字段和查询字段个数相同。
INSERT INTO coal_prices_trend (id,a_fare,two_tickets,create_time,goods_type,type)

(SELECT id,excluding_tax_price 一票,including_tax_price,created_time,coal_type 类型,3 FROM fields_price)
修改：修改字段和查询字段个数相同。
update coal_prices_trend (id,a_fare,two_tickets,create_time,goods_type,type)

(SELECT id,excluding_tax_price 一票,including_tax_price,created_time,coal_type 类型,3 FROM fields_price)
where id=‘’

多个表进行查询显示多个表的数据思路：
SELECT address,num,visvit_num FROM (
SELECT count(*) num,SUBSTRING_INDEX(end_point,‘,’,1) address from driver_route GROUP BY SUBSTRING_INDEX(end_point,‘,’,1) ORDER BY num desc LIMIT 10
) d LEFT JOIN (

SELECT count(*) visvit_num,SUBSTRING_INDEX(d.end_point,‘,’,1) address1 FROM driver_route d
LEFT JOIN driver_user_account da
on d.user_id = da.id
where da.contact_user is not null
GROUP BY SUBSTRING_INDEX(d.end_point,‘,’,1)
) d1 on d.address = d1.address1