In MySQL is it possible to create a temporary table without having to
specify all the properties? On SQL Server (at least via query analyzer) you
can create temp tables fairly easily and the properties of each field are
inherited from the regular table.
Doesn't look like thats the case with
create newtable select from oldtable where 1=0;
Admin wrote:
In MySQL is it possible to create a temporary table without having to
specify all the properties? On SQL Server (at least via query analyzer) you
can create temp tables fairly easily and the properties of each field are
inherited