Forum OpenACS Q&A: MySQL Gotchas - a link for PG/MySQL questions...

Collapse
1: MySQL Gotchas - a link for PG/MySQL questions...
Posted by Patrick Giagnocavo on 11/18/03 10:25 PM
This link points out some of the "gotchas" that MySQL users have to deal with:

http://sql-info.de/mysql/gotchas.html

One example that jumped out at me:  if you turn on the InnoDB type tables, you can drop any table, even one referenced by another table, i.e. you can break foreign key constraints with impunity.  And you need to turn on InnoDB... in order to get transactions.

Collapse
2: Re: MySQL Gotchas - a link for PG/MySQL questions... (response to 1)
Posted by Guan Yang on 11/18/03 10:43 PM
I think you can do the same with non-InnoDB type tables (e.g. MyISAM tables). 😉
Collapse
3: Re: MySQL Gotchas - a link for PG/MySQL questions... (response to 1)
Posted by Jade Rubick on 11/19/03 07:39 PM
Can we link to this from the "Why not MySQL" page?
Collapse
4: Re: MySQL Gotchas - a link for PG/MySQL questions... (response to 1)
Posted by Mark Aufflick on 11/21/03 05:06 AM
My favourites are the first one about how inserting a null into a not null column with no default attempts to insert some "reasonable" default instead of throwing an error (that one has hurt me before)

and 1.13 - date columns accept, eg. 2003-02-31

grr - why do so many of my clients INSIST on mysql :(