2 messages in com.mysql.lists.mysqlTable Creation
FromSent OnAttachments
Rajesh Krishna Murthy15 Mar 2000 16:09 
Tonci Grgin28 Mar 2000 04:11 
Subject:Table Creation
From:Rajesh Krishna Murthy (rkmu@ecalyx.com)
Date:03/15/2000 04:09:09 PM
List:com.mysql.lists.mysql

hi ,

i am using my sql with windows nt version. could somebody let me know how to do the following since i am getting error

i want to create a new table with columns from other tables like

create table tab1 select no,name, sal from tab2

but it should not be a temporary table or type =hash (which i think temporary) so tab1 should be permanent. Any way aroung since most rdbms support this feature.

regards. Raj.