T.ALKAHTIRI

You are right, but I am used to databases like foxpro database it prevent any entry in the auto increment field it makes it read only field. Any how I appreciate your reply thanks a lot.

Thank you very much for your reply It is true, i have searched the mysql site and It was clear that you can assign any number in the auto increment field as far as it's not duplicated. It is strange, but it is like this. Thanks again

Thank you for your reply; The problem is that you can insert any number in the auto increment field, but it should not allow any number it should be read only and managed by the engine.

I have created a table with ID as auto increment field, when i issue an insert command it auto increment the ID correct, but when I issue an insert command with value in the ID (like I have the last ID no is 10) and issue an insert command with ID 50 it takes it and it saved the record with the ID 50. As far as I know the auto increment should not allow you to put any number for inserting new record, or other wise it is not an auto increment any more. Can any one please explain to me this problem. Thank you very much for help.