Two SQL questions

Shibbey

I have a php script that executes teh following SQL Query:

CREATE TABLE botRaids(ref INT PRIMARY KEY AUTO_INCREMENT,host TINYTEXT,when DATETIME,target TINYTEXT,credit LONGTEXT)

However I get the following error, when I execute it...

You have an error in your SQL syntax near 'when DATETIME,target TINYTEXT,credit LONGTEXT)' at line 1

What is my error? I am still SQL stupid..

My second question:
What is the purpose of JOIN? Is it like LINK TABLES in Access? If so, how is it used? I would benifit greatly from being able to do this.

Thank you in advance for the help

Shibbey

OK..got the solution to the SQL Query....."when" is not an allowable field name...chnaged to "eventtime"

CREATE TABLE botRaids(ref INT PRIMARY KEY AUTO_INCREMENT,host TINYTEXT,eventtme DATETIME,target TINYTEXT,credit LONGTEXT)

Works like a champ now....still confused on how to use JOIN...

Basically, in the above created table, I want to get rid of the credit field...(it is a list of peoples names.) Ans have a separate table full of the names linked to the raidtable via the raidtable.ref

nnichols

It is because you used "when" as a table name. "WHEN" is a reserved word and MySQL spat it out.

A JOIN is what is used to create a link between multiple tables.

So if we have the following 2 tables -

USER_TBL
user_id
username
password

USER_PROFILES
user_id
profile

if we want to query for the related data from the 2 tables we could use something like -

SELECT *
FROM USER_TBL, USER_PROFILES
WHERE USER_TBL.user_id=USER_PROFILES.user_id

this would show us the user_id,username,password,user_id1 (coz we already got it once) and profile as a row for each user.

This is only a very simple example of a JOIN. No doubt you will come across far more complex examples as you get going. It is easier to explain them when you have a practical requirement.

EDIT:
OOPS! I was a bit slow there