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

Loans - Apply for Credit Card - Loans - Freelance - Pontins

View Full Version : mySQL ... "show table status"... Help needed.

ready2work

Oct 15th 2007, 2:58 am

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.

jonimontana

Oct 15th 2007, 8:09 am

Give it some time, maybe its hadn't updated yet.

ready2work

Oct 17th 2007, 6:05 am

I used "commit;" along with the delete command again, and it worked.

Thanks for responding.