Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save kevinmesiab/65b002b8a7f7f8331164 to your computer and use it in GitHub Desktop.
Save kevinmesiab/65b002b8a7f7f8331164 to your computer and use it in GitHub Desktop.
MySQL Enum Syntax - Month, Day Names, Days Per Month
/* Full month names */
ENUM ('January', 'February', 'March', 'April', 'May', 'June','July', 'August', 'September', 'October', 'November', 'December');
/* Full week day names */
ENUM('Sunday', 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday');
/* Days in month, from Jan-Dec */
ENUM('31','28','31','30','31','30','31','31','30','31','30','31');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment