On May 21, 2010, at 6:31 PM, Bob Sneidar wrote:
I'm wondering if the Relational aspect of Trevor's sqlYoga would be
able to do this, but again, I think I have to be working with two
tables in the same database for that to work. Trevor?
That is correct. SQL Yoga will only work with relations
Which is why if I pull this off, there are people who may be interested in it.
Bob
On May 25, 2010, at 10:19 AM, Mark Wieder wrote:
> I think the only way around this is to issue two SQL
> commands, one to MySQL, one to SQLite, then take the recordsets and
> mangle them yourself, pretending th
Bob-
Monday, May 24, 2010, 9:00:59 PM, you wrote:
> I am not a MySQL expert but I have found that it is possible to
> join different databases, each with various tables.
Bob S.'s main issue here is that he's trying to join two different
*types* of databases, a MySQL database and a SQLite databa
QLcommand
> put revDataFromQuery(tab, return, tConId, tSQLcommand) into tItems
>
> I did not find it necessary to give the databases alias names.
> In my situation, both databases are on the same machine and can be accessed
> using the same username/password.
> Hope this helps.
>
ems
I did not find it necessary to give the databases alias names.
In my situation, both databases are on the same machine and can be accessed
using the same username/password.
Hope this helps.
Bob
Date: Sun, 23 May 2010 18:19:24 -0300, From: Andre Garzia
Subject: Re: Remote SQL databases
I
Hi Mark and all interested parties.
Perhaps I failed to mention that the two databases do not know about each
other. The SQL server doing the join has no access to the file based SQLite
database it is doing a join against. I am pretty sure this is impossible to do
like this.
It's okay though
Gotcha. Teaches me to take my web guy's word for it. :-)
Bob
On May 21, 2010, at 5:04 PM, Mark Stuart wrote:
> Hi Bob,
> on Fri May 21 17:31:53 CDT 2010, Bob Sneidar wrote:
>>>
> So now I have to think about using joins.
> <<
> Just preface the table name that's in the other database with the
I did it on my 6k thousand table database...
It works fine for us.
I have something like
select Database1.* from DatabaseName1.Table1 as Database1,
DatabaseName2.Table2 ...
On Sun, May 23, 2010 at 4:34 PM, Mark Wieder wrote:
> Bob-
>
> Sunday, May 23, 2010, 12:04:03 PM, you wrote:
>
> > Oh he
Bob-
Sunday, May 23, 2010, 12:04:03 PM, you wrote:
> Oh hello! You are saying you CAN do a join on a table that is not in
> the same database?
Well, I haven't tried it, bu Mark S. implied that it was possible with
two different aliases...
--
-Mark Wieder
mwie...@ahsoftware.net
__
Oh hello! You are saying you CAN do a join on a table that is not in
the same database?
Bob Sneidar
IT Manager
Calvary Chapel CM
Sent from iPhone
On May 22, 2010, at 18:35, Mark Wieder wrote:
Mark-
Friday, May 21, 2010, 5:04:57 PM, you wrote:
SELECT cus.Customer_Number, cus.Customer_Name,
Mark-
Friday, May 21, 2010, 5:04:57 PM, you wrote:
> SELECT cus.Customer_Number, cus.Customer_Name, ctyp.Customer_Type_Name
> FROM database1.customers AS cus LEFT OUTER JOIN
> database2.customer_types as ctyp ON cus.Customer_Type =
> ctyp.Customer_Type_ID
Nice one - someone actually found a use
Hi Bob,
on Fri May 21 17:31:53 CDT 2010, Bob Sneidar wrote:
>>
So now I have to think about using joins.
<<
Just preface the table name that's in the other database with the
database_alias_name.table_name:
SELECT cus.Customer_Number, cus.Customer_Name, ctyp.Customer_Type_Name
FROM database1.custo
Hi all.
Anyone have any idea how fast the queries to the On-Rev SQL databases are on
average? I was using a method where I was looking up a key from one query of
100 records at a time and querying a mySql database at my On-Rev site ONE
RECORD AT A TIME! I discovered that the queries were takin
13 matches
Mail list logo