MySql
Tiglle
这个作者很懒,什么都没留下…
展开
-
一些sql
1.分组条件查询,查组内符合条件的 select id,member_id,scan_time,scan_province,scan_city,scan_area from member_scan_property where scan_time in (select MAX(scan_time) from member_scan_property group by member_原创 2017-08-10 18:39:00 · 238 阅读 · 0 评论 -
比较复杂的sql
select from_base64(o.nick_name) from activity_win_record o left join activity_win_recipient p on o.id = p.win_idSELECT o.nick_name, o.prize_name, o.win_amount, o.create_dat原创 2017-08-25 17:26:41 · 262 阅读 · 0 评论 -
PowserDesign生成代码有注释
Database –> Generate Database。 在 Format 页中,勾选 Generate name in empty comment原创 2018-07-23 09:53:12 · 636 阅读 · 0 评论