Sanjoy Roy

[MCM, MCP, SCJP] – Senior PHP Programmer

MySQL Indexing Sequence


The indexing should be the same sequence in the SQL used.

SELECT `image_no` AS count FROM `images` WHERE `section`='b_cars' AND `ad_no`='300483' ORDER BY `image_no` DESC LIMIT 1 KEY `section` (`section`,`ad_no`,`order_no`,`image_no`)

WHERE
ORDER BY/GROUP BY
SELECT

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: