Creating sql Database table - Is this correct?

Scorpion Ghost

Elite Member

Executive VIP

Jr. VIP

Mar 22, 2013

9,167

10,465

• Nov 3, 2018

• #1

I created a sql database/table, but I'm unsure if I did it correctly.

Instructions:

What I did:

Is that right?

 

O

OrionX

BANNED

Oct 19, 2018

88

14

• Nov 3, 2018

• #2

Yes, you can simplify it by doing
guid primary key

 

Scorpion Ghost

Elite Member

Executive VIP

Jr. VIP

Mar 22, 2013

9,167

10,465

• Nov 3, 2018
• Thread Starter Thread Starter

• #3

OrionX said:

Yes, you can simplify it by doing
guid primary key

Click to expand...

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

Thanks

 

Gogol

Administrator

Staff member

Moderator

Executive VIP

Jr. VIP

Sep 10, 2010

11,850

26,347

• Nov 3, 2018

• #4

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).

Scorpion Ghost said:

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

Click to expand...

Absolutely not LOL. it means that there will be a column called guid which allows variable length characters having length upto 32.

 

Scorpion Ghost

Elite Member

Executive VIP

Jr. VIP

Mar 22, 2013

9,167

10,465

• Nov 3, 2018
• Thread Starter Thread Starter

• #5

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

 

TasDePixels

BANNED

Mar 8, 2018

312

435

• Nov 3, 2018

• #6

After 2 years of noSQL, this shit feels icky.
MongoDB FTW. <3

 

Gogol

Administrator

Staff member

Moderator

Executive VIP

Jr. VIP

Sep 10, 2010

11,850

26,347

• Nov 3, 2018

• #7

Scorpion Ghost said:

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

Click to expand...

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.