RE: [MySQL] Re: Variables in stored procedures

> -Original Message- > From: Shawn Green [mailto:shawn.l.gr...@oracle.com] > Sent: Friday, April 30, 2010 9:49 PM > To: Ashley M. Kirchner > Cc: mysql@lists.mysql.com > Subject: [MySQL] Re: Variables in stored procedures > > Two options > > 1) use the placeholder, a question mark

Re: Best index for searching on lat / long data i.e. decimal vs. float

On Fri, 30 Apr 2010 17:14:06 -0500, mos wrote: > At 04:54 PM 4/30/2010, you wrote: > > Use Explain in front of your Select statement to see how many indexes it is mysql> explain SELECT * FROM `grid` WHERE n > 49.012 AND s < 49.012 AND e > 110.0244 AND w < 110.0244; ++-+-

Re: Variables in stored procedures

Ashley M. Kirchner wrote: I have the following procedure: -- CREATE PROCEDURE `geodistance`(IN userid int, IN maxdist int) begin declare userlng double; declare userlat double; declare lng1 float; declare lng2 float; declare lat1 float; declare lat2 float; select ln

Variables in stored procedures

I have the following procedure: -- CREATE PROCEDURE `geodistance`(IN userid int, IN maxdist int) begin declare userlng double; declare userlat double; declare lng1 float; declare lng2 float; declare lat1 float; declare lat2 float; select lng, lat into userlng, userla

Re: Best index for searching on lat / long data i.e. decimal vs. float

At 04:54 PM 4/30/2010, you wrote: I have a table with over 8 million rows of lat / long data all currently in decimal(12,8) format (actually some in float(12,8)). First question - should I have these all in decimal or float? I can't think of any reason why I would actually do any math via mysq

Best index for searching on lat / long data i.e. decimal vs. float

I have a table with over 8 million rows of lat / long data all currently in decimal(12,8) format (actually some in float(12,8)). First question - should I have these all in decimal or float? I can't think of any reason why I would actually do any math via mysql with this data. I am just ru

Theoretical question about innodb autoincrements and binlog mode

Hey you all, I'm messing about with various settings and parsing the documentation, and my naughty mind saw something that's not very clear in the docs: The InnoDB autoincrement docstates that innodb_autoinc_lock_mode = 2