MySQL Forums
Forum List  »  Newbie

Re: how to select numbers (integers) only?
Posted by: Phillip Ward
Date: July 17, 2014 06:17AM

Looks to me like a case of having two data items in the same field. Bad Idea.
But anyway ...

Why do you need the largest value?
Are you using it to allocate new Employee Numbers? If so, create another table that holds the last number allocated and use that instead.

(Warning: Air-code)

select * 
from  last_employee_number ; 

   +-----------------+ 
   | employee_number | 
   +-----------------+ 
   |              77 | 
   +-----------------+ 

begin transaction ; 

update  last_employee_number 
set     employee_number = employee_number + 1 ; 

select  employee_number 
into    :eNumber 
from    last_employee_number ; 

insert 
into    employee( employee_number, . . . 
values  ( :eNumber, . . . )

commit ;

Regards, Phill W.

Options: ReplyQuote


Subject
Written By
Posted
Re: how to select numbers (integers) only?
July 17, 2014 06:17AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.