On Nov 8, 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.wises...>- > Hide quoted text - > > - Show quoted text -
No. Autoincrement in MySQL can only be an integer, just like SQL Server and Sybase. I find no method in the MySQL documentation that allows what you want. 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
