Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2006
    Posts
    1

    Unanswered: Can u give me some info (MySQL)?

    hi...
    I want to know some Information about MySQL ... Can any one help me please?

    -Who is its vendor and how long it is being used in market?
    -How to get on it to use first time and initial start of using?
    -Can you give me any three SQL statements which work in Oracle but not on MySQL, and why(if u can)?


    thanks

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    see MySQl's website for details

    as regards for soemhting that oracle does that MySQL can't...now that could be tricky

    the best way would be to look at things that Orcale does that isnt according to the ANSI SQL standard, or equally soemthign that MySQL doesnt do according to the same standard

    One thing mySQL doesnt handle correctly is a grouping statement
    in MySQl its valid to do something like
    select colum,n1,column2,column3,sum(column4) as sumcolumn4 group by Column3, whereeas as the standard insists that you must have all the the columns selected in the group by expression

    there are lots of other permutations, however I think it comes down to what the heck the requirement is. if you need 'big' discrepancies then you may need to work a lot harder, but my copuy of SQL in a nutshell (pub O'Reilly) has ots of discrepancies listed... however it was published in 2001, and was comparing MySQL 3.22.9 and Oracle 8.1... both have moved on since then, arguably MySQL has moved the furtherest.

    If I were you Id do a google and try to do some searching of your own. A word of caution though, many peoples comments in thsi field are going to be limited by their own knwoledge, experiences, and in some cases prejudices... if you work with one database (and realistically you cant be an expert in all SQL databases [unless of course you are someone of Rudy's experience]) then you tend to be expert in that. some people cite software vendors marketing materail as gospel. Some people hold second hand comments as fact (where they are quoting facts discovered by someonelse years ago), or when they last looked at MySQL ...say years ago). I still hear statements that MySQL doesn't support stored procdures, referential integrity and a host of other features introduced since MySQL launched V5.

    when you cite a discrepancy make sure you tie down the verison number of mySQL & oracle they are talking about.

    One very very sneaky technique could be to compare the most recent Oracle/MySQL offering with the earliest MySQL/Oracle offering you can track down.
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    healdem, you are too kind, sincere thanks

    "any three SQL statements which work in Oracle but not on MySQL" sounds like a homework assignment
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Quote Originally Posted by r937
    healdem, you are too kind, sincere thanks
    ...to misquote from (was it) Waynes World) "I am not worthy". I recognise superior knowledge when I see it.
    And lets face it you have marked my cards several times recently, especially on the group by statement... not that Im still smarting from that.......

    Quote Originally Posted by r937
    "any three SQL statements which work in Oracle but not on MySQL" sounds like a homework assignment
    .....really
    .....I hadn't guessed
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •