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 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 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? 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 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? 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 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.... Link to comment https://forums.phpfreaks.com/topic/139982-cant-delete-all-data/#findComment-733105 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.