Skip to content

Instantly share code, notes, and snippets.

@StalinMazaEpn

StalinMazaEpn/mysqlShortcuts

Last active August 3, 2024 04:03
Show Gist options
  • Save StalinMazaEpn/4c280ba6806d3ff1f09cbaa6c0e2cc66 to your computer and use it in GitHub Desktop.
Save StalinMazaEpn/4c280ba6806d3ff1f09cbaa6c0e2cc66 to your computer and use it in GitHub Desktop.
Download ZIP
MYSQL Shortcuts
Raw
mysqlShortcuts
## Filter by month, year or day
YEAR(usageDate) = 2023
MONTH(usageDate) = 12
# Manage JSON
SELECT JSON_OBJECTAGG(notificationTemplateType, true)
FROM (SELECT DISTINCT notificationTemplateType FROM APP_NOTIFICATION_TEMPLATE) AS unique_notification_types;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment