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 https://forums.phpfreaks.com/topic/139982-cant-delete-all-data/ 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 https://forums.phpfreaks.com/topic/139982-cant-delete-all-data/#findComment-732369 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 https://forums.phpfreaks.com/topic/139982-cant-delete-all-data/#findComment-732375 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 https://forums.phpfreaks.com/topic/139982-cant-delete-all-data/#findComment-732376 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 https://forums.phpfreaks.com/topic/139982-cant-delete-all-data/#findComment-732509 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 https://forums.phpfreaks.com/topic/139982-cant-delete-all-data/#findComment-732606 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 https://forums.phpfreaks.com/topic/139982-cant-delete-all-data/#findComment-733105 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.