DELETE, TRUNCATE & DROP Command | MySQL Subquery | #subquery #truncate #drop #delete

Truncate Table Command
Difference between DELETE, TRUNCATE & DROP Command
=======================================================
MYSQL SERIES

1. Learn about What is Data? What is a Database? What is DBMS? How to Install MySQL Workbench :

2. Learn about MySQL Commands: Create, Insert, Select :

3. Learn about DELETE Query | ORDER BY Clause in MySQL:

4. Learn about Group By query in MySQL | Having Clause

5. Learn about Wildcard in MySQL| Aggregate Function in Mysql| Distinct Keyword in Mysql :

6. Learn about Null as a Value and as a Keyword in Mysql | Alter, Drop and Rename Queries :

7. Learn about DDL, DML, DCL Statements :

8. Learn about Keys in MySQL -Super, Candidate, Primary, Alternate, and Unique Key :

9. Learn about Defining Keys in MySQL :

10. Learn about Joins in MySQL :

==========================================================
SELENIUM SERIES

1. Learn about Selenium Webdriver Basics, Java, Eclipse and Selenium Jar files Installations:

2. Learn about Selenium IDE :

3. Learn about What is Selenium | Features & Uses of Selenium | Architecture of WebDriver :

4. Learn about What are Selenium Locators :

5. Learn about Handling Pop-ups in Selenium :

=====================================================
JIRA SERIES

1. Learn about What is Jira here :

2. Learn about Jira Terminologies :

3. Learn about What is Project, What is Epic, What is User Story, What is Task, and What is Sub-task :

4. Learn about Issue Workflow in Jira :

5. Learn about How to create Issues in Jira :

6. Learn about What is Story Points in Jira | How to Create a Team in Jira | How to add comments to an issue :

=======================================================
Manual Testing Series 1

1. Learn about SDLC here, click on the link below:

2. Learn about STLC here, click on the link below:

3. Learn about SDLC vs STLC here, click on the link below:

4. Learn about Waterfall Model here, click on the link below:

5. Learn about V Model here, click on the link below:

6. Learn about Spiral Model here, click on the link below:

7. Learn about Agile Model here, click on the link below:

8. Learn about the Roles & Responsibilities of a Tester, click on the link below:

9. Learn about the Phases of Testing, click on the link below:

10. Learn about the Types of Testing, click on the link below:

11. Learn about Test Estimation & Planning, click on the link below:

12. Learn about Test Case Development, click on the link below:

13. Learn about Bugs in Testing, click on the link below:

14. Learn about Bug Life Cycle in Testing, click on the link below:

15. Learn about the Priority & Severity of a Bug in Testing, click on the link below:

======================================================
Connect with me :