Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save sachinsmc/8f0f46ca2fc448b256e01b9a7c9524e2 to your computer and use it in GitHub Desktop.
Save sachinsmc/8f0f46ca2fc448b256e01b9a7c9524e2 to your computer and use it in GitHub Desktop.
JSON In MySQL
CREATE TABLE `book` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(200) NOT NULL,
`tags` json DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment