Skip to content

Instantly share code, notes, and snippets.

@s1s1ty

s1s1ty/post.sql

Created July 10, 2018 14:45
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save s1s1ty/674a3650d600c18cb19656369d762eef to your computer and use it in GitHub Desktop.
Save s1s1ty/674a3650d600c18cb19656369d762eef to your computer and use it in GitHub Desktop.
Download ZIP
table create
Raw
post.sql
CREATE DATABASE IF NOT EXISTS `go-mysql-crud` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */;
USE `go-mysql-crud`;
/* Create table for `posts` */
DROP TABLE IF EXISTS `posts`;
CREATE TABLE `posts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`content` longtext COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment