Re: Going from Oracle to Mysql

Hi Michael,

You don't think your comment is a touch of an over generalisation ? It's actually a generalisation based on one of the most helpful contributors to this NG which is interesting and based on the unhelpful response to a question that is totally irrelevant to the forum this NG addresses.

If you want to generalise the average Oracle bod, I would suggest most are: good looking, good in bed, 6 feet tall with a darkish complexion, left handed, vegetarian, live to be 75.3 years of age, enjoy David Bowie and Pink Floyd, married with 2 children, put on left sock then left shoe followed by right sock and right shoe, drink too much scotch, bourbon and rum (generally mixed together), dream of living in Australia, eat porridge for breakfast and were really good at bean bag races at school carnivals.

This I do believe accurately describes all Oracle bods, then again I could be wrong (as I personally hate porridge). However, unhelpful, unkind and arrogant they are generally not so why not ask a relevant and appropriate question for this NG and find out for yourself ;)

Cheers

Richard
"Michael Williams" <nospam_at_nospam.com> wrote in message news:vJ1a9.313$GS1.22943_at_newsfep1-gui.server.ntli.net...
> "Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message
> news:3D57D398.51B98DC8_at_exesolutions.com...
> > cg wrote:
> >
> > > In mysql I have created the following table:
> > >
> > > CREATE TABLE Emp(
> > > EmpNr INTEGER NOT NULL AUTO_INCREMENT,
> > > Name varchar(30) NOT NULL,
> > > Adr varchar(30) NOT NULL,
> > > zip INTEGER NOT NULL,
> > > city varchar(30) NOT NULL,
> > > phone varchar(20) NOT NULL,
> > > Email varchar(30),
> > > Password varchar(40) NOT NULL,
> > > PRIMARY KEY(EmpNr));
> > >
> > > The first element, EmpNr, has an auto_increment variable attached to
it.
> > >
> > > Now, in Oracle, I would use a a statement like the following in order
> > > to insert into a table with a sequence attached to it:
> > >
> > > insert into Emp values (Unik.nextval,?,?,?,?,?,?,?)
> > > (used for a preparedStatement in the database)
> > >
> > > What would the corresponding query look like in mysql??
> > >
> > > Also I would like to know what the following query looks like in
mysql:
> > >
> > > select AddedEmp.currval from Emp
> > > (when the sequence in Oracle looks like
> > > create sequence AddedEmp increment by 1;)
> > >
> > > ??
> > >
> > > Any help is very much appreciated!
> > >
> > > ps please do also send to my email address in the response.
> >
> > What is going on here? Several questions about MySQL in the last few
days.
> > Which part of the fact that the name of these usenet groups is
> > comp.databases.ORACLE is escaping you folks?
> >
> > 1. We don't know.
> > 2. We don't care.
> > 3. You made the choice to use a product lacking in support, lacking in
> > documentation, lacking in usenet groups. No us.
> >
> > Daniel Morgan
> >

>
> Wow, so it really is true that Oracle bods are unhelpful, unkind,
arrogant,
> and believe anyone even slightly less technical than themselves are a
waste
> of space...

>
>
>
>