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

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

Battle lines over Windows Server 2008 migration drawn

Microsoft and AWS stepped up their ongoing battle promoting a variety of Windows Server 2008 migration tools in hopes of luring ...

Build a PowerShell logging function for troubleshooting

A basic administrative skill is checking over logs to find out why something broke. Learn how to build a proper logging mechanism...

January Patch Tuesday fixes cryptography bug found by NSA

The U.S. National Security Agency shared information with Microsoft about a significant spoofing vulnerability in Windows that ...

SearchServerVirtualization

Explore native and third-party VM automation tools' features

VMware and Microsoft offer native tools that provide VM automation capabilities, but admins should also look at third-party ...

Use multiple Dockerfiles for complex application configuration

Dockerfiles can help with application configurations, but there are some questions you must consider, such as how many ...

An introduction to VMware vRealize Operations Cloud

VMware is set to release a cloud-based management software as a service in 2020, which uses predictive analytics and AI features ...

SearchCloudComputing

5 cloud database comparison tips to guide your data strategy

Catch up on these tips that compare the strengths, weakness and available integrations of popular public cloud database and ...

Reduce cloud latency for remote employees and offices

Latency remains an issue for cloud users with remote facilities. See how SD-WAN and satellites can improve network performance ...

AWS multi-account management best practices with Control Tower

With the help of AWS Control Tower, organizations who own and operate multiple cloud accounts can manage them all under one roof ...

Cascade on updates and deletes

Dig Deeper on Linux servers

Enforcing data integrity in a SQL Server database

MySQL tutorial: Best practices for securing tables, triggers and privileges

Creating triggers to remove users

CASCADE CONSTRAINTS clause for dropping tables

Have a question for an expert?

Start the conversation

0 comments

Please create a username to comment.

-ADS BY GOOGLE

SearchWindowsServer

Battle lines over Windows Server 2008 migration drawn

Build a PowerShell logging function for troubleshooting

January Patch Tuesday fixes cryptography bug found by NSA

SearchServerVirtualization

Explore native and third-party VM automation tools' features

Use multiple Dockerfiles for complex application configuration

An introduction to VMware vRealize Operations Cloud

SearchCloudComputing

5 cloud database comparison tips to guide your data strategy

Reduce cloud latency for remote employees and offices

AWS multi-account management best practices with Control Tower

Related Resources

Dig Deeper on Linux servers

Enforcing data integrity in a SQL Server database

MySQL tutorial: Best practices for securing tables, triggers and privileges

Creating triggers to remove users

CASCADE CONSTRAINTS clause for dropping tables

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.