MySQL Gotchas

1,095 registered users | 2 active users | 1 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #199,627 by cforde 3/20/05 6:20:17 PM Reply	MySQL Gotchas [link\|http://sql-info.de/mysql/gotchas.html\|MySQL Gotchas] scary stuff. Here's another that isn't on that list (yet?): Update ... limit ... [link\|http://dev.mysql.com/doc/mysql/en/update.html\|MySQL update syntax]. The where clause specifies n rows, the limit says (n-x), so x rows aren't updated and you have no way to know which ones. How is that ever a good idea? Have fun, Carl Forde
Post #199,643 by folkert 3/20/05 9:39:19 PM Reply	My favorite quote: 6. Oh yes, this page does not render well in Internet Explorer, run along and get yourself a proper browser. -- [link\|mailto:greg@gregfolkert.net\|greg], [link\|http://www.iwethey.org/ed_curry\|REMEMBER ED CURRY!] @ *i_wethey* [link\|http://it.slashdot.org/comments.pl?sid=134485&cid=11233230\|"Microsoft Security" is an even better oxymoron than "Military Intelligence"] No matter how much Microsoft supporters whine about how Linux and other operating systems have just as many bugs as their operating systems do, the bottom line is that the serious, gut-wrenching problems happen on Windows, not on Linux, not on Mac OS. -- [link\|http://www.eweek.com/article2/0,1759,1622086,00.asp\|source]
Post #199,942 by inthane-chan 3/22/05 2:06:32 PM Reply	Somebody's channeling Peter in 'snarky' mode.

Simplistic Database locking. - (static) - (19) - March 18, 2005, 01:15:11 AM EST

AFAIK, Oracle is the only one using its model -NT - (ben_tilly) - (2) - March 18, 2005, 01:47:50 AM EST

Postgres allows it too -NT - (broomberg) - (1) - March 18, 2005, 06:38:29 AM EST

Does it now? - (static) - March 18, 2005, 07:01:52 AM EST

Re: Simplistic Database locking. - (JayMehaffey) - (6) - March 18, 2005, 09:40:45 AM EST

The SELECT does. - (static) - (5) - March 21, 2005, 12:49:10 AM EST

Re: The SELECT does. - (JayMehaffey) - (4) - March 21, 2005, 09:16:52 AM EST

It's not an InnoDB table. - (static) - (3) - March 21, 2005, 06:46:33 PM EST

"Including 'THE' other..." ?!? :-( - (CRConrad) - (1) - March 22, 2005, 02:57:24 AM EST

Quite. - (static) - March 22, 2005, 06:17:56 AM EST

That would be a problem. - (JayMehaffey) - March 22, 2005, 09:43:49 AM EST

The "Multi-Generational Architecture"... - (CRConrad) - (8) - March 18, 2005, 02:05:37 PM EST

More commonly known as MVCC - (tuberculosis) - (7) - March 20, 2005, 05:52:19 AM EST

You'd be amazed - (drewk) - March 20, 2005, 01:41:46 PM EST

MySQL Gotchas - (cforde) - (2) - March 20, 2005, 06:20:17 PM EST

My favorite quote: - (folkert) - (1) - March 20, 2005, 09:39:19 PM EST

Somebody's channeling Peter in 'snarky' mode. -NT - (inthane-chan) - March 22, 2005, 02:06:32 PM EST

That postgres link is really useful. - (static) - (2) - March 21, 2005, 12:46:21 AM EST

mysql - (tuberculosis) - (1) - March 21, 2005, 01:16:06 AM EST

That is the question *I* keep asking MySELF. - (folkert) - March 21, 2005, 09:14:29 AM EST

with the hot blonde.
81 ms