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, ...
FROM
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 one
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
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
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
