hassank1 Posted January 8, 2009 Share Posted January 8, 2009 I've a table "numbers" that contains > 18000 row the issue is that when I try to delete : "delete from numbers" . only about 1000 rows are deleted then when I do the query again 300 rows are deleted .. and each time a random number is deleted !!! I don't know why ! why that's happening ? Note : I tried to use limit but also same result Quote Link to comment Share on other sites More sharing options...
hassank1 Posted January 8, 2009 Author Share Posted January 8, 2009 MySQL version : 5.0.51b PHPMyAdmin :2.11.6 Quote Link to comment Share on other sites More sharing options...
GingerRobot Posted January 8, 2009 Share Posted January 8, 2009 If you're trying to delete all data, then try using TRUNCATE: TRUNCATE TABLE numbers Otherwise, can we see the relevant code? Quote Link to comment Share on other sites More sharing options...
hassank1 Posted January 8, 2009 Author Share Posted January 8, 2009 yup but sometimes I want to delete data with some condition .. if the data results are big I still got the same problem Quote Link to comment Share on other sites More sharing options...
fenway Posted January 8, 2009 Share Posted January 8, 2009 yup but sometimes I want to delete data with some condition .. if the data results are big I still got the same problem That's a very unusual problem indeed... is this occuring from phymyadim? Quote Link to comment Share on other sites More sharing options...
hassank1 Posted January 8, 2009 Author Share Posted January 8, 2009 yes from phpmyadmin... I will try to use php to delete and I will check if problem persist Quote Link to comment Share on other sites More sharing options...
fenway Posted January 9, 2009 Share Posted January 9, 2009 yes from phpmyadmin... I will try to use php to delete and I will check if problem persist I think I've heard about a maximum row limit for select/updates from that app somewhere.... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.