Mysql tables cannot be added stop at record 74797 - error!!

[freddie007]

I would like to know

1. why my database cannot be added beyond record 74797
is it because I have set a wrong field type for my key field???
I have set my key field as int 30



2. and also the last few data added appeared and then disappeared

3. and the last 3 data appeared in the coldfusion output,
but does not appear in the database table????

[Atli]

Hi.

I would like to know:

1. How you expect us to help debug a database we know nothing about, without providing us with any useful information, such as the table structure, an example of the data you are inserting or the error you are receiving.

2. Why, having already reached a two digit post count, you do not appear to have read the Posting Guidelines, which we require that all members follow when posting.

We do not like to guess, so if you want us to help, please provide the information we need to do so.

Thank you,
Moderator

[freddie007]

Sorry about the confusion.

There is not actual that occur or or shown any script error when adding.

I am new to MYSQL or database.

I thought the problem maybe due to the setting in MYSQL (in the administration) on the number of entry limits or table limits

or duw to the table field that I have set the key field with int 30
therefore limiting the number of entry.