Tag: mysql

  • Learning What I Know

    โ€”

    by

    in ,

    I recently received an e-mail from one of my subscribers that asked a question. The answer may be useful to some so I’m placing it here. The original question It seems so interesting developing websites application these days, thanks to the web 2.0 phenomena. I can’t call myself a web developer or anything near that,…

  • Oracle’s Auto Incrementing with Sequences

    โ€”

    by

    in ,

    My previous post, titled: ‘Sequence-less/Trigger-less Oracle Auto Increment‘ was shot out of the water by my friend and DBA, Jon Emmons. Glad to see that I can be kept in line. So I have resigned to use Oracle Sequences as a safer means for auto incrementing. But that doesn’t mean that I like it. Here’s…

  • Sequence-less/Trigger-less Oracle Auto Increment

    โ€”

    by

    in ,

    Oracle sucks. Well, not totally, but it fails in a lot of places where MySQL is sexy. One little gem of an irritation is the lack of an auto_increment attribute associated with fields. Instead you have to make use of Oracle Sequences/Triggers which adds a whole layer of complexity on the creation and insertion into…