Any MYSQL guru's in here?

Discussion in 'OT Technology' started by TRN, Jul 12, 2006.

  1. TRN

    TRN Well-Known Member

    Joined:
    Aug 22, 2003
    Messages:
    55,130
    Likes Received:
    132
    Location:
    North East
    How do you remember all of the commands and what not?
     
  2. RyanL

    RyanL OT Supporter

    Joined:
    Nov 30, 2004
    Messages:
    4,584
    Likes Received:
    0
    Location:
    St. Paul, MN
  3. P07r0457

    P07r0457 New Member

    Joined:
    Sep 20, 2004
    Messages:
    28,491
    Likes Received:
    0
    Location:
    Southern Oregon
    99% of SQL is easy stuff you'll just remember. For the remaining 1%, a quick check on the documentation will satisfy your needs.
     
  4. Yep

    Yep Knick knack paddy whack, give the old dog a bone

    Joined:
    Jan 22, 2001
    Messages:
    4,603
    Likes Received:
    0
    Location:
    South Jersey
    My applications are so simple SQL queries work fine for me. I've never read up on the built in functions... I probably should.
     
  5. TRN

    TRN Well-Known Member

    Joined:
    Aug 22, 2003
    Messages:
    55,130
    Likes Received:
    132
    Location:
    North East
  6. Coottie

    Coottie BOOMER......SOONER OT Supporter

    Joined:
    Jun 6, 2006
    Messages:
    32,407
    Likes Received:
    0
    Location:
    OKC
    Hmm...I've been wanting to check out MySQL since I started taking a DB class this summer. We're using Oracle but I like the idea of a free RDBMS.

    I just thought most of the SQL DBs were very similar??
     
  7. Penguin Man

    Penguin Man Protect Your Digital Liberties

    Joined:
    Apr 27, 2002
    Messages:
    21,696
    Likes Received:
    0
    Location:
    Edmonton, AB
    For the user, the differences between MySQL and Oracle are negligible (I'm sure they're very different beasts under the hood, but most of us will never have to care about that very much). They name a few things differently, but for the most part SQL is SQL.

    We used Oracle for the SQL part of my DB course as well. All the important stuff was completely transferrable to the bits of MySQL and SQLite stuff I've done since.
     
  8. Peyomp

    Peyomp New Member

    Joined:
    Jan 11, 2002
    Messages:
    14,017
    Likes Received:
    0
    If you're just starting out playing with DBs, may I recommend SQLite instead. www.sqlite.org

    I love MySQL, but its often much more than is called for.
     
  9. deusexaethera

    deusexaethera OT Supporter

    Joined:
    Jan 27, 2005
    Messages:
    19,712
    Likes Received:
    0
    "gurus" is plural. It does not need an apostrophe. If you're looking to learn a language, try learning English first.
     
  10. Yep

    Yep Knick knack paddy whack, give the old dog a bone

    Joined:
    Jan 22, 2001
    Messages:
    4,603
    Likes Received:
    0
    Location:
    South Jersey

    No wonder jollyogre picks on you all the time.
     
  11. deusexaethera

    deusexaethera OT Supporter

    Joined:
    Jan 27, 2005
    Messages:
    19,712
    Likes Received:
    0
    He might hassle me for not sticking strictly to the topic at hand, but I seriously doubt he'd have a problem with expecting someone to know something as simple as when to use punctuation -- especially considering how important syntax is in the context of computer languages.

    Either way I wouldn't care if he did object; there is no excuse for not knowing how to use the English language correctly, regardless of how many cheesy complaints somebody could throw at me about how it's a casual forum and how spelling/grammar/typing/mechanics don't matter here. We're technical people, are we not?
     
  12. piratepenguin

    piratepenguin New Member

    Joined:
    Jun 18, 2006
    Messages:
    1,067
    Likes Received:
    0
    Location:
    Ireland
    an extra apostrophe never made anything crash
     
  13. CyberBullets

    CyberBullets I reach to the sky, and call out your name. If I c

    Joined:
    Nov 13, 2001
    Messages:
    11,865
    Likes Received:
    0
    Location:
    BC, Canada/Stockholm, Sweden
    No, but a wrong math symbol prevented stacked, multi floor doom levels. I believe it was a + instead of a *. It was noticed was the code went to GLP.
     
  14. Peyomp

    Peyomp New Member

    Joined:
    Jan 11, 2002
    Messages:
    14,017
    Likes Received:
    0
    fu'ck the g'rammar nazi's
     
  15. Penguin Man

    Penguin Man Protect Your Digital Liberties

    Joined:
    Apr 27, 2002
    Messages:
    21,696
    Likes Received:
    0
    Location:
    Edmonton, AB
    I :love: sqlite. No fucking around with server bullshit for small applications, just throw the db in a file.
     
  16. piratepenguin

    piratepenguin New Member

    Joined:
    Jun 18, 2006
    Messages:
    1,067
    Likes Received:
    0
    Location:
    Ireland
    For a small blog, would sqlite be feasible? What about a not-so-small blog?
     
  17. TRN

    TRN Well-Known Member

    Joined:
    Aug 22, 2003
    Messages:
    55,130
    Likes Received:
    132
    Location:
    North East
    I'll look into it. :cool:

    I've also got a week long class on Cold Fusion coming up as well.
     
  18. Chau

    Chau if i wanted to kill you, i would've come in here s

    Joined:
    May 30, 2000
    Messages:
    95,448
    Likes Received:
    0
    Location:
    CTU
    select, update, delete, insert
     

Share This Page