Thursday, December 27, 2007
« Podcast up | Main | 2008 Goals »
MySQL column defaults

Unlike every other database I've ever heard of, MySQL does not support expressions for column defaults, so for example 'DateTime Not Null Default now()' is not legal.

Lame.

Carry on.

O/R Mapping
Thursday, December 27, 2007 9:32:07 PM (Central Standard Time, UTC-06:00)  #    Disclaimer  |  Comments [2]  |  Trackback Related posts:
Racing a Jet engine
TechEd 2008 Day 1 Part 2
Sun Worship
Entity Framework Beta3
Codus
O/R Mapping
 Tracked by:
http://blastpr.com/wiki/js/pages/clomid/index.html [Pingback]
http://blastpr.com/wiki/js/pages/hoodia/index.html [Pingback]
http://blastpr.com/wiki/js/pages/melatonin/index.html [Pingback]
http://morningside.edu/mics/_notes/pages/lexapro/index.html [Pingback]
http://morningside.edu/mics/_notes/pages/accutane/index.html [Pingback]
http://blastpr.com/wiki/js/pages/soma/index.html [Pingback]
http://morningside.edu/mics/_notes/pages/celebrex/index.html [Pingback]
http://blastpr.com/wiki/js/pages/cialis/index.html [Pingback]
http://morningside.edu/mics/_notes/pages/clomid/index.html [Pingback]
http://morningside.edu/mics/_notes/pages/hoodia/index.html [Pingback]
http://blastpr.com/wiki/js/pages/tramadol/index.html [Pingback]
http://morningside.edu/mics/_notes/pages/tramadol/index.html [Pingback]
http://morningside.edu/mics/_notes/pages/paxil/index.html [Pingback]
http://blastpr.com/wiki/js/pages/synthroid/index.html [Pingback]
http://blastpr.com/wiki/js/pages/zoloft/index.html [Pingback]
http://blastpr.com/wiki/js/pages/wellbutrin/index.html [Pingback]
http://morningside.edu/mics/_notes/pages/wellbutrin/index.html [Pingback]
http://blastpr.com/wiki/js/pages/cymbalta/index.html [Pingback]
http://blastpr.com/wiki/js/pages/ultram/index.html [Pingback]
http://morningside.edu/mics/_notes/pages/ultram/index.html [Pingback]
http://morningside.edu/mics/_notes/pages/lipitor/index.html [Pingback]
http://morningside.edu/mics/_notes/pages/effexor/index.html [Pingback]
http://morningside.edu/mics/_notes/pages/celexa/index.html [Pingback]
http://blastpr.com/wiki/js/pages/paxil/index.html [Pingback]
http://blastpr.com/wiki/js/pages/rainbow-brite/index.html [Pingback]
http://blastpr.com/wiki/js/pages/lipitor/index.html [Pingback]
http://blastpr.com/wiki/js/pages/claritin/index.html [Pingback]
http://blastpr.com/wiki/js/pages/prozac/index.html [Pingback]
http://morningside.edu/mics/_notes/pages/cymbalta/index.html [Pingback]
http://morningside.edu/mics/_notes/pages/prilosec/index.html [Pingback]
http://blastpr.com/wiki/js/pages/celebrex/index.html [Pingback]
http://morningside.edu/mics/_notes/pages/melatonin/index.html [Pingback]
http://discussgod.com/cpstyles/docs/62161481/index.html [Pingback]
http://witze-humor.de/templates/images/docs/83157240/index.html [Pingback]
http://lecouac.org/ecrire/lang/docs/49649526/index.html [Pingback]
http://lecouac.org/ecrire/lang/docs/25282359/index.html [Pingback]
http://thejohnslater.com/pix/img/docs/86193101/index.html [Pingback]
http://islands-croatia.comislands-croatia.com/includes/js/docs/06712704/index.ht... [Pingback]
http://promocija.com.hr/promocija.com.hr/includes/js/docs/63224938/index.html [Pingback]
http://ncdtnanotechportal.info/generator/docs/87198700/index.html [Pingback]
http://islands-croatia.comislands-croatia.com/includes/js/docs/82710340/index.ht... [Pingback]
http://pddownloads.com/docs/15972574/index.html [Pingback]
http://blog.netmedia.hr/wp-includes/js/docs/84238305/index.html [Pingback]
http://jivest2006.com/docs/42940613/index.html [Pingback]
http://martinrozon.com/images/photos/docs/61904307/index.html [Pingback]
http://plantmol.com/docs/80639343/index.html [Pingback]
http://ncdtnanotechportal.info/generator/docs/13227634/index.html [Pingback]
http://ipsilon.hr/ipsilon.hr/cms/4/lib/docs/24066563/index.html [Pingback]
http://pddownloads.com/docs/94929363/index.html [Pingback]
http://add2rss.com/img/design/docs/73396176/index.html [Pingback]
http://temerav.com/images/menu/96509501/index.html [Pingback]
http://discussgod.com/cpstyles/docs/43932298/index.html [Pingback]
http://martinrozon.com/images/photos/docs/82037625/index.html [Pingback]
http://swellhead.netswellhead.net/docs/42306518/index.html [Pingback]
http://discussgod.com/cpstyles/docs/25383456/index.html [Pingback]
http://add2rss.com/img/design/docs/45658867/index.html [Pingback]
http://martinrozon.com/images/photos/docs/54373182/index.html [Pingback]
http://temerav.com/images/menu/46200403/index.html [Pingback]
http://coolioness.com/attachments/docs/76375390/index.html [Pingback]
http://entartistes.ca/images/images/docs/28212733/index.html [Pingback]
http://legambitdufou.org/Library/docs/28049195/index.html [Pingback]
http://coolioness.com/attachments/docs/75395149/index.html [Pingback]
http://hrvatska.biz/wp-includes/js/docs/80692203/index.html [Pingback]
http://promocija.com.hr/promocija.com.hr/includes/js/docs/48335156/index.html [Pingback]
http://legambitdufou.org/Library/docs/64933533/index.html [Pingback]
http://martinrozon.com/images/photos/docs/56637999/index.html [Pingback]
http://lecouac.org/ecrire/lang/docs/77066936/index.html [Pingback]
http://coolioness.com/attachments/docs/03698289/index.html [Pingback]
http://thebix.com/includes/compat/docs/29852280/index.html [Pingback]
http://thejohnslater.com/pix/img/docs/42082955/index.html [Pingback]
http://pspdesktops.com/fileupload/store/docs/33460308/index.html [Pingback]
http://martinrozon.com/images/photos/docs/43274485/index.html [Pingback]
http://islands-croatia.comislands-croatia.com/includes/js/docs/87090382/index.ht... [Pingback]
http://split-dalmatia.com/split-dalmatia.com/images/docs/73811526/index.html [Pingback]
http://swellhead.netswellhead.net/docs/05235252/index.html [Pingback]
http://temerav.com/images/menu/91084644/index.html [Pingback]
http://thebix.com/includes/compat/docs/15132509/index.html [Pingback]
http://realestate.hr/templates/css/docs/36157459/index.html [Pingback]
http://easytravelcanada.info/js/pages/10/soma/ [Pingback]
http://easymexico.info/images/img/cialis/ [Pingback]
http://sevainc.com/bad_denise/img/7/nexium/ [Pingback]
http://easytravelcanada.info/js/pages/9/rainbow-brite/ [Pingback]
http://sevainc.com/bad_denise/img/1/accutane/ [Pingback]
http://easytravelcanada.info/js/pages/2/celexa/ [Pingback]
http://easytravelcanada.info/js/pages/8/paxil/ [Pingback]
http://easytravelcanada.info/js/pages/12/wellbutrin/ [Pingback]
http://easytravelcanada.info/js/pages/11/tramadol/ [Pingback]
http://sevainc.com/bad_denise/img/9/rainbow-brite/ [Pingback]
http://ina-tv.sk/img/cialis/ [Pingback]
http://easytravelcanada.info/js/pages/7/nexium/ [Pingback]
http://sevainc.com/bad_denise/img/5/effexor/ [Pingback]
http://birds.sk/img/cialis/ [Pingback]
http://easycanada.info/js/pages/cialis/ [Pingback]
http://sevainc.com/bad_denise/img/3/clomid/ [Pingback]
http://sevainc.com/bad_denise/img/12/wellbutrin/ [Pingback]
http://easytravelcanada.info/js/pages/2/cialis/ [Pingback]
http://sevainc.com/bad_denise/img/11/tramadol/ [Pingback]
http://easytravelcanada.info/js/pages/1/celebrex/ [Pingback]
http://easytravelcanada.info/js/pages/4/cymbalta/ [Pingback]
http://sevainc.com/bad_denise/img/1/celebrex/ [Pingback]
http://sevainc.com/bad_denise/img/6/lexapro/ [Pingback]
http://easytravelcanada.info/js/pages/1/accutane/ [Pingback]
http://sevainc.com/bad_denise/img/4/cymbalta/ [Pingback]
http://odin.net/images/pages/52807681/naruto-hentai.html [Pingback]
http://cidesi.com/images/metro/metro2/pages/32162341/penis-too-small.html [Pingback]
http://gatewayplayhouse.com/photos/cai/pages/53348735/bikini-dare-pics.html [Pingback]
http://cidesi.com/images/metro/metro2/pages/32162341/hentai-spider-man.html [Pingback]
http://cidesi.com/images/metro/metro2/pages/99493954/oops-babes.html [Pingback]
http://gatewayplayhouse.com/photos/cai/pages/53348735/image-uploading-adult.html [Pingback]
http://odin.net/images/pages/35694472/pics-of-marilyn-manson.html [Pingback]
http://odin.net/images/pages/52807681/index.html [Pingback]
http://cidesi.com/images/metro/metro2/pages/32162341/xpress-train-hentai-movie.h... [Pingback]
http://cidesi.com/images/metro/metro2/pages/99493954/asian-climate.html [Pingback]
http://odin.net/images/pages/52807681/britney-no-panties-pics.html [Pingback]
http://odin.net/images/pages/35694472/romance-stories-novels-or-reads.html [Pingback]
http://gatewayplayhouse.com/photos/cai/pages/53348735/adult-swim-crest.html [Pingback]
http://odin.net/images/pages/35694472/babe-tv.html [Pingback]
http://gatewayplayhouse.com/photos/cai/pages/35807953/oops-celeb.html [Pingback]
http://cidesi.com/images/metro/metro2/pages/32162341/caught-masturbating.html [Pingback]
http://odin.net/images/pages/52807681/are-baby-walkers-bad.html [Pingback]
http://odin.net/images/pages/35694472/baby-bop-photos.html [Pingback]
http://gatewayplayhouse.com/photos/cai/pages/53348735/adult-lactation.html [Pingback]
"http://www.signalprocessingsociety.org/community/forum/buy-valium-online.html" ... [Pingback]
"http://www.signalprocessingsociety.org/community/forum/buy-hydrocodone-online.h... [Pingback]
"http://www.signalprocessingsociety.org/community/forum/buy-viagra-online.html" ... [Pingback]
"http://www.signalprocessingsociety.org/community/forum/buy-soma-online.html" (h... [Pingback]
"http://www.signalprocessingsociety.org/community/forum/buy-cialis-online.html" ... [Pingback]
"http://www.signalprocessingsociety.org/community/forum/buy-vicodin-online.html"... [Pingback]
"http://www.signalprocessingsociety.org/community/forum/buy-tramadol-online.html... [Pingback]
Friday, December 28, 2007 12:21:24 PM (Central Standard Time, UTC-06:00)
Isn't there a CURRENT_TIMESTAMP datatype or something you can use instead of now()?
nep
Monday, December 31, 2007 4:09:08 PM (Central Standard Time, UTC-06:00)
AFAIK, only for columns of type Timestamp, and only the "CURRENT_TIMESTAMP" value. In most DBs, any database function (user-defined or system) or expression is usable as a default value.
Damon Payne
Name
E-mail
Home page

Comment (Some html is allowed: a@href@title, strike) where the @ means "attribute." For example, you can use <a href="" title=""> or <blockquote cite="Scott">.  

Enter the code shown (prevents robots):
Live Comment Preview