Hi all, I have a question: I made a table with a field that is auto_increment. This field I made to be the primary key. In my opinion an auto_increment field should fill itself, without the intervention of the user. So if I have a table like: f1,f2 --field names, where f1 is auto_increment... than in the insert sql statement I should insert only the f2 field, and mysql should fill the f1 field with the apropriate value. Or I understood wrong the auto_increment property? If so, then what should I do to obtain such a behaviour I mentioned above; if not then what I do wrong, what should I do , or how the insert statement should look?
Thank you.. best regards emil Jurj (xenon) :)) _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php