Re: Declare a table as like MS SQL Server

[Ra Nala]

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