Tagged Questions
0
votes
0answers
33 views
Autoincrement by 2
I use MariaDB 5.5. It increases every auto_increment value by 2. So all my ai cols look like 1 3 5 7 9 ...
Where can I change this behaviour? Or might this be a bug?
1
vote
1answer
148 views
MariaDB, Triggers and last_insert_id
I have a situation where I have three tables: sample, sample_name and run (extra columns removed to be only relevant information).
CREATE TABLE `sample` (
`sample_id` int unsigned NOT NULL ...
2
votes
1answer
94 views
Why is InnoDB auto_increment column skipping over large blocks of unused values?
We have an active and important InnoDB table with about 8M rows. We just noticed that for several months, the primary key value (a BIGINT) has been jumping by hundreds at a time.
I turned on query ...
1
vote
3answers
506 views
How to use 2 auto increment columns in MySQL phpmyadmin
Is it possible to use 2 auto increment values ?
One starting from 0
Another starting from 4000400
Please help me
0
votes
1answer
392 views
MySQL auto increment problem with deleting rows / archive table
A hosted server is running "maintenance" each weekend. I am not privy to the details.
In a database on this server there is a MyISAM table. This table never holds more than 1000 rows and usually much ...
1
vote
1answer
101 views
does last_insert_id() returns correct result when writes from multiple sessions?
I have a table in which there is a combination of 4 columns that will act as a unique key.
Instead of using a composite primary key, I want to keep an id column as the primary key. This field is on ...
2
votes
1answer
288 views
MySql - alternate of auto_increment on multiple columns
Since auto_increment on multiple columns is supported in MyISAM engine only and I can't use it because of its drawbacks (table lock, slower writes, no-transacts etc), I am looking for an alternative.
...
8
votes
2answers
4k views
Is MySql's LAST_INSERT_ID() function guaranteed to be correct?
When I do a single row INSERT to a table that has an AUTO_INCREMENT column I'd like to use the LAST_INSERT_ID() function to return the new AUTO_INCREMENT'ed value stored for that row.
As many SQL ...
3
votes
1answer
227 views
User autoincrement ID for username
I want to automatically create user's, which all have a unique ID.
Now here's the problem. If two users are created at exactly the same nanosecond, it may not cause problems. Thus, what i do now is:
...
3
votes
1answer
1k views
MySQL get next unique value without auto increment
I have an MySQL database (InnoDB) that I'm developing for tracking Work Orders at my organization. There are multiple 'sites', and each site has work order numbers starting at 100.
WorkorderID ...
3
votes
1answer
372 views
Getting duplicate primary key for auto increment coloumn
I have a MySQL Innodb table with 'id' as auto increment primary key coloumn.
My Scripts are doing following operations:
insert ignore into tablename set x='a', y='b'
update ignore tablename set ...
2
votes
1answer
320 views
Design problem with auto-increment fields
I've made this design similar to my problem, it's not exact but it close enough to understand my problem:
http://i42.tinypic.com/bhbp5.jpg
Some cellular client frequently send their GPS position and ...
4
votes
2answers
2k views
MySQL Auto_increment going 2 by 2
I installed MySQL Workbench the other day, accessed my company's database and made myself a table to work with. So far so good. The problem is, I noticed my auto_increment is incrementing 2 by 2. For ...
3
votes
4answers
5k views
MySQL: Why is auto_increment limited to just primary keys?
I know MySQL limits auto_increment columns to primary keys. Why is this? My first thought is that it's a performance restriction, since there probably is some counter table somewhere that must be ...
3
votes
1answer
2k views
How do I make MySQL auto increment in random order?
I have a table that contains several keys into other tables (where each key is comprised of multiple columns). I would like to create a new column for each key that would be an integer such that ...
