[Home]MySQL

ec2-44-213-63-130.compute-1.amazonaws.com | ToothyWiki | RecentChanges | Login | Webcomic

A moderately good, free (insert licensing stuff here) database with moderately bad tools.

Has a number of 'features' which can be... unhelpful.  See: [MySQL Gotchas], [Operator Precedence] (wrt NOT), [Silent Column Specification Changes].

As recently (WikiNow: 22 Feb 2005) demonstrated by LiveJournal and again by WikiPedia, sucks at coming back up after a powercut.
Currently (same day) PennyArcade is also displaying their MySql? problems...

If anyone knows any other common pitfalls, please mention them here.



 SELECT CONCAT('[', id, ']') FROM MyTable? WHERE id='123456X'
returns '[123456X  ]'...  Grrrr... --K

Is id a CHAR or VARCHAR? --B
Varchar --K
All I can do is * boggle * --B (and see if it's a bug that's been fixed etc. Googling didn't turn much up in 5 minutes, but I've just come back from a whisky-tasting so am somewhat enubriated ;-) --B
After the thirteenth or fourteenth, it's just drinking, you know.


CategoryComputing

ec2-44-213-63-130.compute-1.amazonaws.com | ToothyWiki | RecentChanges | Login | Webcomic
Edit this page | View other revisions | Recently used referrers
Last edited March 10, 2006 9:26 am (viewing revision 9, which is the newest) (diff)
Search: