Quick basic SQL questions

try
1 - select * from (table)
2 - select A.field, B.field, (other fields) from table A, table B where A.field = B.field

3 - depends on the database (vendor)
select * from all.tables
select * from all.table.columns (where tablename = (table)

(mmm inner vs outer and so forth)

what's wrong with this:

CREATE TABLE client(
emp_id INT(8) AUTO_INCREMENT,
client_name VARCHAR(60) NOT NULL,
dept_id INT(4) NOT NULL,
email VARCHAR(40),
PRIMARY KEY (emp_id),
FOREIGN KEY (dept_id) REFERENCES department(dept_id)
);

is it that i can't reference a foreign key until the other table is created?

because that would suck because i can't create any of them without referencing other tables.

if it's something else, i'd be much obliged.

Yeah I think you'd have to add it after the other one's been created. ALTER TABLE if memory serves

perfect, i can at least try a workaround on that

cheers

quick q: if i created all tables in the one file and read it in, would the same apply?

Oh yeah, you could just add the ALTER statements later in the file.

i was hoping if i read it all in one, the engine or w/e would handle the statements in place

:(

that seems a somewhat glaring oversight but i only started studying this today eh whadoo i know

Wooo, did I call that?!