Pastie Support Pastie or read my Pastie << self blog

Language: ActionScript C/C++ CSS Diff HTML (ERB / Rails) HTML / XML Java Javascript Objective C/C++ Pascal Perl PHP Plain text Python Ruby Ruby (on Rails) Shell Script (Bash) SQL YAML  

## mark a section (Learn more)

This paste will be private.

CREATE TABLE `tbl_panel_fee` ( `pf_id` int(11) NOT NULL auto_increment, `panel_id` int(11) NOT NULL default '0', `pf_min` int(11) unsigned default NULL, `pf_max` int(11) unsigned default NULL, PRIMARY KEY (`pf_id`), KEY `panel_id` (`panel_id`), KEY `pf_min` (`pf_min`), KEY `pf_max` (`pf_max`), KEY `pf_min_2` (`panel_id`,`pf_min`,`pf_max`) ) !!We have two rows initially with: uniqueid, 7, 6, 125, 987654704 uniqueid, 13, 6, 125, 987654704 !!I then run the following two querys: REPLACE INTO tbl_panel_valfirm_fee(valfirm_id, cl_funder_id, pvf_fee, panel_id) VALUES (7, 6, 200, '987654704') REPLACE INTO tbl_panel_valfirm_fee(valfirm_id, cl_funder_id, pvf_fee, panel_id) VALUES (13, 6, 125, '987654704') !!I then get uniqueid, 7, 6, 200, 987654704 uniqueid, 13, 6, 200, 987654704 !!instead of the uniqueid, 7, 6, 200, 987654704 uniqueid, 7, 6, 125, 987654704 !!that i expected.