MySQL syntax coloring in Dreamweaver CS3?

Discussion in 'Web Design and Development' started by Mitthrawnuruodo, Aug 4, 2007.

  1. Mitthrawnuruodo Moderator emeritus

    Mitthrawnuruodo

    Joined:
    Mar 10, 2004
    Location:
    Bergen, Norway
    #1
    As the title says: Is there a way to get syntax colouring for (My)SQL (and possibly other non-default languages) in Dreamweaver CS3?
     
  2. CANEHDN macrumors 6502a

    CANEHDN

    Joined:
    Dec 12, 2005
    Location:
    Eagle Mountain, UT
    #2
    What language are you writing the SQL in? I use php and you can't change the specific SQL syntax since the SQL syntax is contained in quotes as a string. It's always the same color as all strings.
     
  3. Mitthrawnuruodo thread starter Moderator emeritus

    Mitthrawnuruodo

    Joined:
    Mar 10, 2004
    Location:
    Bergen, Norway
    #3
    Just directly in .sql (and .mysql) text files.

    I use them in phpMyAdmin to build the structure in my databases... never really liked that "build the database and tables on first run" in php. That's just creepy... ;)
     
  4. yagran macrumors 6502a

    Joined:
    Jan 8, 2007
    Location:
    Brighton, East Sussex, UK
    #4
    term, not that i know of.

    Bu for sql coding in general, my favourite program (which i rely on heavinly) is http://www.razorsql.com/

    [​IMG]

    Its really good and cheap too at $50!
     
  5. Mitthrawnuruodo thread starter Moderator emeritus

    Mitthrawnuruodo

    Joined:
    Mar 10, 2004
    Location:
    Bergen, Norway
    #5
    Thanks, I'll look into that... it seems that also features database navigation and administration, which I've also been on the lookout for... :)
     
  6. elppa macrumors 68040

    elppa

    Joined:
    Nov 26, 2003
    #6

    You may have already tried it, but there is the free CocoaMySQL. From the screen-shots it is not as advanced as razor SQL and it just deals with MySQL, no other databases. It is also not updated that regularly, but I have found it perfectly adequate for my use.
     
  7. c3str macrumors member

    Joined:
    Jun 27, 2007
    #7
    Hmm.

    I'm surprised that's not an option in preferences/code coloring. Seems like it would be a reasonable expectation.

    Found an article on extensible code coloring in MX2004, but nothing recent.
    extensible code coloring tutorial
     
  8. WildPalms macrumors 6502a

    WildPalms

    Joined:
    Jan 4, 2006
    Location:
    Honolulu, HI
    #8
    Better than Navicat?
     
  9. SC68Cal macrumors 68000

    Joined:
    Feb 23, 2006
    #9
    I never found SQL statements to be complex enough to require coloring.
     
  10. elppa macrumors 68040

    elppa

    Joined:
    Nov 26, 2003
    #10
    How come you have two big books on SQL then ;)

    I think it can be beneficial for picking up mistakes quickly.
     
  11. SC68Cal macrumors 68000

    Joined:
    Feb 23, 2006
    #11
    Uh, because there is more to SQL than just syntax maybe? Perhaps something called database design?

    I'll go grab my highlighter :D
     

Share This Page