Hi all,
I would like to say good job to this newsgroup , they are the best.
Ok. My dilemma is that i have to compare values between 2 table which
are exactly the same structure and fields.
Below is rough example .
The table are tbl_chassis and tbl_chassis_temp. Below are the fields.
`id` int(11) NOT NULL auto_increment,
`serial_no` varchar(100) NOT NULL default '',
`host_name` varchar(100) NOT NULL default '',
`chasis_model` varchar(100) NOT NULL default '',
`chasis_flash_size` varchar(100) NOT NULL default '',
`chasis_dram_size` varchar(100) NOT NULL default '',
`chasis_sw_version` varchar(100) NOT NULL default '',
`chasis_eos` date NOT NULL default '0000-00-00',
`chasis_eol` date NOT NULL default '0000-00-00',
`chasis_user_field_1` varchar(100) NOT NULL default '',
`chasis_user_field_2` varchar(100) NOT NULL default '',
`chasis_user_field_3` varchar(100) NOT NULL default '',
`status` varchar(100) NOT NULL default '',
What i need to figure out are when the records are deleted , updated and
insert ,i need to update status in tbl_chassis table. What i am plan to
do is to select query in the tbl_chassis_temp table and compare the
value from each records to the records in the tbl_chassis table.Any
others ways to do it?
There are about 1000 records in each table.
What is the better alternative to do this ? Thanks
- weetat
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
