Re: strange behavior in mysql-server 5.1.49 and 5.1.51

2010-10-29 Thread Gregor Kling
Hello, There must have been some changes in the default interpretation respective to foreign key attributes If I add explicitly 'not null' to the columns host_id and admin_id in test_nkomp_admin, it works like intended: create table test_nkomp_admin ( host_id int unsigned not null,

invalid string bugfix for ODBC/Connector 5.1.7

2010-10-29 Thread wim . delvaux
HI all, the c/c++ ODBC/Connector 5.1.7 has a critical bug that you cannot edit the ODBC setting anymore once entered. A fix is known and committed. why does it take so long for the 5.1.8 to be released ? Surely this bug merits expedient treatment. Quid ? W -- MySQL General Mailing List For

Re: invalid string bugfix for ODBC/Connector 5.1.7

2010-10-29 Thread Johan De Meersman
*shrug* Enter the settings right the first time, or delete and recreate your connector. It'll probably get fixed, but this annoys me is not the same as this is a critical bug and the people whom I pay nothing whatsoever should jump for me. I can perfectly imagine them having more important

Re: SQL book recommendation?

2010-10-29 Thread Philip Riebold
On 28 Oct 2010, at 18:45, Paul DuBois wrote: On Oct 26, 2010, at 6:31 AM, Philip Riebold wrote: On 26 Oct 2010, at 11:49, MikeB wrote: I'm finding the MySQL online manuals hard going in figuring out how to construct SQL queries. Can anyone perhaps recommend a good book that can

Re: uninstall/reinstall

2010-10-29 Thread George Larson
We're talking about a Windows machine, right? I don't have any of those these days but it sounds to me like it didn't thoroughly uninstall. If that much is correct, I'd first be suspicious of junk left in the registry or data directories. Even if it meant I had to install it again, I'd use a