hi, i need to know if there is an easy way to 'rename' de serial key of some entries.. the case is:
a chat in php running with everything (including the talk) stored in database (mysql)..
i want to store only 50 lines at a time:
bill says: auauau
yduJ says: hi humans
serial key | who | says
1 | 17 | 'auauau'
2 | 89 | 'hi humans'
the problem is it's a chat.. people talks a lot and i need to know how many lines that serial key (big int) can store without explode.. as mysql only reuse the deleted keys if there is no key higher, maybe i can 'rename' that big keys to 1, 2..
Note: i will delete the older entries, and store only 50 newer msgs.
thanks.
a chat in php running with everything (including the talk) stored in database (mysql)..
i want to store only 50 lines at a time:
bill says: auauau
yduJ says: hi humans
serial key | who | says
1 | 17 | 'auauau'
2 | 89 | 'hi humans'
the problem is it's a chat.. people talks a lot and i need to know how many lines that serial key (big int) can store without explode.. as mysql only reuse the deleted keys if there is no key higher, maybe i can 'rename' that big keys to 1, 2..
Note: i will delete the older entries, and store only 50 newer msgs.
thanks.