MySQL Forums
Forum List  »  InnoDB

Re: Declare a table as like MS SQL Server
Posted by: Ra Nala
Date: January 04, 2018 11:49AM

Hi Peter Sir,

Could you please help on this i am not able to get below logic in MySQL database. in the bellow data, i have only data for 5 th and 8th rows i.e. F,5,227 and F,8,121.

that 227 data should repeat for previous record AND 121 data should repeat for previous records.

Before logic

RPRT_ID SER  MODEL 
F 1 null
F 2 null
F 3 null
F 4 null
F 5 227
F 6 null
F 7 null
F 8 121

After logic:
RPRT_ID SER  MODEL 
F 1 227
F 2 227
F 3 227
F 4 227
F 5 227
F 6 121
F 7 121
F 8 121


Kindly help me

Thank you

Options: ReplyQuote


Subject
Views
Written By
Posted
907
January 03, 2018 11:35AM
577
January 03, 2018 01:02PM
Re: Declare a table as like MS SQL Server
875
January 04, 2018 11:49AM
583
January 04, 2018 01:03PM


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.