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


	The Toolkit for Online Communities 15889 Community Members, 0 members online, 1684 visitors today			Log In	Register

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

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

Back to OpenACS Q&A

Icon of Envelope Request notifications

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.

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).

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?

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 :(

Back to OpenACS Q&A