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
70
January 03, 2018 11:35AM
Re: Declare a table as like MS SQL Server
39
January 04, 2018 11:49AM


Sorry, only registered users may post in this forum.

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.