45 replies to this topic

[chili5]

I started learning SQL today and first script and I got some stupid error that I can't figure out. :(

DROP table IF EXISTS address;
CREATE TABLE address (
ID INT NOT NULL PRIMARY KEY,
firstName VARCHAR(20),
lastName VARCHAR(20),
email VARCHAR(25),
aDate DATE,
aTime TIME,
dayNumber VARCHAR(15), ## phone number to be called during the day
eveningNumber VARCHAR(15), ## phone number to be called during the evening
cellNumber VARCHAR(15) ## cell phone number
);

INSERT INTO address VALUES (0,'James','Brocklebank','james_45 @live.ca','2008-06-29','07:03:30','','','not available');

SELECT * FROM address ORDER BY lastName;

When i try to run the code I get an error message that says:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 8

I don't get it? i don't see a problem.

[Xav]

Mayve it doesn't like you. :p

[chili5]

haha very funny but if your interested I found out what was wrong with it.

DROP table IF EXISTS address;
CREATE TABLE address (
ID INT NOT NULL PRIMARY KEY,
firstName VARCHAR(20),
lastName VARCHAR(20),
email VARCHAR(25),
aDate DATE,
aTime TIME,
dayNumber VARCHAR(15), ## phone number to be called during the day
eveningNumber VARCHAR(15), ## phone number to be called during the evening
cellNumber VARCHAR(15) ## cell phone number
);

INSERT INTO address VALUES (0,'James','Brocklebank','james_45 @live.ca','2008-06-29','07:03:30','','','not available');

SELECT * FROM address ORDER BY lastName;

:D

[Xav]

What's changed?

[chili5]

I can't really remember something wasn't working :\ and i tried it and the first one worked. so maybe your right, maybe it does hate me. :\

[Xav]

Hmm... do you have a webcam installed?

[chili5]

nope why? a little random don't you think?

[Xav]

Because the SQL Server Service could be spying on you... :)

[chili5]

:o very funny but yeah, just having terrible luck with SQL today.

no more sql for today :)

[Xav]

Luckily for me, I don't use SQL... but you knew that already. :p

[chili5]

yeah :) it can do a lot of good things with it but mysql hates me apparently :\

[Xav]

Aw, diddums. :) Show it who's boss! :D