facing problem with is null in stored procedure

delimiter // create procedure sample1(in p_item varchar(30), in p_size varchar(6), in p_quantity decimal(10,3), in p_unit varchar(3), in p_autoincrement varchar(30), out v_mess varchar(50) ) begin declare done int default 0; declare v_bhqty decimal(10,3); declare v_bhunit

Complex group/join query

I'm trying to create a rather (what I consider to be) complex analysis query. It should use data from three tables that contain measurements and write the results back to a fourth table. There are three measurement tables: metrica, metricb, and metricc.  There's one table which contains a

Partitioning suggestion/workaround needed

Hi all, I'm just creating my first partitioned table and have run into a bit of a snag. The table primary key is a double and I want to create partitions based on ranges of the key. I have read the Partition Limitations section in the docs which states that the partition key must be, or resolve

Re: success return from mysql_query() when error return was expected

On Wed, 8 Apr 2009, Pete Wilson wrote: Hi everyone -- I'm a MySQL noob. I have MySQL queries in my C code and I was surprised to find I'm getting a success return from: mysql_query(pmysql, select * from usrs where(usr=\illegal name\); In this table called usrs, usr is the primary key and

displaying a specific row within a group by

Consider the ff. table: ++--+--+ | game | rank | date | ++--+--+ | GTA| 11 | 20081001 | ++--+--+ | SPORE | 1 | 20081103 | ++--+--+ | SPORE | 2 | 20091001 | ++--+--+ | SINSOL |

Re: displaying a specific row within a group by

Andy I want a single SQL query that will return the latest ranking for each game: See Within-group aggregates at http://www.artfulsoftware.com/infotree/queries.php. PB - Andy Sy wrote: Consider the ff. table: ++--+--+ | game | rank | date |

Re: displaying a specific row within a group by

Also: http://jan.kneschke.de/projects/mysql/groupwise-max On Thu, Apr 9, 2009 at 8:46 PM, Peter Brawley peter.braw...@earthlink.net wrote: Andy I want a single SQL query that will return the latest ranking for each game: See Within-group aggregates at

S L O W query over internet

We are running a remote service and have an application that queries a mysql database over the public internet. The ping test shows 60ms but the queries take 40 seconds to 2 minutes to run at times. When we run the same query using a local machine with 2ms it runs fast. I have searched the

db is bring dropped, binlog help

Hi folks, We're experiencing a really bizarre thing. One of our mysql 5.0 databases is mysteriously and constantly being dropped. This is a cap from our binlog: #090409 15:09:13 server id 1 end_log_pos 326997 Query thread_id=9923 exec_time=1 error_code=0 SET

Re: db is bring dropped, binlog help

Hi John, I would almost certainly suspect some form of foul play, whether that be internal (i.e. an employee/colleague) or network intrusion. As you've figured the first thing to do is check which MySQL account is dropping the database. You already have the timestamp in your binlog so what

Re: db is bring dropped, binlog help

Andy, Thanks a ton for the quick feedback. I will turn on query logging and give it a go! Thanks, John On Thu, Apr 9, 2009 at 6:16 PM, Andy Shellam andy-li...@networkmail.eu wrote: Hi John, I would almost certainly suspect some form of foul play, whether that be internal (i.e. an