Perl & MySQL

2006-02-18 Thread Mike Blezien
Hello, MySQL version: 4.1.10a we are getting this error when attempting to connect to our MySQL database: install_driver(mysql) failed: Can't load '/usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.10: cannot open shared

Re: Perl & MySQL

2006-02-18 Thread Pooly
2006/2/18, Mike Blezien <[EMAIL PROTECTED]>: > Hello, > > MySQL version: 4.1.10a > > we are getting this error when attempting to connect to our MySQL database: > > install_driver(mysql) failed: Can't load > '/usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/auto/DBD/mysql/mysql.so' > for mo

Re: describe table : improvement ?

2006-02-18 Thread Gabriel PREDA
U can use instead of *DESCRIBE a_table* ** Another syntax: *show [full] columns from `a_table`* Without FULL it will act like *DESCRIBE a_table *but with FULL option you will get the comments on the column... and also another beautiful column witch will show you the privileges you have for each co

Re: Bulk conversion of 3.23 latin1 to 4.1 utf-8

2006-02-18 Thread David Spidley
> -Original Message- > From: [EMAIL PROTECTED] > Sent: Sat, 18 Feb 2006 00:12:19 +0100 > To: [EMAIL PROTECTED] > Subject: Re: Bulk conversion of 3.23 latin1 to 4.1 utf-8 > > On 17.02.2006 15:34 (+0100), David Spidley wrote: >> What is the official way to take this latin1 3.23 dump and load

Re: showing zero counts in select statements with group by

2006-02-18 Thread Peter Brawley
Sorry, two errors, should be ... ...) OR m.repyear IS NULL GROUP BY c.year PB - Chris Fonnesbeck wrote: On 2/17/06, Peter Brawley <[EMAIL PROTECTED]> wrote: Chris, Your WHERE clause is weeding out the NULL joined entries. Try something like... select m.repyear as repyear,