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

No, you can't. Not out of the box. Possible workarounds:

-
Triggers (an AFTER INSERT trigger).

Disadvantages:

• Plain horror. Comes with all the other disadvantages of triggers, like maintenance and debugging nightmares.

Advantages:

• You can have FOREIGN KEY constraints that reference this column.

• You can update the first and the second id columns individually.

-
Views. If you only a value that is always +4000400 of the first auto incremented value, you can use a view, so basically not store this value at all, just calculate it when you need it:

CREATE VIEW 
        tablex_with_2nd_AI AS
    SELECT 
        tablex_id,
        colA,                                 -- other columns
        --                                    -- you need
        tablex_ix + 4000400  AS second_id
    FROM 
        tablex ;

Disadvantages:

• You can't have a FOREIGN KEY constraint that references this (virtual) column.

Advantages:

• Saves some space. Slightly faster inserts.

-
Don't do that, don't have a second auto incremented column at all. Do you really need a second auto incremented value? What for? A description of the actual problem you are trying to solve would help others help you better. I think you have only told here how you tried to solve a problem and not what the actual problem is.

StackExchange Database Administrators Q#35449, answer score: 6