Skip to main content

How to truncate a foreign key constrained table

Ths 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:

Enable foreign key check checkbox

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

Popular posts from this blog

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. We will start by creating a new project. If you do not know how to create a new project please check out this article here. Once we have created our project, let us create a more block to place our code. Navigate to the events menu and then to the moreblock section as shown in the image above. Create a moreBlock. I have created a moreblock with the name "BackgroundActivity" with a boolean variable named "run." See the image below for how to add the boolean variable. Place the following block in the moreBlock Background activity code: moveTaskToBack(_run); That will move our task to the background.  Please note, that at this point we have

Building game apps in Sketchware

Last week I gave a tutorial on how to create a quiz app using Sketchware. Maybe you want to create a more complex game and that is possible using Sketchware. Today we will be looking at creating more complex games such as an endless runner, car racing or any animated game. You could even create a 3D game but that is of you can create the graphics.      The first step is deciding what kind of game you want to create. This starts with the objective of the game, how the user will earn points, the various levels as well as customizations and upgrades. Once you have the concept you can then start building your app. This tutorial will show you how to create a game app like the one in the video below. Still needs work but I hope you get the idea. What you will need For a simple game app, you will need the following:  1. A sprite sheet These are images of your various characters e.g. it can be a happy face, sad face, angry face and so on. If it's a runner, you can have them at rest and th

How to save data to local storage in Sketchware

At some point you might want your users to be able to save or store data for later use. This might be when a game is paused or when recording information.  There are two ways to save data in an app. One is using the Shared preferences component which saves data in the user's device storage or using online storage such as Firebase database or Firebase storage 1. Shared Preferences This saves data on the user's device or phone memory and thus it is also referred to as 'saving to local storage.' This means that when the User deletes the App, then that data is also lost. 2. Firebase Database/Storage This saves the User data on a central database managed by Google but under your control. Just like your email. This data remains in your database when a user deletes the App. It is also the platform from which messages are stored and received when chatting.  Tutorial For today's tutorial we will save data to Shared Preferences Step 1 Add an *edittext* widget to your app.  Ch