Phpmyadmin sql deleting all tables in help table

I have two tables with cascade. When I do this query it deletes the correct row in main table but deletes many rows in the help table. The help table connects to ansatt table.

DELETE FROM `hvertirsdag` WHERE tid='15:06' AND dato='11.03.2014'

hvertirsdag (main table):

Ansatt_htirs (help table)

Answers


write it as

DELETE FROM `hvertirsdag` WHERE `tid` ='15:06' AND `hvertirsdag`.`dato`='11.03.2014'

Need Your Help

Java: How to get the thumbnail from a file

java file swing thumbnails

In windows explorer (and linux gnome) shows for each file a thumbnail or icon. Like with EXEs, images, videos, txt-files, ini-files, Word documents and so much other file types. Now is my question:...

How to use less with php

php css wordpress styles less

i'm using wordpress and i would like to be able to change all the same color of my website by changing one php function on my admin panel.