Are tables able to be indexed? How should the key be applied here? This is from Jay Greenspan's great Mysql/Php book. I looked for error disclaimers. I think it us just transposed ??? Is this a typo? In primary and key indexes " key stage _user_map_key " drop table if exists user_stage_map ; create table user_stage_map ( user_id integer not null, stage_id integer not null, primary key user_stage_map_key (user_id,stage_id ), key stage_user_map_key (stage_id) ); Russell Griechen
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php