Popgun Posted November 27, 2010 Share Posted November 27, 2010 Cant seem to find any information on how to Limit ( e.g or put a hard cap) the number of records that can be inserted into a table. Any ideas or reference for this? Quote Link to comment https://forums.phpfreaks.com/topic/219962-setting-a-record-limit-on-a-table/ Share on other sites More sharing options...
fenway Posted November 27, 2010 Share Posted November 27, 2010 That's because there's never an need to do so. What are you trying to accomplish? Quote Link to comment https://forums.phpfreaks.com/topic/219962-setting-a-record-limit-on-a-table/#findComment-1140402 Share on other sites More sharing options...
s0c0 Posted November 27, 2010 Share Posted November 27, 2010 That's because there's never an need to do so. What are you trying to accomplish? I'm with fenway on this, why do you need to do this? For whatever reason you would want to do this, you could put this logic in your applications code. Quote Link to comment https://forums.phpfreaks.com/topic/219962-setting-a-record-limit-on-a-table/#findComment-1140407 Share on other sites More sharing options...
fenway Posted November 28, 2010 Share Posted November 28, 2010 There are some magical ways to build "queues" into a MySQL table, but I doubt you really want them. Quote Link to comment https://forums.phpfreaks.com/topic/219962-setting-a-record-limit-on-a-table/#findComment-1140460 Share on other sites More sharing options...
Popgun Posted November 28, 2010 Author Share Posted November 28, 2010 Yeah I was wanting to put a hard cap of records (containing users) of 100 by account type. I guess its best done programmatically Quote Link to comment https://forums.phpfreaks.com/topic/219962-setting-a-record-limit-on-a-table/#findComment-1140643 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.