Skip to content

MySQL creates rows out of nothing

After issuing a REPAIR TABLE:

 mysql> repair table search_archive_count_checked;
+----------------------------------+--------+----------+----------------------------------------------+
| Table                            | Op     | Msg_type | Msg_text                                     |
+----------------------------------+--------+----------+----------------------------------------------+
| xxx.search_archive_count_checked | repair | warning  | Number of rows changed from 335540 to 365874 |
| xxx.search_archive_count_checked | repair | status   | OK                                           |
+----------------------------------+--------+----------+----------------------------------------------+
2 rows in set (36.75 sec)

I'm surprised: this is the first database which is able to create rows out of nothing. Violation of the conversation of energy data, eh? ;-)

  • Twitter
  • Bookmark MySQL creates rows out of nothing at del.icio.us
  • Facebook
  • Google Bookmarks
  • FriendFeed
  • Digg MySQL creates rows out of nothing
  • Bloglines MySQL creates rows out of nothing
  • Technorati MySQL creates rows out of nothing
  • Fark this: MySQL creates rows out of nothing
  • Bookmark MySQL creates rows out of nothing at YahooMyWeb
  • Bookmark MySQL creates rows out of nothing at Furl.net
  • Bookmark MySQL creates rows out of nothing at reddit.com
  • Bookmark MySQL creates rows out of nothing at blinklist.com
  • Bookmark MySQL creates rows out of nothing at Spurl.net
  • Bookmark MySQL creates rows out of nothing at Simpy.com
  • Bookmark MySQL creates rows out of nothing at blogmarks
  • Bookmark MySQL creates rows out of nothing with wists
  • wong it!
  • Bookmark using any bookmark manager!
  • Stumble It!
  • Identi.ca

Trackbacks

No Trackbacks

Comments

Display comments as Linear | Threaded

No comments

Add Comment

Enclosing asterisks marks text as bold (*word*), underscore are made via _word_.
E-Mail addresses will not be displayed and will only be used for E-Mail notifications.
To leave a comment you must approve it via e-mail, which will be sent to your address after submission.
Form options