MYSTERY ZILLION တွင် English သို့မဟုတ် Unicode ဖြင့်သာ အသုံးပြုခွင့်ရှိသည်။ ဇော်ဂျီ ၊ ဧရာ စသည်တို့ကို အသုံးပြုခွင့် မရှိ။ Unicode fonts များမှာ Mon3,Yunghkio, Myanamr3 စသည်များ အသုံးပြုနိုင်သည်။ Unicode Guide ကို ဒီမှာ Download ချပါ။ Zawgyi to Unicode Converter
Don't share ebook or software if nobody request. You can find free book websites on here. We are welcome for discussion or asking question instead.

How to delete rows from multiple tables

edited October 2011 in Help Desk
Hi, I have three tables
person>>>
p_id(pk)
p_name
p_dob

company>>
c_id(pk)
c_name
p_id(fk)

contact>>
contact_id(pk)
city
country
p_id(fk)

I want to delete a person,his related company and contact.
Please post the query to perform this action. And is there any technique that when I delete a row from parent table, automatically delete rows from child tables. I use mysql 5.1.56. Thanks
Tagged:

မှတ်ချက်များ

Sign In or Register to comment.