mysql auto_increment

amrigo

I have a mysql table with an auto_increment field . how can i reference in the insert statement to increase the field in the rigth order?

Also i have another field where i do need to record an unique sequence of numbers but i could not set to auto Increment because it already exists

How can it be done?

Thanks

calua

i didn't quite understand what you meant on your second question, but, for the first, i think you just leave the auto-increment field blank on the insert statement.

ex:

if the table cats has an auto-increment field called id, just put:

insert into cats ( name, age ) values ( 'Thomas', 6 );

and id for thomas will be equal the id before it plus one.

is that it?

caluã

amrigo

yes the same thing that nextval means to postgresql

i just have to leaveit blank rigth!

i have two tables where the second table must have a foreign key to a field on the first table but i did not could create the second table using phpmyadmin

Do you have any example of doing this with phpmyadmin?

calua

well, i don't know phpmyadmin, but i supose you can just put something like

create table table2 (id int(11) NOT NULL UNIQUE auto_increment,

...

                         id_table1 int(11) NOT NULL,

                         PRIMARY KEY (id),

                         FOREIGN KEY (id_table1)      
                                 REFERENCES table1
                       )

i didn't quite understand 😕 if you already have this second table created or if you couldn't create it; anyway, hope this helps

caluã

amrigo

i do it by createing then altering the table on the query window of phpmyadmin

Thank´s a lot