Can I set a default value to a function?

2003-01-27 Thread Carlin Anderson
I am running mysql 3.23, and want to know if I can set the default value of a column to to_days(now()), or the equivelant. I have tried this, and the default gets translated to 0. Thanks Carlin - Before posting, please check:

Server Down - Need Help

2003-01-26 Thread Carlin Anderson
Hello all: I have a production server that is currently down and am looking for help. WIN2k Server, mysql 3.23 The background is this - I was creating an index, and someone decided to reboot the system. When the system came back up, mysql would not start. When we looked at the service, it

reset auto-increment value

2002-12-29 Thread Carlin Anderson
I have a number of databases installed under mysql 3.23 and 4.0, and will need to occasionally re-initialize certain tables. Can I re-set auto-increment fields within those tables? Thanks Carlin Anderson - Before posting

Re: access-mysql

2002-12-05 Thread Carlin Anderson
I can concur - you pay a little, but you get a much better product with this one. Ian Zabel wrote: The only one I found that creates a good schema that only needs minimal massages, and imports all the data correctly is Access-To-MySQL. It's not free though, but they have a trial. Once I went