Re: select in create

2002-08-27 Thread Egor Egorov
Ilyas, Tuesday, August 27, 2002, 4:55:45 PM, you wrote: IK> Can I also use a select statement in a create statement. Something like this: IK> create table mytable IK> ( IK> id int not null primary key (select max(id) from mytable2), IK> name varchar(255) IK> ); Nope. IK> is thi

R: select in create

2002-08-27 Thread Danilo Maurizio
A: [EMAIL PROTECTED] Oggetto: select in create Can I also use a select statement in a create statement. Something like this: create table mytable ( id int not null primary key (select max(id) from mytable2), name varchar(255) ); is this possible or is there an other way to do

Re: select in create

2002-08-27 Thread Krata
> Can I also use a select statement in a create statement. Something like this: > > create table mytable > ( > id int not null primary key (select max(id) from mytable2), > name varchar(255) > ); > > is this possible or is there an other way to do something like this? > > ilyas >

select in create

2002-08-27 Thread Ilyas Keser
Can I also use a select statement in a create statement. Something like this: create table mytable ( id int not null primary key (select max(id) from mytable2), name varchar(255) ); is this possible or is there an other way to do something like this? ilyas filter: mysql --