• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

mySQL + Unix

F

farseeker

Guest
#1
Hey all,

I've got a nice technical question for you all about mySQL on a Unix Server. Here's the deal:

1) I telnet my server (hosting.connect.com.au)
2) I log in fine
3) bash$ /opt/mysql/bin/mysql --host=mysql -P 10194 -p[password]
4) USE [dbname]
5) Enter the following command:

CREATE TABLE ib_calendar (
MEMBER_ID varchar(32) NOT NULL,
MEMBER_NAME varchar(32) NOT NULL,
DAY smallint(2) DEFAULT '0' NOT NULL,
MONTH smallint(2) DEFAULT '0' NOT NULL,
YEAR smallint(4) DEFAULT '0' NOT NULL,
TIME_ADJUST varchar(4),
UTIME int(10) NULL,
FORUM_ID smallint(5) NULL,
TOPIC_ID bigint(10) NULL,
PRIMARY KEY (MEMBER_ID),
INDEX calendar_idx1(FORUM_ID),
INDEX calendar_idx2(TOPIC_ID)
);

6) It spits back:

ERROR 1064: You have an error in your SQL syntax near '(10) NULL,
FORUM_ID smallint(5) NULL,
TOPIC_ID bigint(10) NULL,
PRIMARY KE' at line 8

Which has go to be the most in-decisive error messages I've ever seen in my life.

Any ideas if theres anything wrong with those commands? ANY help would be GREATLY appreciated!! Its been irritating me for the last 6 hours, and it's now 12:15am!
 

Members online

No members online now.

Latest posts

Latest profile posts

Hello, is there anybody in there? Just nod if you can hear me ...
Xie
What a long strange trip it's been. =)

Forum statistics

Threads
61,961
Messages
673,239
Members
89,014
Latest member
sanoravies