[thelist] create table syntax

Russell Griechen russgri at bellsouth.net
Wed Oct 2 23:43:01 CDT 2002


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




More information about the thelist mailing list