SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Enthusiast Locker's Avatar
    Join Date
    May 2005
    Posts
    64
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Obtaining the 'Max_data_length' value in MySQL 4

    I want to be able to select the 'Max_data_length' value for a table. I see that in MySQL 5 you can get this from the information_schema tables, but this is a MySQL 4.1.22 database and so those aren't available.

    Anyone know how to do this?

  2. #2
    SitePoint Wizard guelphdad's Avatar
    Join Date
    Oct 2003
    Location
    St. Catharines, ON Canada
    Posts
    1,706
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Code:
    SHOW TABLE STATUS FROM databasename
    see the manual for more details.

  3. #3
    SitePoint Enthusiast Locker's Avatar
    Join Date
    May 2005
    Posts
    64
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    guelphdad, thanks for that but I was looking to be able to use SELECT so that I could run the query in PHP and use the value to make some calculations.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •