Hi,
My table has 3 columns: id, name, timestamp.
When I use the MySQL command line client,
(a) insert into table values(1,'xxx') fails for insufficient number of
values.
(b) insert into table values(1,'xxx',null) succeeds.
1. The MySQL manual states that "The column is not specified explicitly in
an INSERT or LOAD DATA INFILE statement". So why doesn't option (a) above
work?
2. When using statement (b) from MS Access application, access claims
"Cannot update 'TimeStamp'; Field is not updateable". Turns out that I'm
unable to use any of the statements (a) or (b) from within an access
application.
So what is it that I don't understand ???
Thanks,
Osnat.
---------------------------------------------------------------------
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
