Reply to thread

Message: <blockquote data-quote="pradeep0079" data-source="post: 10853568" data-attributes="member: 302518">machen uba kiyanne invoice number eka auto generate karanne kohomada kiyalada like 1,2,3 or 00001,0002,0003 is that i will mention some method but this is  for enterprise db  ,i don't remember mysql so you get the concept and impliment on mysqlmethod 1:get the count in invoice table  and increment it by one select count(*)+1 as serial from yourtable this is one method but it has some draw backssecond method: create a index or sequence CREATE SEQUENCE your_seq  INCREMENT 1  MINVALUE 1  MAXVALUE 9223372036854775807  START 1  CACHE 1;ALTER TABLE your_seq OWNER TO enterprisedb;using sequence you can do it two ways 1.use it in your insert query like  insert into your_table(column names) values (,,,,,your_seq.nextval)2. use a stored procedure to generate patterned serial    function fc_get_ordernoreturn varchar is begin return lpad(seq_your.nextval,4,0);end;this will return a number like 0001,00023.use a sepearte table for sequence create a tabe with columns srial_name,serial_vale with varchar ,numberthen in your code get the serial_vale +1 from your table after you have to update it let say you have 30 in your serial_value then you get 31 then you have to update 31 as your serial value but remenber you have to handle concurrency in your code and db otherwise this will  be a messi recommend 2 method since db handle the concurrency and i most used it</blockquote>

Verification: Hathara warak wissa keeyada? (Hathara wadi karanna 20)

Top Bottom

Search

Latest ads

Reply to thread