Skip to content

Instantly share code, notes, and snippets.

@radityopw

radityopw/kupon.sql

Created February 15, 2017 01:49
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 radityopw/26dc8bef34fd7fe9fdb4272f9c0841fd to your computer and use it in GitHub Desktop.
Save radityopw/26dc8bef34fd7fe9fdb4272f9c0841fd to your computer and use it in GitHub Desktop.
Download ZIP
contoh pembuatan tabel kupon.sql
Raw
kupon.sql
CREATE TABLE `kupon` (
`code` varchar(5) NOT NULL,
`max_usage` int(11) NOT NULL DEFAULT '10',
`usage` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `kupon` (`code`, `max_usage`, `usage`) VALUES ('CQ839', '10', '0');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment