Matthias,
Tuesday, May 07, 2002, 5:36:26 PM, you wrote:
MU> is it possible to have a column which does NOT have a default value, i.e.
MU> an INSERT query should fail if no value is given..?
MU> The obvious idea, i.e.
MU> "CREATE TABLE foo (bar integer not null default null);"
MU> doesn't work.
You should compile MySQL server with -DDONT_USE_DEFAULT_FIELDS option.
Look at:
http://www.mysql.com/doc/B/u/Bugs.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ Victoria.Reznichenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
