Automatic UPDATE on INSERT

Posted on September 19th, 2003 by Sacha Chua
More posts about: -Uncategorized // Add Comment »

MySQL 4.1 (in alpha) now supports automatic UPDATE if INSERTing on existing row
http://www.mysql.com/doc/en/Nutshell_4.1_features.html

Whee! That will make coding _way_ simpler.

More posts about: -Uncategorized // Add Comment »

You might like these…
About me

I'm Sacha Chua. I'm having lots of fun geeking out about parenting our four-year-old. I also compile Emacs News weekly. I'm infrequently on: Twitter - Github - Facebook -Slideshare - LinkedIn
For more info, check out the About page.
Free/pay-what-you-want resources
- Sketchnotes 2014
  Latest collection of sketchnotes and thoughts
- Emacs Chats - EPUB, MOBI
  A collection of transcripts from the Emacs Chat series
- Sketchnotes 2013
  300+ sketches about learning, sharing, tech, semi-retirement, business, delegation, and other topics. You'll get a ZIP file (290+ MB) with hi-res images that you can easily flip through or print.
- A No-Excuses Guide to Blogging
  What's getting in your way when it comes to blogging consistently? Check out this 42-page guide to ten common blogging excuses and how to break past them.
- How to Learn Emacs
  
  a hand-drawn one-pager for beginners
Find more resources
Categories
- -Uncategorized (1,975)
- book (66)
- braindump (19)
- business (333)
  - delegation (46)
  - entrepreneurship (53)
  - gen-y (16)
  - leadership (21)
  - management (13)
  - marketing (20)
  - productivity (100)
- communication (445)
  - connecting (196)
  - presentation (109)
  - speaking (117)
  - talk (10)
  - teaching (85)
  - toastmasters (17)
- event (146)
  - barcamp (18)
  - cascon (10)
  - conference (52)
  - democamp (19)
  - digitalpinay (19)
  - meetup (15)
- finance (55)
- geek (1,780)
  - analysis (24)
  - android (24)
  - design (7)
  - development (54)
  - drupal (87)
  - emacs (1,051)
    - bbdb (22)
    - emacs-news (264)
    - org (88)
    - planner (31)
    - wickedcoolemacs (44)
  - free and open source (26)
  - laptop (11)
  - linux (51)
  - lotus (16)
  - quantified (86)
  - ruby (28)
    - rails (17)
  - wordpress (43)
- idea (12)
- issues (26)
- learning (447)
  - education (28)
  - japanese (15)
  - kaizen (184)
  - mentoring (15)
  - notetaking (22)
  - reading (67)
- life (1,668)
  - canada (55)
  - cat (52)
  - clothing (14)
  - cooking (147)
    - cookordie (65)
  - experiment (73)
  - family (113)
    - adphoto (17)
  - filipino (15)
  - friends (110)
    - barkada (22)
  - gardening (46)
  - goodkarma (13)
  - happy (41)
  - health (21)
  - japan (15)
  - library (16)
  - love (38)
  - party (22)
  - passion (48)
  - philippines (94)
  - photography (20)
  - purpose (36)
  - reflection (153)
  - sad (12)
  - school (79)
  - sewing (41)
  - story (13)
  - toronto (17)
  - travel (69)
- organization (21)
- organizer (15)
- parenting (79)
  - play (11)
- philosophy (16)
- planning (66)
- plans (31)
- podcast (44)
  - Emacs Chat (21)
  - emacs-basics (3)
  - Frugal FIRE (3)
  - Helpers Help Out (10)
- podcasting (3)
- process (23)
- research (52)
- review (859)
  - decision (55)
  - monthly (109)
  - weekly (653)
  - yearly (30)
- sharing (383)
  - drawing (92)
  - publishing (5)
  - writing (292)
    - blogging (190)
- social (39)
- Tidbits (10)
- time (34)
- tips (79)
- visual (377)
  - sketches (364)
    - sketchnotes (93)
    - visual-book-notes (40)
- women (44)
- work (338)
  - career (100)
  - enterprise2.0 (23)
  - ibm (99)
  - web2.0 (90)
Subscribe!
Subscribe

* indicates required

Your e-mail *

Type "Human" in the field below *

How often would you like to hear from me?
With each post: a daily stream of ideas

Weekly, monthly, and yearly updates: recommended

Monthly and yearly updates: neatly categorized

Once in a blue moon: yearly summaries, announcements

Just Emacs stuff

Email Format
html

text
If this form doesn't work for you, please try the sign-up page on Mailchimp. Thanks for your patience!
Recent comments
- Corwin Brust LOL, great story (and great tip!). Our middelest daughter didn't quite change her name like this, but she would say she was "M-1" or "M-...
- Christian Tietze That's quite good, thanks! -- When I heard about EmacsConf 2020 videos going online, this all came out of nowhere for me, and it was...
- sachac Good point! I've added a quick list to the end of http://emacsconf.org/2020/ - does that help?
- Christian Tietze Hmm I found it hard to figure out who's behind EmacsConf. I see that e.g. you are involved with the organization and subtitling, and in...
- Christian Tietze Oh cool, thanks! I added an Atom feed for the #emacs posts at: http://christiantietze.de/posts/tags/emacs/feed.atom Abin pointed out in an email that in vim, "yank" means...
- Older »
On this day...
- 2016: Weekly review: Week ending September 16, 2016
- 2016: 2016-09-19 Emacs News
- 2014: Learning from the Alternative Uses Task
- 2013: Sketchnote Lesson: Adding color
- 2012: Thinking about a Quantified Self directory
- 2011: IBM Comic: Watson on helpdesk duty; variants
- 2010: Week ending September 19, 2010
- 2008: Two-week review: 2 weeks ending September 19
- 2005: Hmm. Must hack my breathing.
- 2005: Networking for Geeks: Finding the Bleeding Edge through del.icio.us
- 2003: Tracking people’s history
- 2003: align-regexp
- 2003: CS21A today
- 2003: Encouragement =)
- 2003: More warm and fuzzy feelings
Meta

Automatic UPDATE on INSERT

You might like these…

About me

Free/pay-what-you-want resources

Categories

Subscribe!

Subscribe

Recent comments

On this day...

Meta