Difference between revisions of "CSC220 Exercises with MySQL"
(Created page with '--~~~~ ---- __TOC__ =Store Inventory= We have a database called '''store''' with the following contents: Id Name Qty Price 1 apple 10 1 2 pear 5 2 3 banana 10 1.5 6 lemo…') |
(→store) |
||
| Line 29: | Line 29: | ||
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ; | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ; | ||
| − | |||
| − | |||
| − | |||
INSERT INTO `store` (`Id`, `Name`, `Qty`, `Price`) VALUES | INSERT INTO `store` (`Id`, `Name`, `Qty`, `Price`) VALUES | ||
Revision as of 09:20, 18 October 2010
--D. Thiebaut 14:19, 18 October 2010 (UTC)
Contents
Store Inventory
We have a database called store with the following contents:
Id Name Qty Price 1 apple 10 1 2 pear 5 2 3 banana 10 1.5 6 lemon 100 0.1 5 orange 50 0.2
Database Dumps
store
CREATE TABLE IF NOT EXISTS `store` (
`Id` int(1) NOT NULL auto_increment,
`Name` varchar(40) NOT NULL,
`Qty` int(1) NOT NULL,
`Price` float NOT NULL,
PRIMARY KEY (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
INSERT INTO `store` (`Id`, `Name`, `Qty`, `Price`) VALUES
(1, 'apple', 10, 1),
(2, 'pear', 5, 2),
(3, 'banana', 10, 1.5),
(6, 'lemon', 100, 0.1),
(5, 'orange', 50, 0.2);
