mysqlstored-procedurescascading-deletes
Delete data in Mysql data base table
How can I delete data form a table with out delete other table data?
Is that possible Null value for foreign key in MySql data base table?
I want to delete one Department without delete other tables data like (shifts, remote_login_id, skills). This my data base ERD. How will I do this?
Solution
When you define the foreign key you can choose between SET NULL and CASCADE.
CASCADE deletes all records that holds reference to the deleted row.
SET NULL set's the foreign key column to null wherever it referenced the deleted record. For this to work you need to make sure that that column allows null or it won't work.
http://dev.mysql.com/doc/refman/5.5/en/innodb-foreign-key-constraints.html
- How to import database inside dockerfile?
- MySQL NOT IN () does not exclude wenn connecting 2 Tables
- How to force an event to execute in MySQL
- pip install mysqlclient returns "fatal error C1083: Cannot open file: 'mysql.h': No such file or directory
- Can't manage to make multiple averages with SQL
- MySQL Match Against with Multiple Values to AGAINST
- import mysql database to wamp server
- Convert Unix timestamp into human readable date using MySQL
- mysql query optimization steps or how to optimze query
- PHPMyAdmin Configuration not working because of MySQL user password?
- UTF8 MySQL problems on Rails - encoding issues with utf8_general_ci
- How to update "updatedAt" manually?
- How to SELECT the last 10 rows of an SQL table which has no ID field?
- Selecting data from table based on date
- maxscale cannot find gtid_binlog_pos
- MySQL SUM of one column, DISTINCT of ID column
- Deleting records before a certain date
- Sort MySQL query data by calculated values
- How to view/identify which process taking how much memory?
- Bad Sql Grammar exception in JDBC spring
- How to unblock with mysqladmin flush hosts
- Laravel implode function on images array
- How to save a query result set as an array?
- MySQL pivot table query with dynamic columns
- CASE query to get results from different tables
- How do i cast char to integer while querying in django ORM?
- MySQL Workbench wrong configuration file path
- How to populate a flat associative array while looping query results?
- Should I create 2 tables: first for usernames and passwords, and other for user information like dob, name, etc?
- Mysql Error throw An alias was previously found