Re: Going from Oracle to Mysql

I can't believe you still put on your LEFT sock first, that proc was updated with v 3.4 of the typical Oracle bod patch - RIGHT first always...Please update your system...

.

"Richard Foote" <richard.foote_at_bigpond.com> wrote:

>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...
>>
>>
>>
>>
>

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

   http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Mon Aug 26 2002 - 10:39:18 CDT