I have table t1 and I would like to add a new column app_id with the properties given below
- auto increment
- increment factor(increment by 4)
- min-value/initial value(100)
I have tried
alter table t4 add column app_id int not null auto_increment = 100 ;
but which is not worked.is it possible to add such a column with the properties mentioned above?