Created
November 14, 2012 16:30
-
-
Save rargulati/4073138 to your computer and use it in GitHub Desktop.
use int instead of num, should work
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- Now you can see how it works in 2012! | |
CREATE TABLE employement_se2212 | |
( | |
First varchar(10), | |
Last varchar (15), | |
title varchar (18), | |
age int(2), | |
salary int(7) | |
); | |
INSERT INTO employement_se2212 | |
(First, Last, title, age, salary) | |
VALUES | |
('Jonie', 'Weber', 'Secretary', 28, 19500), | |
('Potsy', 'Weber', 'Programmer', 32, 45300), | |
('Dirk', 'Smith', 'Programmer II', 45, 75020); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment