Sam,
You can use 'show tables' with a like clause if you prefix your temporary
tables with a string such as 'tmp_'. See the manual for syntax:
http://dev.mysql.com/doc/mysql/en/show-tables.html
Clint
From: sam wun [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: show temporary table
Date:
Sam,
Remove the double quotes and semi-colon out of this statement:
$tmp_sql = qq{alter table tmp_pastsales add
index(salescode,basename,prodcode)};
Clint
From: sam wun [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: create indexes for temporary table
Date: Sun, 23 Jan 2005 18:49:51 +0800
Steve,
Below is output from the mysql_fix_privilege_tables script:
You can safely ignore all 'Duplicate column' and 'Unknown column' errors
because these just mean that your tables are already up to date.
I would not worry about the Duplicate Key error, because that is likely
the same case as
Sam,
Can you send the output of the following:
#explain your query\G
Clint
From: sam wun [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: sub query is extermely slow
Date: Wed, 19 Jan 2005 20:02:37 +0800
Hi list,
The following sql statement takes 3 mintues to complete the query. How can
I
'%buffer%';:
Clint
From: sam wun [EMAIL PROTECTED]
To: Clint Edwards [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Subject: Re: sub query is extermely slow
Date: Wed, 19 Jan 2005 20:39:41 +0800
Clint Edwards wrote:
Sam,
Can you send the output of the following:
#explain your query\G
Thanks
]
To: Clint Edwards [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Subject: Re: sub query is extermely slow
Date: Wed, 19 Jan 2005 22:05:58 +0800
Clint Edwards wrote:
Sam,
Can you send the following information:
When was the last time 'analyze table table_name' (inventory,
transaction, customer
The postmaster is a Postgres daemon, and pg_shadow is the user table for
postgres.
Clint
From: Michael Stassen [EMAIL PROTECTED]
To: Alex Majora [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Subject: Re: mysql.sock file exists, but still cannot connect to server
Date: Wed, 19 Jan 2005 17:42:34
Andre,
I would recommend a table for recovering id's that are lost due to rollback.
Before you actually rollback, take the generated ID and push it into this
table. Then change the way you acquire id's on insert. You will want to
check to see if this table has an ID before you auto_increment