RE: RE: what is the proper way to store timezone information?

Boyd, Todd M. wrote: My concern is whether the time_zone_id is a fixed reference of the timezone. If the id might (for whatever reason) change in the future, I'd have to store the timezone name. http://dev.mysql.com/doc/refman/5.1/en/time-zone-support.html You can convert back and forth

delete a data from 3 tables

hi,   I would like to know how to delete a data from 3 table which is interconnected with each other by foreign key. i.e 1st table is connected with 2nd table by foreign key and 2nd table is connected with 3rd table with foreign key. please help to solve this problem.   Thanks chandra  

Re: delete a data from 3 tables

Chandra N schrieb: hi, I would like to know how to delete a data from 3 table which is interconnected with each other by foreign key. i.e 1st table is connected with 2nd table by foreign key and 2nd table is connected with 3rd table with foreign key. please help to solve this problem. What

RE: delete a data from 3 tables

Hi Please let us know the table structures of all. Thanks Regards, Dilipkumar -Original Message- From: Sebastian Mendel [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 17, 2008 1:22 PM To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: Re: delete a data from 3 tables Chandra

R: delete a data from 3 tables

I think the best way is to modify the FOREIGN KEY definition in the tables 1 and 2 adding the 'ON DELETE CASCADE' condition. ALTER TABLE 1 ADD FOREIGN KEY (fkCol) references 2(pkCol) on DELETE CASCADE; ALTER TABLE 2 ADD FOREIGN KEY (fkCol) references 3(pkCol) on DELETE CASCADE; Aloha!

delete a data from 3 tables

hi all   I created 3 tables namely authen_tbl,profile_tbl,astro_tbl,in which column name mail  as primary key in authen_tbl table , query:  pid int primary key auto_increment,  foreign key (mail) references authen_tbl(mail) given in astro_tbl table and query foreign key(pid) references

Re: delete a data from 3 tables

Hi, I created 3 tables namely authen_tbl,profile_tbl,astro_tbl,in which column name mail as primary key in authen_tbl table , query: pid int primary key auto_increment, foreign key (mail) references authen_tbl(mail) given in astro_tbl table and query foreign key(pid) references profile_tbl(pid)

R: delete a data from 3 tables

Hi Chandra, you have two possible situations: Case (A) you can delete 'astro_tbl' rows with NO particular actions Case (B1) you must alter 'astro_tbl' table adding a cascade costraint to have the system delete rows in the 'astro_tbl' table when one row in 'authen_tbl' table is being deleted if

Migration of mysql 3.23.32 from Tru64 to RHEL 5.1

I have been given the task of migrating some 200+ web sites fom Tru64 UNIX to Red Hat Enterprise Linux 64 bit V5.1 Many of these sites use PHP3 (3.0.18) and mysql 3.23.32 and the developers have long gone... The objective is to provide a 3.23.32 environment on RHEL 5.1 which will run in

Re: delete a data from 3 tables

Is there some reason why you don't just delete from the third table first, then the second then the first? Or maybe the reverse order, depending on your key - it's hard to get a good idea of the structure when you just say 1st table is connected with 2nd table by foreign key. Just be sure you

what setting would be more performant? multiple/single virtual server/s?

Hallo, we do have multiple old (celeron, IDE disk) LAMP systems which we would like to put together into fewer virtual web- and mysql-servers. The newer servers we have in spare have multi(core) cpu(s), lot of ram, slow local sata harddisks. So I was thinking to set up one host with the

foreign key cautions

HI, What are the caution should be taken when designing a db regarding foreign key? I have user table , from which userid is taken as reference in many tables, is it ok? -- Sharique uddin Ahmed Farooqui (C++/C# Developer, IT Consultant) http://safknw.blogspot.com/ Peace is the Ultimate thing we

Re: Migration of mysql 3.23.32 from Tru64 to RHEL 5.1

Le Tuesday 17 June 2008 vers 14:51, Swigg, Tom C(Swigg, Tom C [EMAIL PROTECTED]) a écrit: Hello, I have been given the task of migrating some 200+ web sites fom Tru64 UNIX to Red Hat Enterprise Linux 64 bit V5.1 Many of these sites use PHP3 (3.0.18) and mysql 3.23.32 and the developers

create view not working

why doesn't this work? the select works perfectly create view cost_report as SELECT c_name, d_manuf as Manufacturer, d_model as Model, count(1) as Number Enrolled, d_price as Monthly Price, count(1)*d_price as Cost FROM `b_devices` A left join b_device_types B on A.d_id = B.d_id left join

slave is running slow in another data center

Hello All, I've 4 slaves of a master. Out of 4, 3 are in same data center and have no issues. The fourth one is in another data center and some time that slave sql_thread lag behind more then 5000 sec. It's only sql_thread, which slow down. All H/W, S/W and my.cnf files are same for all