db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dan Scott <deni...@gmail.com>
Subject Re: some questions about porting mysql database to derby database
Date Sat, 12 Nov 2005 20:40:12 GMT
This might be obvious, but...

4 -- make sure you remove "TYPE=INNODB" from the end of the statement
-- this is a MySQLism. You only need a statement terminator (;) if
you're issuing the statement from within ij, or in a script processed
by ij. In an application you just issue the statement with no
terminator.

Dan

On 11/12/05, Legolas Woodland <legolas.w@gmail.com> wrote:
>
>
> some questions about porting mysql database to derby database
> Thank you for reading my post
> I am porting a database of myself from Mysql to derby.  I am converting the
> database creation script for now.
> I found some of my questions in mailing liast and some are remind which i
> ask now.
> 1-i used smallint instead of bool , is it ok ? as we put value 0 ,1 as true
> and false.
> 2-I used blob instead of LONGBLOB.
> 3-how i can translate following table as it has forigen Key and combind
> primary key items ?
> CREATE NEWS_INTEREST (
>   channelid INTEGER,
>   userid INTEGER,
>   PRIMARY KEY (channelid, userid),
>   FOREIGN KEY (channelid) REFERENCES SB_NEWS_CHANNELS(id) ON DELETE CASCADE,
>   FOREIGN KEY (userid) REFERENCES SB_USERS(userid) ON DELETE CASCADE
> ) TYPE=INNODB;
>
> 4-as you see in the above  , mysql statement are finished with ;
> now my question is : what should i use instead of ; ? i tried to use
> go;
> ;
> blank
> in the end of each create table but it is not correct :(
>
> Tahnk you for help
>

Mime
View raw message