write the SQL commands to answer the queries based on fabric table:
__________________________
FabID- Fname- Type- Disc-
-------------------------------------------------
F01. shirt. woolen. 10
-------------------------------------------------
F02. suit. cotton. 20
-------------------------------------------------F03. tunic. cotton. 10
-------------------------------------------------
F04. jeans. denim. 5
__________________________
a) to insert the following record ("F005", "Kurta", " woollen" ,5 )
b) to display only those fabric who disc is more than 10)
c) to display those record whose type is "woolen".
d) to modify the fabric shirt by increasing the discount of 10.
e) to delete the record of fabric F003 from the table.(IT vocational)
please answer this question correctly.......
LuckyYadav2578:
dear i m not able to understand what is meant by IT vactional
vocational*
From where do you find this answers.?
i didnt find it ... i self did it
i know mySQL
Hi
hlo
Insert into Fabric table
(Fabric ID ,Fname,Type,Disc).
Values (F005,Kurta, Woollen,5);
Answers
Answered by
409
SQL commands :-
a) insert into fabric values ("F005", "Kurta", " woollen" ,5 );
b) select fname from fabric where disc>10;
c) select * from fabric where type ="woollen" ;
d) update fabric set disc= dics+ disc * 10/100 where fname="shirt" ;
e) delete from fabric where fabid=F03 ;
● I hope its help ☆☆ :)
a) insert into fabric values ("F005", "Kurta", " woollen" ,5 );
b) select fname from fabric where disc>10;
c) select * from fabric where type ="woollen" ;
d) update fabric set disc= dics+ disc * 10/100 where fname="shirt" ;
e) delete from fabric where fabid=F03 ;
● I hope its help ☆☆ :)
Thnx lucky
its my pleasure dear bro :)
First part is not correct
dear it is correct i have done practical in mysql by checking it
you can also wtite it like ... insert into fabric ( ' fabid', 'fabname', 'type', 'disc',) values ("F005", "Kurta", " woollen" ,5 )
Both are correct .... you can check by doing practical
Hlo i have a doubt in this ans
Its ok. I got the ans
wt is fname
fname is fabric name
Answered by
130
Hi bro your answer is below...
SQL commands :-
a) insert into fabric values ("F005", "Kurta", " woollen" ,5 );
b) select fname from fabric where disc>10;
c) select * from fabric where type ="woollen" ;
d) update fabric set disc= dics+ disc * 10/100 where fname="shirt" ;
e) delete from fabric where fabid=F03 ;
● I hope its help ☆☆
Similar questions