Search results for query: *

Ok. Thanks r937. We're dealing with data provided by a third party that has a time stamp to millisecond precision. We normally require the data returned in some chronological form (there aren't really any other fields it would make sense to sort by). However, sometimes consecutive points in the...

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...

Thanks!! :-)

Ok. Thanks. We use MyISAM tables - from what I've read and seen they suit our requirements better. Think they're much faster for the queries we use. Don't need the row locking or foreign key functionality of InnoDB as not really appropriate. We don't have many users accessing the database. Just...

Thanks for the reply ingresman. There are three innodb files in the server's data directory: ibdata1 (10M), ib_logfile0 (5M) and ib_logfile1 (5M). It seems they are default Innodb files (according to this: http://dev.mysql.com/doc/refman/5.0/en/innodb-configuration.html ). The status variables...

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...

P.S. I forgot to say that I was using the phpmyadmin interface. I just used the command line and my squery seems to work fine. So it must be related to phpmyadmin.

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...