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
