[Unknown123]

When i create a database 'phpMyAdmin'.. Then i have to type in some info... Like this:

Field:----------Type:----------Length/Values:
Username------VARCHAR-------24
AdminLevel-----INT------------1
Then so on...

Then my question is:

• How do i know the the "Type"?
• How do i know the the "Length/Values"?

Can someone explain me?

[vital2k]

The type is the values you expect to put in. Varchar is any type of character and INT is integer also known as a number. The length/values is the maximum length you expect the data to be input.

http://help.scibit.com/mascon/mascon...eld_Types.html

[Unknown123]

Quote:

Originally Posted by vital2k The type is the values you expect to put in. Varchar is any type of character and INT is integer also known as a number. The length/values is the maximum length you expect the data to be input. http://help.scibit.com/mascon/mascon...eld_Types.html

So if i want to add "Warning"... Thn it should be like this?
Field:----------Type:----------Length/Values:
Warning--------INT------------1

Why did i use "INT"? Because it is an integer.
Why did i use "1"? Yes, why did i use "1"? LoL

Please correct me :P
English isnt my main language and my english isnt good so it is harder sor me to understand xD

[CJ101]

Yes, however depending on how big your int is you should look into using TINYINT, SMALLINT or MEDIUMINT

[Unknown123]

Thanks