Skip to content

There is no spoon^M^M^M^M^Mauto_increment

Got this from a mysqlcheck report:


warning : Found row where the auto_increment column has the value 0
unihelp_db_propietary.unihelp_stats


Too pity, this table has no auto_increment field:

mysql> desc unihelp_stats;
+-------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+-------+
| url | varchar(126) | | PRI | | |
| count | int(11) | | | 0 | |
+-------+--------------+------+-----+---------+-------+
2 rows in set (0.00 sec)

Should i repeat myself?

  • Twitter
  • Bookmark There is no spoon^M^M^M^M^Mauto_increment at del.icio.us
  • Facebook
  • Google Bookmarks
  • FriendFeed
  • Digg There is no spoon^M^M^M^M^Mauto_increment
  • Bloglines There is no spoon^M^M^M^M^Mauto_increment
  • Technorati There is no spoon^M^M^M^M^Mauto_increment
  • Fark this: There is no spoon^M^M^M^M^Mauto_increment
  • Bookmark There is no spoon^M^M^M^M^Mauto_increment at YahooMyWeb
  • Bookmark There is no spoon^M^M^M^M^Mauto_increment at Furl.net
  • Bookmark There is no spoon^M^M^M^M^Mauto_increment at reddit.com
  • Bookmark There is no spoon^M^M^M^M^Mauto_increment at blinklist.com
  • Bookmark There is no spoon^M^M^M^M^Mauto_increment at Spurl.net
  • Bookmark There is no spoon^M^M^M^M^Mauto_increment at Simpy.com
  • Bookmark There is no spoon^M^M^M^M^Mauto_increment at blogmarks
  • Bookmark There is no spoon^M^M^M^M^Mauto_increment with wists
  • wong it!
  • Bookmark using any bookmark manager!
  • Stumble It!
  • Identi.ca

Trackbacks

ads' corner on : f* Mysql

Show preview
Today i awoke because the nagios used by our isp sent me a sms: something does not work well on one of the association servers. According to the sms, the webserver was not responding. Ok, the webserver is never the cause of the problem, something else is Comments ()

ads' corner on : Primary key in Mysql doubled

Show preview
Got a nice problem: a table, which has the following primary key: id, id.You can use or dump this table without problems ... but you cannot reinsert the dump into the same (4.1) or a newer (5.0) mysql version.This is the table dump, created with "S Comments ()

Comments

Display comments as Linear | Threaded

Stefan Kaltenbrunner on :

unihelp_db_propietary.unihelp_stats ^^^ heisst die Datenbank wirklich so ? :-)
Comments ()

Andreas 'ads' Scherbaum on :

Ja. Und es ist nicht meine Erfindung, das war vor mir schon, ich wollte es bloss nicht für das Blog anonymisieren.
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