Question on http query

Hi, I'd like to know if MySQL server supports http queries? Thanks. Kandy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

slow query on replication master and slave

Hi, Is it true that the performance of running a query on a live replication master and slave has to be much slower than running a query on a static server? I've tried to run the following query on a replication master and it takes 1 min 13.76 sec to finish. SELECT *, ABS(timeA-1266143632) a

Question on replication

Hi, Is there a replication setup method just to replicate a specific database not all the databases or exclude a specific database not to be replicated? Thank you. Kandy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[E

C++ cache MYSQL_RES

Hi, Is there a way to cache the MYSQL_RES in C++? I've tried to develop a class with functions returning the MYSQL_RES, MYSQL_ROW and MYSQL_FIELDS. The functions work fine within the class file. But if I call the functions where else, I'll either get 'Segmentation fault' or 'bus error'. Any i

Re: Need help to query with timestamp in C++

le1 t > WHERE timestamp_column <= '20080815091907' > ORDER BY timestamp_column DESC LIMIT 1 > ) > UNION > (SELECT TIMEDIFF(timestamp_column, '20080815091907') AS diff, t.* FROM > table1 t > WHERE timestamp_column >= '20080815091907' > OR

Re: Need help to query with timestamp in C++

so if that is what you are > seeking for, I can help with PHP. > > Saul > > Kandy Wong wrote: >> Hi, >> >> I need to write a C++ program in a Linux environment to query with a >> timestamp. >> The user will only provide with an approximate time so I'

Need help to query with timestamp in C++

Hi, I need to write a C++ program in a Linux environment to query with a timestamp. The user will only provide with an approximate time so I'd like to know how can I write a program or a query to return the closest data. The followings are the timestamp in the MySQL database: | 2008-08-05 03:56:0