select count(*), substring(timeofclick,1,7) from MTracking where
mallarea=1001 group by 2;
On 5/3/06, Randy Paries <[EMAIL PROTECTED]> wrote:
Hello,
Not sure if i can do this.
I have a table with a datetime column
I would like to do group by a day of the month.
if i do something like
sel
drop the indexes for the conversion then rebuild the indexes after the
tables are converted.
On Jan 29, 2008 4:08 PM, David Schneider-Joseph <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I am attempting to convert a very large table (~23 million rows) from
> MyISAM to InnoDB. If I do it in chunks of
On Feb 11, 2008 7:27 PM, James Eaton <[EMAIL PROTECTED]> wrote:
> SELECT
> MIN(TableName) as TableName, id, col1, col2, col3, ...
> FROM (
> SELECT 'Table a' as TableName, a.id, a.col1, a.col2, a.col3, ...
> FROM a
> UNION ALL
> SELECT 'Table b' as TableName, b.id, b.col1, b.col2, b.col3, ...
On 5/7/07, Steven Buehler <[EMAIL PROTECTED]> wrote:
Thank You so much. I will have to try this later today. I have
never done a port forward in iptables before. I knew that I could, but
just
never had a need or tried so it slipped my mind about this.
The thing is...I need to
I would look at the 15th URL to see if there are specials in there that are
breaking the hash somehow.
On 5/22/07, Ben Benson <[EMAIL PROTECTED]> wrote:
I'm having problems getting a monitoring script to run.
I've put the troublesome bit in a separate script just to test, and it
goes
like
