Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

whats wrong with my create table code??

codecraigcodecraig Member Posts: 163
whats wrong with this?

[code]
CREATE TABLE people{username VARCHAR( 10 ) NOT NULL ,
thePass VARCHAR( 10 ) NOT NULL ,
fname VARCHAR( 20 ) ,
lname VARCHAR( 20 ) ,
age INT,
town VARCHAR( 20 ) ,
state VARCHAR( 2 ) ,
zip INT,
area INT,
class VARCHAR( 10 ) ,
sex VARCHAR( 1 ) ,
info VARCHAR( 200 ) ,
PRIMARY KEY ( username ) }
[/code]
[size=5][italic][blue]Code[/blue][black]:[/black][red]Craig[/red][/italic][/size]

Comments

  • JonathanJonathan Member Posts: 2,914
    : whats wrong with this?
    Besides the sex field not containing enough spaces to fit "yes please" in it...

    : [code]
    : CREATE TABLE people [red]{ should be a ( not a {[/red]
    : username VARCHAR( 10 ) NOT NULL ,
    : thePass VARCHAR( 10 ) NOT NULL ,
    : fname VARCHAR( 20 ) ,
    : lname VARCHAR( 20 ) ,
    : age INT,
    : town VARCHAR( 20 ) ,
    : state VARCHAR( 2 ) ,
    : zip INT,
    : area INT,
    : class VARCHAR( 10 ) ,
    : sex VARCHAR( 1 ) ,
    : info VARCHAR( 200 ) [red], don't think this comma should be here[/red]
    : PRIMARY KEY ( username )
    : [red]} should be a ) not a }[/red]
    : [/code]

    Jonathan

    ###
    for(74,117,115,116){$::a.=chr};(($_.='qwertyui')&&
    (tr/yuiqwert/her anot/))for($::b);for($::c){$_.=$^X;
    /(p.{2}l)/;$_=$1}$::b=~/(..)$/;print("$::a$::b $::c hack$1.");

Sign In or Register to comment.