difference between MySQL 5.5.3 and 5.5.4

2010-04-23 Thread Zardosht Kasheff
Hello all, What is the difference between 5.5.4 and 5.5.3? I see that 5.5.3 is available on more platforms. Is one more stable than the other? Thanks -Zardosht -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arc

Re: sql query advise

2010-04-23 Thread Norman Khine
hi martin, On Fri, Apr 23, 2010 at 9:50 PM, Martin Gainty wrote: > Norm- > I would strongly suggest locking the table before updating..a SELECT for > UPDATE would accomplish that objective: thanks for the reply and the advise on locking the table > > """SELECT oppc_id, limitedDate FROM db1.partn

MySQL Community Server 5.1.46 has been released

2010-04-23 Thread Karen Langford
Dear MySQL users, MySQL Community Server 5.1.46, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.46 is recommended for use on production systems. For an overview of what's new in MySQL 5.1, please see http://dev.mysql.com/doc/refman/5.1/en/mysq

Re: MySQL Community Server 5.1.46 has been released

2010-04-23 Thread Rob Wultsch
On Fri, Apr 23, 2010 at 10:03 AM, Karen Langford wrote: > Dear MySQL users, > > MySQL Community Server 5.1.46, a new version of the popular Open > Source Database Management System, has been released.  MySQL 5.1.46 is > recommended for use on production systems. > > For an overview of what's new i

sql query advise

2010-04-23 Thread Norman Khine
hello, i have to write a query which has to pull data from a remote mysql server, modify the table scheme, format some of the fields and then populate the new database. i am using MySQLdb which is a python interface to mysql db. how would i write a query to do this update from from a single state

MySQL Community Server 5.1.46 has been released

2010-04-23 Thread Karen Langford
Dear MySQL users, MySQL Community Server 5.1.46, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.46 is recommended for use on production systems. For an overview of what's new in MySQL 5.1, please see http://dev.mysql.com/doc/refman/5.1/en/mysq

Re: Loading 4.1.12 dump to 5.0.18 server

2010-04-23 Thread Larry Martell
On Thu, Apr 22, 2010 at 9:39 PM, Rob Wultsch wrote: > On Thu, Apr 22, 2010 at 1:42 PM, Larry Martell > wrote: >> I need to load a dump from a 4.1.12 server to a 5.0.18 server. When I >> do that it fails with: >> > Upgrading from an early 4.1 series to an incredibly early 5.0 series > is a bad id

Re: Loading 4.1.12 dump to 5.0.18 server

2010-04-23 Thread Larry Martell
On Thu, Apr 22, 2010 at 8:19 PM, Shawn Green wrote: > Larry Martell wrote: >> >> I need to load a dump from a 4.1.12 server to a 5.0.18 server. When I >> do that it fails with: >> >> ERROR 1064 (42000) at line 23: You have an error in your SQL syntax; >> check the manual that corresponds to your M

Re: Auto Increment in InnoDB

2010-04-23 Thread Johan De Meersman
It might also be done by keeping a last-revision table. Then you'd only select 1 record from that, and up the number. On Thu, Apr 22, 2010 at 5:34 PM, Chris W <4rfv...@cox.net> wrote: > Johan De Meersman wrote: > >> On Thu, Apr 22, 2010 at 1:34 PM, Carsten Pedersen > >wrote: >> >> >> >>> Wouldn