Hi Makoto,
try
create table t2 (like t1);
I am not sure why it needs the parenthesis:)
lefteris
On Sun, Jan 3, 2010 at 9:51 PM, Makoto YUI
Martin,
Thank you for the quick reply.
Martin Kersten wrote:
create table t2 as (select * from t1 limit 1) with data; This is improper SQL syntax.
Limit can only be placed on the result set.
Okey. Here is another issue.
create table t1 (f1 int); create table t2 like t1;
syntax error, unexpected LIKE, expecting AS in: "create table t2 like"
Is "create table like" statement as in the document supported in the current release? http://monetdb.cwi.nl/SQL/Documentation/Table-Management.html
Thanks, Makoto
------------------------------------------------------------------------------ This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users