Results 1 to 8 of 8
  1. #1
    Join Date
    Oct 2002
    Location
    London U.K.
    Posts
    72

    Unhappy newbie missing the obiovious again

    Error

    SQL-query*:*

    CREATE TABLE `test` (
    `age` VARCHAR UNSIGNED DEFAULT '21' NOT NULL ,
    `sex` VARCHAR UNSIGNED DEFAULT 'f' NOT NULL ,
    `location` VARCHAR UNSIGNED DEFAULT 'lon' NOT NULL
    )



    MySQL said:



    You have an error in your SQL syntax near 'UNSIGNED DEFAULT '21' NOT NULL, `sex` VARCHAR UNSIGNED DEFAULT 'f' NOT NULL, `lo' at line 1

    Back


    And this means?????


    phpMyAdmin 2.3.2
    MySQL 3.23.52-max-log running on localhost as [email protected]


    Basically it is my first attemp at making a table

    I have tried to find a step by step guide on line that make sence

    but I can't so please point me to the right URL or forum

    Quincy
    p.s. some yummie new recipies on
    http://qnctv.com/delindex.htm

    qnctv.com
    getting there... slowly


  2. #2
    Join Date
    Jun 2002
    Posts
    1,874
    CREATE TABLE test
    (age VARCHAR(25) NOT NULL,
    sex VARCHAR(25) NOT NULL,
    location VARCHAR(50) NOT NULL);

    Remember the ";"

  3. #3
    Join Date
    Oct 2002
    Location
    London U.K.
    Posts
    72
    my fist table
    ahhhhhh

    i put the 25 and 50 and the , and ;in the default box

    I got

    http://qnctv.com/fazel3/faz.jpg

    how do I put values in

    Is there a step by step dummies guide on line somewhere?

    Quincy

  4. #4
    Join Date
    Jun 2002
    Posts
    1,874
    Hi Quincy,

    Try this link, since you want to have hands on experience with this stuff, i'm sure you'll appreciate the link more than me giving you a rather intimidating, techno-talk explaination of how to create tables in SQL

    http://www.newbienetwork.net/content.php?id=10

    There's a step-by-step, screenshot laden method there

    Edit: Starts around about halfway through, where there's that handwritten scanned pic.

  5. #5
    Join Date
    Oct 2002
    Location
    London U.K.
    Posts
    72
    Faz your a star!!!

  6. #6
    Join Date
    Jun 2002
    Posts
    1,874
    glad someone thinks so

  7. #7
    Join Date
    Oct 2002
    Location
    London U.K.
    Posts
    72
    ok now how do i putr stuff in the table

    how do I tie a form to a table?


  8. #8
    Join Date
    Nov 2001
    Posts
    857
    <?
    header("Location: http://www.hostevolve.com/");
    ?>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •