Exciting news!
The next issue of Open Source Database Magazine (http://www.osdbzine.net) is
now available. This information-packed issue has over 60 pages of
information including:
* Firebird’s Road Trip and What’s New with 2.5
* Coding Corner: Trees – Where’s the Performance?
* PostgreSQL’s tsve
The FEDERATED engine is what you're looking for, but it probably doesn't
quite do what you expect. Full documentation is at
http://dev.mysql.com/doc/refman/5.0/en/federated-storage-engine.html .
The major gotcha - in my opinion - is that it doesn't actually use indices.
If you only need to run sel
Have you considered Reading The *Fine* Manual at
http://dev.mysql.com/doc/#manual ?
On Sat, Dec 5, 2009 at 4:59 PM, Victor Subervi wrote:
> Hi;
> I remember vaguely how to do this but don't know how to google it:
>
> show tables like categories$;
>
> such that it will return tables such as:
>
>
At 12:16 PM -0600 12/7/09, Bryan Cantwell wrote:
Does anyone have a suggestion on how a database link (like in
Oracle) could be established between two Mysql databases on
different servers?
It would be awesome if I could write sql that will query both
databases in one query...
You are probab
Does anyone have a suggestion on how a database link (like in Oracle)
could be established between two Mysql databases on different servers?
It would be awesome if I could write sql that will query both databases
in one query...
--
MySQL General Mailing List
For list archives: http://lists.mys
On Mon, Dec 7, 2009 at 8:08 AM, Tom Worster wrote:
> On 12/7/09 5:26 AM, "Victor Subervi" wrote:
>
> > Hi;
> > I posted this Saturday. Perhaps it's too challenging for those who read
> it
> > to answer. I hope someone can.
> >
> > I need to write a select statement that enables me to select colu
On 12/7/09 5:26 AM, "Victor Subervi" wrote:
> Hi;
> I posted this Saturday. Perhaps it's too challenging for those who read it
> to answer. I hope someone can.
>
> I need to write a select statement that enables me to select column 'ID'
> from a table where a certain value is found in an enum of
Hi;
I posted this Saturday. Perhaps it's too challenging for those who read it
to answer. I hope someone can.
I need to write a select statement that enables me to select column 'ID'
from a table where a certain value is found in an enum of a specific column.
For example...
select column_type fro
On Sun, Dec 6, 2009 at 2:42 PM, Steve Edberg wrote:
> At 1:26 PM -0500 12/6/09, Victor Subervi wrote:
>
>> Hi;
>> I have the following:
>>
>> mysql> select * from categoriesProducts as c inner join
>> relationshipProducts
>> as r on c.ID = r.Child inner join categoriesProducts as p on r.Parent =
>
