Hi all,
I was wondering is it possible to use SHOW COLUMNS FROM tbl_name as a
subquery.
I tried something like this ( w/o success ):
SELECT * FROM tbl1 INNER JOIN (SHOW COLUMNS FROM tbl2) AS t2 WHERE t1.ID
=t2.field;
or
SELECT field FROM (show columns from Research.idefix);
Teemu
--
Hi,
Unfortunately, nobody responded my mail. I am still trying to solve the
problem I described in my earlier mail (quoted below).
I am mailing again because I have some new information about the issue.
I converted all my tables to InnoDB (MyISAM - InnoDB) and this solved
the problem. With
://www.mysql.com/support/index.html
...
Subject: Re: MySQL does not release locks
From: Teemu Kuulasmaa
Date: Thu, 04 Sep 2003 14:54:56 +0300
Hi,
Unfortunately, nobody responded my mail. I am still trying to solve the
problem I described in my earlier mail (quoted below).
I am mailing again
Hi
I have problems with mysql (4.0.6-4.0.14b) on windows 2000 SP3. MySQL
locks tables when I alter table structure or execute update queries. I
know that this is the exactly what database engine is supposed to do but
the engine doesn't release the locks at all. This happens frequently but
not
normal user needs in order to change his/her own
password?
Teemu Kuulasmaa
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request