mySQL + Unix

Discussion in 'Web Design & Coding' started by farseeker, Oct 2, 2002.

  1. farseeker

    farseeker Guest

    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!
     
  2. farseeker

    farseeker Guest

    Heh its ok, I found out I missed a "not". Thanks for all the help, guys...