do mysql have sequence like oracle?

[Anon]

in the system variable of oracle.

[[deleted]]

What do you mean by a "sequence" ?

[Anon]

sequence mean like autoincreatment in mysql
but in the memory of oracle cause i will not use
autoincreasement

thanks

[[deleted]]

MySQL does have an auto_increment field type that will automatically generate a new unique number every time you insert a new row.

I'm not sure if that is what you mean though.

[Anon]

Suppose I have a table with these fields,

card_number int(5)
name varchar(30)
number_of_visits int(5)

I want to increment the number_of_visits each time the card_number is used. And there are many card_numbers in the table.
I need an auto_increment for the number_of_visits which is different for each card_number and which should start with 0 or 1 for each card_number.

Thanks
Nitish

[Anon]

manual.html#Getting_unique_ID