The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
79 views

mysql tables strange behaviour

i have a wordpress driven web site. i am having a very very weird issue. i am clean installing my wordpress, using it about a week or so then i am losing admin rights in wp-admin. i can login with my ...
0
votes
3answers
659 views

MYSQL Table Reset Auto Increment to 1, while retaining existing records with ids

I have a MySQL table naming Product for a classified site, product_id is bigint(20) AUTO_INCREMENT field. Currently AUTO_INCREMENT value is 224143. Client want it to restart from 1. but this table ...
1
vote
4answers
3k views

MySQL Auto Increment failing

I am having a table with one column of primary key and auto increment of int(11) data type. When I am trying to insert into that table, I am getting following error. Failed to read auto-increment ...
4
votes
5answers
2k views

MySQL Auto-increment fields resets by itself

We have a MySQL table that has an auto-incrementing field set as an INT (11). This table pretty much stores a list of jobs that are running in an application. At any given moment during the lifetime ...
2
votes
1answer
387 views

How to scale out by elvolving from database partitions to sharding?

Say I have a MySQL table: CREATE TABLE tweets ( tweet_id INT NOT NULL AUTO_INCREMENT, author_id INT NOT NULL, text CHAR(140) NOT NULL, PRIMARY KEY (tweet_id) ) PARTITION BY HASH(tweet_id) PARTITIONS ...
1
vote
1answer
1k views

How to create a table in MySQL with automatic numeration of rows?

I just want to have a table in which a first column is a monotonically increasing unique integer number. For example, if I have a table with 5 rows the indexes of the rows should be 1,2,3,4,5. And if ...
3
votes
2answers
1k views

How to force MySQL to take 0 as a valid auto-increment value

Long story short, I have a SQL file that I want to import as a skel style file, so this will be done repeatedly, programmatically. I can edit the SQL file however I want, but I'd rather not touch the ...