How to truncate a foreign key constrained table

The truncate function in SQL deletes all table data. However when your database has foreign key constraints this will give an error. In this tutorial, we'll cover how to TRUNCATE a table with foreign keys.

Please note that this is not advisable if your website is already in production, so ONLY do it if you're sure it will not compromise the integrity of your data.

If you're using phpMyAdmin simply uncheck/disable the 'Enable foreign key checks' checkbox as shown below:

Alternatively, you could use the following SQL command.


SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE my_table_name;
SET FOREIGN_KEY_CHECKS = 1;

I hope you found this helpful

Comments

How to easily create background notifications in Sketchware(original)

How to easily create background notifications in Sketchware(original) One of the keys to building a successful app is to find mechanisms that will keep your users engaged. You can do this by using background notifications. This tutorial will show you how to do that in Sketchware. We will cover: 1. How to create notifications in Sketchware 2. How to show these notifications even when the app is closed.

Happy Birthday Memes: Laugh Your Way to Someone's Heart

Happy Birthday Memes: Laugh Your Way to Someone's Heart Introduction Birthdays are a special occasion to celebrate another year of life, and what better way to do it than with a good laugh? That's where happy birthday memes come in! These hilarious images are the perfect way to put a smile on someone's face and let them know you're thinking of them on their special day. Why Memes Are the Best Birthday Greetings * Relatable: Memes often tap into universal experiences and emotions, making them instantly relatable to a wide audience. * Quick and Easy: Sharing a meme is a hassle-free way to send birthday wishes, perfect for those last-minute greetings. * Memorable: A funny meme is more likely to stick in someone's mind, making your birthday wishes unforgettable. * Versatile: There's a meme for every type of person and occasion, from silly and goofy to heartfelt and sentimental. How to Use Happy Birthday Memes * Share on Social Media: Spread ...

Cybersecurity Essentials: How To Stay Safe On The Internet

Hi there, my name's Likhwa and welcome to Building Africa's Next Tech Unicorn. on this platform I give a behind the scenes look at what it takes to build a startup within the African context. In today's video, I'll be doing something different- I'll be talking about how you can stay safe online. This isn't meant to scare you or get you all paranoid, but to help you be more vigilant in protecting yourself and your loved ones from cyber threats. Most people underestimate the dangers of the internet, but the more I am exposed to it, the more I wish I didn't need it. At times I wish I could just disconnect, get rid of all my devices and not have to worry about the constant threats that come with being online. I believe some of us are fortunate by default- especially those who live in countries like my Zimbabwe- because we hardly use credit cards to transact online and even when we do, its not like we have a lot of money- otherwise we would be a hacker's g...

Likhwa Tech

Search This Blog