|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
|
|
#1
|
|||
|
|||
|
I am a newbie in SQL.
And here is my quetion: TINYINT(M) what does 'M' means here? The length? eg. TINYINT(2)UNSIGNED means 2 digits, numbers ranging from 0 to 99? and TINYINT(1) UNSIGNED means numbers from 0 to 9? and what command is used to delete a table? |
|
#2
|
|||
|
|||
|
same question, but more in depth. I've been using PHP/MySQL for about an hour now... and am really lost as to what each of the types in MySQL are. For some reason, my webhost does not require telnetting into the database; and I can access it all through an online panel. The problem here is, that there are only a certain amount of types available for me to use; and I don't understand the difference between them. Everytime I enter in a type, I get an error. Any thoughts?
|
|
#3
|
|||
|
|||
|
TINYINT(M) - the M refers to the length of the var
As for how to delete a table, the command is: DROP table tablename You must have DELETE privileges on the table to use this statement. Keep in mind that this can be a very dangerous command. You may wish to make a backup of the table, or rename it if you are not certain that you wish to permanently delete the table. |
|
#4
|
|||
|
|||
|
|
|
#5
|
|||
|
|||
|
Is there a specific chapter in the manual? I spent the better part of yesterday looking through it; but haven't found the needle in the haystack that I'm looking for. Just a list of types and what they do is all I need.
|
![]() |
| Viewing: Dev Shed Forums > Databases > MySQL Help > Newbie question - Datatype |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|