#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2000
    Location
    Hong Kong
    Posts
    73
    Rep Power
    15
    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. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2000
    Posts
    44
    Rep Power
    15
    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?
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2000
    Location
    Chicago IL, USA
    Posts
    16
    Rep Power
    0
    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.
  6. #4
  7. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    18
    CS,

    My advice: read the manual. It's available at www.mysql.com
  8. #5
  9. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2000
    Posts
    44
    Rep Power
    15
    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.

Similar Threads

  1. ok super newbie question
    By SCerviche in forum Flash Help
    Replies: 5
    Last Post: January 11th, 2004, 02:29 PM
  2. using $_session vars in a SQL query (newbie question)
    By Paul Taylor in forum PHP Development
    Replies: 2
    Last Post: September 19th, 2002, 10:26 AM
  3. newbie stupid socket question
    By lpsz in forum Python Programming
    Replies: 0
    Last Post: September 11th, 2002, 10:42 AM
  4. Replies: 2
    Last Post: August 14th, 2002, 03:33 PM
  5. Newbie coding type question...
    By raenius in forum PHP Development
    Replies: 3
    Last Post: June 9th, 2001, 03:21 AM

IMN logo majestic logo threadwatch logo seochat tools logo