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.
Exactly. Pass a null value to the auto_increment field, and it will kick off.
INSERT INTO tablename (f2) VALUES (xyz);
will automatically create values for f1.
or
INSERT INTO tablename (f1, f2) VALUES (NULL, xyz);
will have the same effect. The difference is that in the first
example the null value is implicit, while in the second one it is explicit.
Bye
Giuseppe Maxia
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) :))
-
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