RE: INESRT ... ON DUPLICATE KEY - rows affected incorrect?
An update - it also occurs in 4.1.19 Bug filed here: http://bugs.mysql.com/bug.php?id=19978 Cheers, Richard. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Crypt Functions
Hi Guys, Can somebody enlighten me on AES_CRYPT AES_DECRYPT functions on MySQL. I noticed that you can mention DES key file in mysqld statup options. how does the AES works? is there any one who used these functions (production systems)? Thanx in Advance, Kosala This message was sent using IMP, the Internet Messaging Program. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to find out about SSL connection?
On 21.05.2006 07:35 (+0100), paul rivers wrote: Are you certain? Which version are you running? I don't have it on MySQL 4.0 and on MySQL 5.0 it has the value 0 so I guess it's not connecting through SSL. -- Yves Goergen LonelyPixel [EMAIL PROTECTED] http://beta.unclassified.de – My web laboratory. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Looking for free MySQL Administrator
At 11:57 AM 5/20/2006, John Hicks wrote: mos wrote: At 10:10 AM 5/20/2006, Keith Roberts wrote: http://www.phpmyadmin.net/home_page/index.php I think phpmyadmin will allow you to make changes to multiple columns at once. Sorry, I should have mentioned I was looking for a MySQL Administrator running on Windows. Going through PHP seems like a round about way of accessing the database since I don't have PHP running and the database is not on the web. It's running on the local machine. I suppose I could install Apache and PHP and modify the database through a browser, but it seems a bit awkard. If it's running on your own box, why not use the 'mysql' client sql-command-line utility? A single 'alter table' query can contain multiple 'change column' and 'modify column' phrases. --J Sure, I've done that in the past for smaller tables. But it is too easy to make a mistake in defining the column definition(s) and then it's another 30 minute wait for the table to become available again. Someone mentioned SqlYog and it indeed works just fine. It's free too. :) Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Looking for free MySQL Administrator
Why am I suddenly getting huge volumes of mail about SQL? What forum is this, and how do I get out of it? ++ Phil Robbins Auckland New Zealand ++ _ Find the coolest online games @ http://xtramsn.co.nz/gaming -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to find out about SSL connection?
Why am I suddenly getting huge volumes of mail about SQL? What forum is this, and how do I get out of it? ++ Phil Robbins Auckland New Zealand ++ _ Discover fun and games at @ http://xtramsn.co.nz/kids -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Looking for free MySQL Administrator
In the last episode (May 22), Phil Robbins said: Why am I suddenly getting huge volumes of mail about SQL? What forum is this, and how do I get out of it? This is a MySQL mailing list. To unsubscribe, click on the link at the bottom of the email right after the words To unsubscribe: :) -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
innodb files
hi, I still confuse how store very large database with innodb engine in mysql. I already activate one file per table (that will creates its own file per table .idb file), but I only can store 4 records only. Do you mind if someone can tell me how to store very large database with innodb engine in mysql? - Yahoo! Messenger with Voice. PC-to-Phone calls for ridiculously low rates.