How about
CREATE TEMPORARY TABLE tempbills SELECT billdesc, bpamount FROM bill_pay
Thanks,
James
NEBIS Tech.
http://www.nebis.com
-----Original Message-----
From: Matt Bailey [mailto:[EMAIL PROTECTED]]
Sent: Saturday, January 27, 2001 4:49 PM
To: [EMAIL PROTECTED]
Subject: Temporary tables
I'm using version 3.23.25, and am having trouble setting up a temporary
table. I have the following permanent table already set up:
bill_pay
(pbid int (8) default '0' not null auto_increment,
billdesc varchar(20),
bpamount int(8),
pbdate date,
budgetid int(8),
primary key (pbid), unique id (pbid))
I have tried to set up a temporary table:
CREATE TEMPORARY TABLE tempbills (
billdesc varchar(20),
bpamount int(8)
)
SELECT billdesc, bpamount FROM bill_pay
When I do this I get an error message saying "Duplicate column name
"billdesc"". And if I change the column names on the temp table it still
won't work - the table doesn't get created.
If someone could help me out I'd be grateful!
Matt
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
