Avoiding deadlock: beyond the basics

I've been getting the following error in my Python program which accesses InnoDB tables: OperationalError: 1213 Deadlock found when trying to get lock; try restarting transaction I've already tried all the basic steps that the documentation seems to recommend: - Set my TRANSACTION ISOLATIO

Re: MySQL Group By partial string

On Apr 27, 2005, at 1:17 PM, Eric Jensen wrote: Trying to make some queries a little more efficient. I want to group HTTP referers together but not with the full URL. For example, just "www.google.com" instead of the full search string. I can't find a way to do this in MySQL. Is there a way t