i am using mysql and when i use
delete from table...
or even use phpmyadmin when i give delete command i have noticed that the data physially dont get deleted..rather it indicates it as deleted..i could find physical data in files
so how to permanantly delete records from table..(freeing space and user)
another is suppose user_id field is autoincrement field,there are 10 data
and i later deleted the user_id 1
then can i re arrange table ...not making that user_id 1 free
may be suffle one step ahead all
or give that user_id to new user..
how can it be done..
thanks
mysql delete query
Moderator: General Moderators