Skip to content

Instantly share code, notes, and snippets.

@Sean-Bradley

Sean-Bradley/gist:cf57d2dc5757d9f01261e8c4c2f0f1a8

Last active December 20, 2019 13:28
Show Gist options
  • Save Sean-Bradley/cf57d2dc5757d9f01261e8c4c2f0f1a8 to your computer and use it in GitHub Desktop.
Save Sean-Bradley/cf57d2dc5757d9f01261e8c4c2f0f1a8 to your computer and use it in GitHub Desktop.
Download ZIP
Create a simple MySQL table
Raw
gistfile1.txt
CREATE TABLE `exampledb`.`flat_table_example` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(45) DEFAULT NULL,
`total` decimal(10,0) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment