Cascade on updates and deletes

Published: 13 Sep 2004

What if I don't want to use InnoDB? Does this mean I can't use cascade on updates and deletes?
FOREIGN KEY constraints (and the ON UPDATE ... CASCADE and ON DELETE ... CASCADE syntax that goes with them) are currently only available for InnoDB tables. While adding FOREIGN KEY constraints to MyISAM tables is on the development roadmap, I would not expect them in the near future. In short, InnoDB is your only choice at the moment.

Dig Deeper on Linux servers

Enforcing data integrity in a SQL Server database Find out how primary keys, foreign keys and constraints can keep your SQL Server data consistent in this excerpt from "A Developer's Guide to Data Modeling for SQL Server, Covering SQL Server 2005 and 2008" by Eric Johnson and Joshua Jones.

MySQL tutorial: Best practices for securing tables, triggers and privileges Take advantage of this set of best practices for MySQL, an open source relational database management system. Learn about the differences between user and local variables, creating triggers to remove users and more in this MySQL tutorial.

Creating triggers to remove users A MySQL expert gives an example of a foreign key and a trigger to use when removing users from tables.

CASCADE CONSTRAINTS clause for dropping tables In your answer to drop all tables with one command you overlooked the relationships between tables. Therefore you would need to add on a CASCADE CONSTRAINTS clause. Would you not?

Preventing changes to the primary key Is there any such thing as ON UPDATE RESTRICT? If not, what is the best way to not allow changes on the primary key?

ON DELETE RESTRICT I would like to know where we use DELETE RESTRICT?

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our Data Center experts

View all Data Center questions and answers

SearchWindowsServer

What admins need to know about Azure Stack HCI

Microsoft put its branding on a relatively new hyper-converged infrastructure offering that capitalizes on the software-defined ...

How to manage Exchange hybrid mail flow rules

Duplicating your existing transport rule collection won't work when you move to an Exchange hybrid deployment. Learn how to set ...

How to repair Windows Server using Windows SFC and DISM

Administrators can diagnose and treat a buggy server operating system by using the Windows SFC and DISM utilities for image ...

SearchServerVirtualization

How to deploy graphics devices using Hyper-V DDA

Admins can map a VM to a GPU with Hyper-V, but they must first complete a few steps, such as prepare the VM and dismount the PCIe...

Learn to integrate VMs and containers in your data center

The VMs vs. containers debate is popular among admins, but integrations of the two technologies have begun to emerge with the ...

Dockerfile commands for containerizing applications

Admins can use Dockerfiles to containerize their applications and ease deployment. They can implement several commands to help ...

SearchCloudComputing

Review these Azure Service Bus best practices

When applications talk, you need to listen. Learn about Microsoft's cloud messaging service, its main features, best practices to...

Instill cloud change management best practices

Automation is essential to change management in the cloud. Discover the best practices that ensure your IT team is in sync and ...

How much cloud does an IT disaster recovery plan need?

It's not easy to get the right mix of traditional and cloud-based DR resources. Here's how to strike a balance between what's ...

Cascade on updates and deletes

Dig Deeper on Linux servers

Have a question for an expert?

Start the conversation

0 comments

Please create a username to comment.

-ADS BY GOOGLE

SearchWindowsServer

What admins need to know about Azure Stack HCI

How to manage Exchange hybrid mail flow rules

How to repair Windows Server using Windows SFC and DISM

SearchServerVirtualization

How to deploy graphics devices using Hyper-V DDA

Learn to integrate VMs and containers in your data center

Dockerfile commands for containerizing applications

SearchCloudComputing

Review these Azure Service Bus best practices

Instill cloud change management best practices

How much cloud does an IT disaster recovery plan need?

Related Resources

Dig Deeper on Linux servers

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.