test sql

select  b.realname, ( case  b.sex  when   1   then   ' 男 '   else   ' 女 '   end ) sex,            b.birthday, b.address, b.postcode, b.mobile, b.email   from  magamember a, membera CREATE   TABLE  upload_new_picdetail (                                                                 id  int ( 10 )  NOT   NULL  auto_increment,                                                            region  int ( 10 )  NOT   NULL   default   ' 0 ' ,                                                           district  int ( 10 )  NOT   NULL   default   ' 0 ' ,                                                         sight  int ( 10 )  NOT   NULL   default   ' 0 ' ,                                                            uploadtime  datetime   NOT   NULL   default   ' 0000-00-00 00:00:00 ' ,                                   picauthor  varchar ( 25 )  default   NULL ,                                                            pictitle  varchar ( 100 )  default   NULL ,                                                            pictxt  text ,                      picpath  varchar ( 255 )  NOT   NULL   default   '' ,                                                       threadid    mediumint( 8 ),               -- 论坛帖子id                      spaceitemid mediumint( 8 ),            -- 博客帖子id                       PRIMARY   KEY   (id)                      ) TYPE = Innodb COMMENT = ' 上传图片信息表 ' rrtibe b    where  a.magamember_id  =  b.memberarrtibe_id    and  a.magagrant_id  =   5