March 6th, 2000, 11:35 AM
I am a newbie in SQL.
And here is my quetion:
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?
March 6th, 2000, 04:06 PM
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?
March 6th, 2000, 04:21 PM
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.
March 6th, 2000, 07:20 PM
March 7th, 2000, 12:53 PM
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.