Skip to content

Instantly share code, notes, and snippets.

@ethanfu

ethanfu/gist:2633906

Created May 8, 2012 09:40
Show Gist options
  • Save ethanfu/2633906 to your computer and use it in GitHub Desktop.
Save ethanfu/2633906 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
update WCMChnlDoc set DocChannel=7101 where DocId in (select MetaDataId from wcmmetatablehaierstore
where (qdlx='社区店' and gongmao='北京'));
update WCMChnlDoc set ChnlId=7101 where DocId in (select MetaDataId from wcmmetatablehaierstore
where (qdlx='社区店' and gongmao='北京')) and Modal=1;
update WCMDocument set DocChannel=7101 where DocId in (select MetaDataId from wcmmetatablehaierstore
where (qdlx='社区店' and gongmao='北京'));
update wcmmetatablehaierstore set ChannelId=7102 where (qdlx='社区店' and gongmao='北京')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment