mySQL ... "show table status"... Help needed.

Discussion in 'MySQL' started by ready2work, Oct 15, 2007.

0
  1. #1
    I hv deleted 20000+ rows in a table that occupied around 104MB of space in the database. Now there are no records in it. Still the command "show table status" shows that particular table has 104MB occupied. Why?

    Help needed.
     
    If someone posts a solution, use the "Best Answer" link in their post to pick it as the best answer.
    ready2work, Oct 15, 2007 IP
  2. jonimontana

    jonimontana Well-Known Member

    Messages:
    262
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    108
    #2
    Give it some time, maybe its hadn't updated yet.
     
    jonimontana, Oct 15, 2007 Set Best Answer IP
  3. ready2work

    ready2work Guest

    Best Answers:
    0
    #3
    I used "commit;" along with the delete command again, and it worked.

    Thanks for responding.
     
    ready2work, Oct 17, 2007 Set Best Answer IP