On 10 Jul 2009, at 03:44, sangprabv wrote:
SELECT count(sql_id) AS total, DATE_FORMAT(insertdate, '%H:%i' ) AS
mydate FROM momt WHERE 1=1 AND insertdate BETWEEN DATE_ADD(NOW(),
INTERVAL - 1 HOUR) AND NOW() AND (sms_type = 1 OR sms_type =2) GROUP
BY
mydate ORDER BY insertdate
Firstly do an
I have been using the Linux version of MySQL for five years, also used it on
a Windows ME system even though documents said you couldn't. Recent a friend
asked me to help him get it up and running on a Windows Vista system.
I was looking for the system configuration requirements but could not
At 11:08 AM 7/10/2009, russbucket wrote:
I have been using the Linux version of MySQL for five years, also used it on
a Windows ME system even though documents said you couldn't. Recent a friend
asked me to help him get it up and running on a Windows Vista system.
I was looking for the system
On 10 Jul 2009, at 17:18, mos wrote:
Is there a Windows application that works like
phpMyAdmin? I tried MySQLAdmin on my Linux system, but I could not
cut and
paste SQL Commands into the editor.
You could run php (and thus phpmyadmin) on windows - in contrast with
earlier versions, 5.3
Chris;
From my understanding of your question, your message (included
below in its entirety) is better sent to the MySQL General list, which
I've CC'd on this reply. If you haven't yet, please subscribe there
at mysql-subscr...@lists.mysql.com to follow the thread for responses.
If
This is more of an application architecture question than a mysql question.
Though I'll offer my two cents:
What are you going to do with the XML file? Write it to disk, so you can later
read it, and parse it just to get your result set back? That sounds a lot
slower than fetching it from
-Original Message-
From: russbucket [mailto:russbuc...@nwi.net]
Sent: Friday, July 10, 2009 11:09 AM
To: mysql@lists.mysql.com
Subject: MySQL Windows version
I have been using the Linux version of MySQL for five years, also used
it on
a Windows ME system even though documents
Here is steps take to get to the problem. Version is 5.1.35
To be on the safe side, I did this prior to executing the scripts. I deleted
the mysql directory and the mysql-log directory, recreated them, chowned them,
ran mysql_install_db, chowned them again. So, I know at least I'm working
One quick follow up note:
In the top of the big script, I'm doing:
CREATE DATABASE x;
CREATE TABLE x.whatever (...);
Reading into the various bug reports, do I need to issue a USE x; ? I'm
assuming that MySql isn't picking up the replica because there is no current
database specified, even
-Original Message-
From: Gary Smith
Sent: Friday, July 10, 2009 5:26 PM
To: Gary Smith; mysql@lists.mysql.com
Subject: RE: Crazy replication problem
One quick follow up note:
In the top of the big script, I'm doing:
CREATE DATABASE x;
CREATE TABLE x.whatever (...);
After getting table replication to work by including the USE database on the
creation scripts, I have run into a rather large problem. We have 5 databases
on the server which get replicated to another server. We call them databases,
A, B, C, D, and E. we have two other databases F and G
11 matches
Mail list logo