Skip to content

Instantly share code, notes, and snippets.

@sebgates
Last active November 26, 2017 19:24
Show Gist options
  • Save sebgates/7dbf03a763b9dbb38730e9500499e8b3 to your computer and use it in GitHub Desktop.
Save sebgates/7dbf03a763b9dbb38730e9500499e8b3 to your computer and use it in GitHub Desktop.
CREATE TABLE `boxers` (
`boxerID` int(11) NOT NULL,
`boxerName` varchar(20) NOT NULL,
`weight` varchar(50) NOT NULL,
`boxerPic` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `boxers` (`boxerID`, `boxerName`, `weight`, `boxerPic`) VALUES
(1, 'George Forman', 'Heavyweight', '895803.jpg'),
(2, 'Ali', 'Heavyweight', '641542.jpg'),
(3, 'Naseem', 'Lightweight', '415321.jpg'),
(4, 'Sugar Ray', 'Lightweight', '142077.jpg'),
(5, 'Tyson', 'Heavyweight', '804047.jpg'),
(6, 'Chris Ubank', 'Middleweight', '947996.jpg');
ALTER TABLE `boxers`
ADD PRIMARY KEY (`boxerID`);
ALTER TABLE `boxers`
MODIFY `boxerID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment