On Fri, Jun 6, 2008 at 9:25 PM, TUT - LightSpeed [EMAIL PROTECTED] wrote:
Actually they are 2 connection to 2 different databases on 2 different
hosts.
I wanted rquery results from db1 to be in a temporary table to be used in
db2.
I can go around it with some php code to create the table in
On Fri, Jun 6, 2008 at 2:28 PM, TUT - LightSpeed [EMAIL PROTECTED] wrote:
I have this problem
I connect to 2 database servers in the same script
If I create a temp table on one, won't be able on the other
$db1 = db_connect1();
$db2 = db_connect2();
I get error that temp_table doesn't
On Mon, May 12, 2008 at 11:36 AM, Jake Conk [EMAIL PROTECTED] wrote:
SELECT * FROM whiles WHERE owner_id=my_id first THEN SELECT * FROM
files ORDER by file_id
Would this work?
SELECT *
FROM whiles
WHERE owner_id = my_id
ORDER BY owner_id = my_id DESC, file_id
On 11/13/07, Hiep Nguyen [EMAIL PROTECTED] wrote:
hi there,
i have a text file that i prepare:
insert into `sa2007` (`id`,`amount`,`state`) values
('','1.00','oh'),
('','2.00','il'),
('','4.00','ks')
how do i import this file to sa2007 table from the command line? i tried
via