随笔分类 -  mysql

Excel数据导入数据库
摘要：="insert into table(field,fieldName) values("&A2&","&B2&")" 阅读全文
posted @ 2019-07-24 11:10 小蚊子大人KN 阅读(182) 评论(0) 推荐(0) 编辑
MySQL数据库汇总
摘要：SELECT i.order_id AS orderId, GROUP_CONCAT(d.item_name, '×', d.num, CHAR(10 using utf8)) AS itemInfo, i.create_time AS createTime, i.user_name AS user 阅读全文
posted @ 2019-07-24 10:51 小蚊子大人KN 阅读(481) 评论(0) 推荐(0) 编辑

喜欢请打赏

扫描二维码打赏

了解更多

点击右上角即可分享
微信分享提示