Creating sql Database table - Is this correct?

Yes, you can simplify it by doing
guid primary key

You mean where it says "Name" I should write "guid primary key" ?

One more thing. I created this table with 1 column. Does varchar 32 mean I should create the table with 32 columns?

Sorry, I'm a total noob with this :p

Thanks
 
Three things..
1) Try a number as your primary key (I know that's not in the instruction but it is generally a bad idea to use varchar for auto id)
2) You will need to add an index for the primary key.
3) You will need to make the column Auto Increase (check the A_I checkbox).
One more thing. I created this table with 1 column. Does varchar 32 mean I should create the table with 32 columns?
Absolutely not LOL. it means that there will be a column called guid which allows variable length characters having length upto 32.
 
Okay guys thank you for the replies. I was just being totally stupid. All I had to do is import the sql file I had and that was it.

Jeez. Thanks anyway :)
 
Okay guys thank you for the replies. I was just being totally stupid. All I had to do is import the sql file I had and that was it.

Jeez. Thanks anyway :)
Hahah it is not stupid, you are new to it that's it lol. Everybody had to learn one day.. and yeahh.. if you don't understand sql, just import the sql file. That will save you a lot of trouble.
 
Back
Top