Alter, Update, Delete, Truncate, Round COMMANDS in SQL, MYSQL
MUST WATCH FULL TUTORIAL NOW FOR ALTER,UPDATE,TRUNCATE,ROUND,DELETE...COMMANDS
MYSQL PART-1 LINK: (Watch Now)
• MYSQL COMMANDS | IN HINDI | EXPERT LECTUR...
Practice Questions for You:
TABLE NAME: SHOP
FIELD NAME: shop_name,sale,area,cust_rating,rating,city
1. select concat(left("DEVELOPERS",3),right("BHARAMDAS",3));
2. select Round(29.21),round(32.76);
3. select round(29.21,1),round(32.76,1);
4. select concat('a','wish','me');
5. Display shopname,rating of shop whose rating is either 'c' or 'a'.
6. Display mumbai city shops.
7. Display area,rating,city of those shops having shop name end with alphabet 'd'.
8. Delete all shops having rating 'c'.
9. Concatenate fields Area and Rating from table shop.
10. Increase sale of all shops by Rs 400.
11. Delete shop who belongs to south AREA.
12. show table structure.
13. count no of records of those shops having rating ‘c’ and area as north.
14. add new column of Stock in above table with character(50) data type .
15. Give stock column a value of Rs 900 where rating is ‘c’.
16. select length(‘DEVELOPERS TECHNOLOGIES’);
BY DEVELOPERS Technologies
AL-148 SHALIMAR BAGH DELHI-110088
The DEVELOPERS Technologies,A Govt Registered Institute, is a well-reputed organization in the field of IT industry is running SINCE 2001. we provide Certificate,Diploma and Advance Diplomas to Students We Trained Students in lot of courses like c, c++,java, .Net, DBMS, PHP , Pythons , Tally, Busy, computer Basics,Net beans, Computer Architecture,VB.Net, FLASH, Advance Excel, Macros, ANDROID lot of other as well.... We have 18 year of experience.and we are well known in North Delhi-shalimar Bagh Area.
you can Also Follow us on:
Facebook Link: / rakesh.prash. .
Facebook Page: / developerste. .
Instagram Link: / rakeshprashar
Email:[email protected]
------------------------------------------------------------------------------------
#developerstechnologies #mysqlclass12 #mysqlclass11