GK SCIENTIST

General Knowledge One Stop Source
Menu
  • Home
  • Social Science
    • History
    • Political Science
    • Geography
  • Science
    • Physics
    • Chemistry
    • Biology
  • Chemistry Notes
  • Mathematics
  • Computer
  • Tutorial MySQL
  • Tutorial Python
  • Java Tutorial
  • English Grammar
  • English Essay
  • Indian Anthropology
  • Philosophy
  • Solved Paper
  • UPSC
  • Current Content
    • Current Affairs
    • RSTV News
    • Yojana and Kurukshetra Gist
  • Donate
  • Contact Us

If you are interested in advertising to our audience, submit the advertising enquiry form.

Advertising Enquiry
Computer

MySQL Delete Query

Gk Scientist November 16, 2022 No Comments
Tweet WhatsApp Telegram

MySQL Delete Query:

There are times when some data is not needed any longer and may even pose problems by remaining in the database. To discard unwanted data from a database, we will use the DELETE Query, which allows you to delete one or more records in a table: The Syntax of MySQL Delete Query is:

DELETE FROM table_name [WHERE Clause]

The DELETE Query deletes the rows from table_name and returns the number of rows deleted. The WHERE clause is used to specify the conditions that identify which rows to be deleted. If the DELETE Query contains without a WHERE clause, all rows will be deleted.

Sample Table:

MySQL Sample Table for Delete Query - MySQL Delete Query

Example 1: Delete 3rd StudentId from the table.

MySQL Delete Query Example - MySQL Delete Query

Example 2: Delete the 7th, 8th, and 9th StudentId from the table.

MySQL Delete Query Example to delete multiple rows - MySQL Delete Query

Natural Language Processing (NLP)- Complete Introduction
MySQL Limit and Offset Clause
MySQL Order By and Distinct Clause
MySQL Between and Not Between Operators
MySQL Select Query with Where Clause
MySQL– Wikipedia
Prev Article
Next Article

Related Articles

How to Create List in Python
Create List in Python: We can use the PyCharm code …
Gk Scientist November 27, 2022 Computer

How to Create List in Python

Python Conditional Statements
Python Conditional Statements: We can use the PyCharm code editor …
Gk Scientist November 24, 2022 Computer

Python Conditional Statements

Careers in Information Technology (IT)
Careers in Information Technology: Information Technology as the name suggests …
Gk Scientist October 22, 2022 Computer

Careers in Information Technology (IT)

Java Wrapper Classes
Java Wrapper Classes: We can use the Eclipse IDE for …
Gk Scientist January 5, 2023 Computer

Java Wrapper Classes

Operating System (OS)
What is an Operating System? It is an important system …
Gk Scientist October 9, 2022 Computer

Operating System (OS)

Dictionary in Python
Dictionary in Python: We can use the PyCharm code editor …
Gk Scientist November 29, 2022 Computer

Dictionary in Python

Python Constructors
Python Constructors: We can use the PyCharm code editor for …
Gk Scientist December 5, 2022 Computer

Python Constructors

Java Method Overriding
Java Method Overriding: We can use the Eclipse IDE for …
Gk Scientist January 10, 2023 Computer

Java Method Overriding

Leave a Reply Cancel Reply

Search




  • Popular
  • Recent




GK SCIENTIST

General Knowledge One Stop Source

Information

  • About Us
  • Terms and Condition, Disclaimer
  • Contact Us

Android Apps

  • IAS App For English Medium Students
  • IAS Basics App For English Medium Students
  • IAS Hindi App For Hindi Medium Students
DMCA.com Protection Status

Popular Tags

Biology (33) Biology Questions (88) Chemistry (57) Computer (213) Current Affairs (4) Current Content (0) Economy (10) English Essay (172) English Grammar (75) English Literature (10) Geography (83) History (259) Indian Anthropology (11) Indian Polity (14) JKAS Mains Question Papers (17) Mathematics (68) Moral Science (7) NCERT & Other Boards Books (25) Philosophy (114) Physics (89) Political Science (132) RS TV News (33) Science (553) Social Anthropology (7) Social Science (17) Solved Paper (47) UPSC (7) UPSC Mains Question Papers (26)

Downloads

  • NCERT Books
  • Old NCERT Books
  • NIOS Books For IAS, SSC, and State PSC Exam
  • Tamil Nadu Board Books: Important For UPSC, SSC, and State PSC Exam
  • Modern Indian and World History Notes For IAS Exam
  • UPSC Topper 2013 Gaurav Agrawal Notes For IAS Preparation
  • UPSC IAS Prelims General Studies – Previous Year Papers
  • UPSC Mains Question Papers

Copyright © 2023 GK SCIENTIST
Theme by MyThemeShop.com& Hosted On Cloudways

Ad Blocker Detected

Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker.

Refresh
 

Loading Comments...