MySQL Forums
Forum List  »  InnoDB

Re: Declare a table as like MS SQL Server
Posted by: Ra Nala
Date: January 04, 2018 01:03PM

Sorry Sir, here is the info.

create table rprt_def_war
(rprt_id int,
ser varchar (50),
model varchar (50),
p_nm varchar (50)
)
;

insert into rprt_def_war(ser,model,p_nm) values ('F',1,NULL)
insert into rprt_def_war(ser,model,p_nm) values ('F',2,NULL)
insert into rprt_def_war(ser,model,p_nm) values ('F',3,NULL)
insert into rprt_def_war(ser,model,p_nm) values ('F',4,NULL)
insert into rprt_def_war(ser,model,p_nm) values ('F',5,227)
insert into rprt_def_war(ser,model,p_nm) values ('F',6,NULL)
insert into rprt_def_war(ser,model,p_nm) values ('F',7,NULL)
insert into rprt_def_war(ser,model,p_nm) values ('F',7,121)

current results

rprt_id ser model p_nm
---------- ------ -------- -------
(null) F 1 (null)
(null) F 2 (null)
(null) F 3 (null)
(null) F 4 (null)
(null) F 5 227
(null) F 6 (null)
(null) F 7 (null)
(null) F 7 121

Expecting results

rprt_id ser model p_nm
---------- ------ -------- -------
(null) F 1 227
(null) F 2 227
(null) F 3 227
(null) F 4 227
(null) F 5 227
(null) F 6 121
(null) F 7 121
(null) F 7 121

Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
907
January 03, 2018 11:35AM
577
January 03, 2018 01:02PM
875
January 04, 2018 11:49AM
Re: Declare a table as like MS SQL Server
582
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.