maybe try 'order by sort_id desc'?
On Mon, Jul 14, 2014 at 12:42 PM, Don Wieland wrote:
> I am trying to create this stored procedure, but can't understand why my
> editor is chocking on it. Little help please:
>
> DELIMITER //
> CREATE PROCEDURE `reset_sortid` (IN category INT(11))
> BEGIN
>
*read how a index works technically*
On Wed, Feb 12, 2014 at 12:48 PM, Zhigang Zhang wrote:
> I want to know the reason, in my opinion, to scan the smaller index data
> has
> better performance than to scan the whole table data.
>
>
>
>
>
> zhigang
>
>
>
> _
>
> From: Mathieu Desharnais [m
Hi Michael,
FYI: I'm using 5.6.13 and your query returns 0 for the third column with my
instance.
Cheers,
Sam
On Wed, Oct 23, 2013 at 2:35 AM, Michael Stroh wrote:
> I recently upgraded a local MySQL installation to 5.5.32 and am trying to
> figure out why the following query won't work as ex