#Delete mysql how to

DELETE sp, sc FROM student_personal_details sp

Observe the below query for the solution. Example 2:-ĭelete the rows from both the tables student_college_details and student_personal_details, which have the same student_id. Output in image_4 shows that only the rows that do not have common student_id got retained in the table student_personal_details rest got deleted. We can verify the deletion by looking into the snapshot of student_personal_details. Student_college_details sc ON sp.student_id = sc.student_id DELETE sp FROM student_personal_details sp Similarly, if we want to delete only the rows from student_personal_details with the same student_id as in student_college_details, we can execute the below query. Output in image_3 shows that only the rows that do not have common student_id retained, and the rest got deleted. Let us now verify if the rows with common student_id were deleted from table student_college_details by executing: SELECT * FROM student_college_details In the query, we are deleting only the records from student_college_details as it says delete sc (an alias for student_college_details). The query has applied an inner join on the tables student_college_details and student_personal_details. Those should be the six rows with common student_id from value 1 to 6. It shows 6 rows are affected, which means 6 rows got deleted. Student_personal_details sp ON sc.student_id = sp.student_id DELETE sc FROM student_college_details sc JOIN Table3 ON lumn_name2 = lumn_name2ĭelete the rows from the table student_college_details that have the same student_id as in student_personal_details. Output:- image2: student_personal_detailsĪs we can see in image_1 and image_2, there are some rows with common student_id and some different ones. SELECT * FROM student_college_details Īdvertisements image1: student_college_details SELECT * FROM student_personal_details Let us have a view of the snapshot of both the tables. INSERT INTO student_personal_details(student_id,student_name,student_ssn_no)

INSERT INTO student_college_details(student_id,student_college_name) We will be creating two tables and inserting some rows into them. Let us get started by making the sample data to be used across. Generally, DELETE with JOINS is used when we want to delete rows from one or more tables related to each other and through a specified column and a condition. Delete with join for specific conditions in Example3.Delete multiple tables with join in Example2.

#Delete mysql how to

In this article, we will see how to delete the rows from MySQL tables associated with joins particularly,