Why are you asking a MYSQL question on an Oracle PL/SQL mail list?
On Tue, Nov 8, 2011 at 12:59 PM, VIGNESH PRAJAPATI <vignesh2...@gmail.com>wrote: > ok thaks ..But if i want to do this in MYSQL than any idea? > > > On Wed, Nov 9, 2011 at 2:22 AM, ddf <orat...@msn.com> wrote: > >> >> >> On Nov 8, 12:36 pm, VIGNESH PRAJAPATI <vignesh2...@gmail.com> wrote: >> > We know that id of any table is of integer type and auto-increment in >> that >> > table is fine. But my problem is that i want to increment a combination >> of >> > string and integer. For example String : ABC is the starting code for >> the >> > unique id. >> > >> > First Id of my table should be primary key and >> > >> > ie ABC10001, ABC10002,..... and so on. >> > >> > Without using another key as auto-increment. Please do not use two type >> of >> > unique key. >> > >> > -- >> > >> > *Vignesh Prajapati* >> > Tel: 9427415949 | >> > vignesh2...@gmail.com |www.vipras.com.co.in >> > MYTK [image: Facebook] <https://www.facebook.com/vigs143> [image: >> > Twitter]<http://twitter.com/#%21/vigs143> [image: >> > LinkedIn] <http://www.linkedin.com/pub/vignesh-prajapati/37/756/46a> >> [image: >> > about.me] <http://www.way4fun.tk>< >> http://r1.wisestamp.com/r/landing?promo=7&dest=http%3A%2F%2Fwww.wises...> >> >> This is an Oracle group , not Sybase or SQL Server, so the >> 'autoincrement' mechanism is far different. It is possible to use a >> sequence value with a string to create a character-based, auto- >> incrementing primary key: >> >> SQL> create table keytest( >> 2 mykey varchar2(40) not null, >> 3 mydata varchar2(100), >> 4 constraint keytest_pk >> 5 primary key (mykey) >> 6 ); >> >> Table created. >> >> SQL> >> SQL> create sequence myseq >> 2 start with 1 increment by 1 nocycle nomaxvalue; >> >> Sequence created. >> >> SQL> >> SQL> create trigger pop_key >> 2 before insert on keytest >> 3 for each row >> 4 begin >> 5 select 'ABC'||lpad(myseq.nextval,10,'0') >> 6 into :new.mykey >> 7 from dual; >> 8 end; >> 9 / >> >> Trigger created. >> >> SQL> >> SQL> >> SQL> begin >> 2 for i in 1..10 loop >> 3 insert into keytest >> 4 (mydata) >> 5 values >> 6 ('This is record number '||i); >> 7 end loop; >> 8 >> 9 commit; >> 10 >> 11 end; >> 12 / >> >> PL/SQL procedure successfully completed. >> >> SQL> >> SQL> select * from keytest order by 1; >> >> MYKEY MYDATA >> ---------------------------------------- >> >> ---------------------------------------------------------------------------------------------------- >> ABC0000000001 This is record number 1 >> ABC0000000002 This is record number 2 >> ABC0000000003 This is record number 3 >> ABC0000000004 This is record number 4 >> ABC0000000005 This is record number 5 >> ABC0000000006 This is record number 6 >> ABC0000000007 This is record number 7 >> ABC0000000008 This is record number 8 >> ABC0000000009 This is record number 9 >> ABC0000000010 This is record number 10 >> >> 10 rows selected. >> >> SQL> >> >> >> David Fitzjarrell >> >> -- >> You received this message because you are subscribed to the Google >> Groups "Oracle PL/SQL" group. >> To post to this group, send email to Oracle-PLSQL@googlegroups.com >> To unsubscribe from this group, send email to >> oracle-plsql-unsubscr...@googlegroups.com >> For more options, visit this group at >> http://groups.google.com/group/Oracle-PLSQL?hl=en >> > > > > -- > > *Vignesh Prajapati* > Tel: 9427415949 | > vignesh2...@gmail.com | www.vipras.com.co.in > MYTK [image: Facebook] <https://www.facebook.com/vigs143> [image: > Twitter]<http://twitter.com/#%21/vigs143> [image: > LinkedIn] <http://www.linkedin.com/pub/vignesh-prajapati/37/756/46a> [image: > about.me] > <http://www.way4fun.tk><http://r1.wisestamp.com/r/landing?promo=7&dest=http%3A%2F%2Fwww.wisestamp.com%2Femail-install%3Futm_source%3Dextension%26utm_medium%3Demail%26utm_campaign%3Dpromo_7> > > -- > You received this message because you are subscribed to the Google > Groups "Oracle PL/SQL" group. > To post to this group, send email to Oracle-PLSQL@googlegroups.com > To unsubscribe from this group, send email to > oracle-plsql-unsubscr...@googlegroups.com > For more options, visit this group at > http://groups.google.com/group/Oracle-PLSQL?hl=en > -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
