Skip to content

Instantly share code, notes, and snippets.

@rargulati
Created November 14, 2012 16:30
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 rargulati/4073138 to your computer and use it in GitHub Desktop.
Save rargulati/4073138 to your computer and use it in GitHub Desktop.
use int instead of num, should work
-- 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