« previous next »
Pages: [1]

Author Topic: query help Please  (Read 821 times)

0 Members and 1 Guest are viewing this topic.

Offline memilanTopic starter

  • Irregular
  • Posts: 3
    • View Profile
query help Please
« on: February 04, 2009, 11:19:11 PM »
how can i delete the child table data viewing  the Key not present in parent table
Logged

Offline killah

  • Enthusiast
  • Posts: 234
    • View Profile
Re: query help Please
« Reply #1 on: February 04, 2009, 11:24:47 PM »
Your question is unclear to me. Explain it a little bit more please.
Logged

Offline peddel

  • Enthusiast
  • Posts: 107
    • View Profile
Re: query help Please
« Reply #2 on: February 05, 2009, 03:39:16 AM »
I guess u want to have the child data deleted when u delete parent data.

I know how to do this trough phpMyAdmin by using a foreign key relationship with a cascade delete.

Just google on "MySQL CASCADE DELETE" and you will find answers, if it is this u seek :P
Logged

Offline memilanTopic starter

  • Irregular
  • Posts: 3
    • View Profile
Re: query help Please
« Reply #3 on: February 05, 2009, 05:42:34 AM »
I have delete the parent data and i havenot defined foreign key relationship so i have to delete the data from child table Viewing the specific Key which not Present in parent table and the Platform is "FireBird"
Logged

Offline aschk

  • Staff Alumni
  • Devotee
  • *
  • Posts: 1,243
    • View Profile
Re: query help Please
« Reply #4 on: February 05, 2009, 06:46:52 AM »
If this is the firebird db then you have posted the question in the wrong forum...
Logged
Pages: [1]
« previous next »