CS290F Fall 2006 - UCSB Computer Science - Thorsten von Eicken

Path 2 SQL Queries

SHOW FIELDS FROM users
-- Looks Ok

SELECT * FROM users WHERE (users.`login` = 'alevi' ) LIMIT 1
-- Looks Ok

SELECT * FROM users WHERE (users.`id` = 3 ) LIMIT 1
-- Looks Ok

SHOW FIELDS FROM employers
-- Looks Ok

SELECT count(*) AS count_all FROM employers e inner join authorizations a on e.id = a.employer_id WHERE (a.user_id = 3)
-- Looks Ok

SELECT * FROM employers e inner join authorizations a on e.id = a.employer_id WHERE (a.user_id = 3) LIMIT 0, 10
-- Looks Ok

SHOW FIELDS FROM joblistings
-- Looks Ok

BEGIN
INSERT INTO joblistings (`city`, `title`, `url`, `dateposted`, `snippet`, `employer_id`, `state`) VALUES('Goleta', 'Manager', NULL, '2006-11-14 17:31:50', 'WE\'re looking for a manager', 126, 'CA') 
COMMIT
-- Looks Ok