Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
ORDER BY Clause and Identical Values
Hi, I have quick question regarding behaviour of ORDER BY clause in SELECT statement. If I choose to order by a particular field, and there are several rows with same value for that field how are they ordered? Do they appear as in their relative order for the result set without the order by... -
Using MyISAM - Have InnoDB reads etc.
Hi, I have a database server full of MyISAM tables but I did not set the skip-innodb option. Accordingly the InnoDB storage engine system variables are set to their defaults. Looking at the system status variables, I see that: Innodb_buffer_pool_pages_data = 19... -
Have Column with IF statement in a subquery - how to select?
Hi, I'm trying to construct a query that checks if two (or more) consecutive values for a field are the same, then I only select the first one. I found this suggestion: http://www.artfulsoftware.com/infotree/queries.php?&bw=1259#798 This constructs a table using: create table t ( p...
