MySQL

ec2-3-145-156-250.us-east-2.compute.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