Making An Auto Increment As Sequence

[anggwaponi]

---

hello to each and everyone ..

the table i created has no define PRIMARY KEY, INCREMENT, UNIQUE, & Constraints.

i would like to ask our very-well knowledgeable Moderator(s) and to our guest to assist me again in my self-learning activities.

my table has already been created. in fact, it has now some data which i was able to refine its view or contents.

now, how can i make the column P_Id to be on its increment value ... what are the command(s) or syntax? its like it has 10-data but only numbered from 1 to 8. i didn't put or included the number 9 and 10 when i inserted new data since i want it that if add or change, i can do it in 1-single move ..

P_Id LName FName Address City zipcode Country


hoping to be guided accordingly.


cheers!

[moz_k2]

you can use the AUTO_INCREMENT keyword
just google how to use it with alter table

By the way naa pud serial datatype AKA auto increment type

[unretry]

what database are you using?

[spikes]

If you are using DB2 you can I think configure the column to use an auto increment. If you are using oracle, you can create a sequence, then assign the value of the sequence to the column P_Id.

to create sequence in oracle

   create sequence ID_SEQ increment by 1 start with 1;

to use the sequence during insert

 insert into table1 values(ID_SEQ.nexval,'field1','field2'....);

[UtOkbOlinAO]

QUESTIONS FOR TS:

1st... unsa imong database nga gigamit?
2nd.. asa nimo gusto e.apply ang syntax?
front end or back end?

[anggwaponi]

you can use the AUTO_INCREMENT keyword
just google how to use it with alter table

By the way naa pud serial datatype AKA auto increment type

hi all

i'm not familiar with databases but part of it says phpMyAdmin.

likewise, i want to issue the command or apply the syntax in Run SQL query/queries on database.

and both of it can either be its on front-end or back-end also.

i try to google on using ALTER TABLE but seems i'm confuse of many possible answer ... any simple one.


thanks,

cheers!

[anggwaponi]

@ dlanyer77

The correctness of our response to your query is likely related to the ambiguity of the content in your original post. For example, do you have existing data or what's your database?

If you mean something else, perhaps be more specific next time bro

hello

sorry that some of my post looks or sounds they're inter-change. actually, as of now ... most of them are related. it just happened that when i build my dB or Table, i have no specific criteria if ever to expand it. i did just do it for practice and as it goes as i read the tutorial.

any way, thanks really for reminding me.

on the other hand, any idea(s) also of this another inquiries of mind [hi Moderator(s)]?


cheers!