Skip to content

Instantly share code, notes, and snippets.

@nitriques

nitriques/migrate-lang-fr-to-en.sql

Created March 27, 2017 21:10
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save nitriques/aa4f1080e9406bc575e1c258bf91414c to your computer and use it in GitHub Desktop.
Save nitriques/aa4f1080e9406bc575e1c258bf91414c to your computer and use it in GitHub Desktop.
Download ZIP
migrate-lang.sql
Raw
migrate-lang-fr-to-en.sql
UPDATE `sym_entries_data_XXX` SET
`file` = `file-fr` ,
`size` = `size-fr` ,
`mimetype` = `mimetype-fr` ,
`meta` = `meta-fr` ,
`file-en` = `file-fr` ,
`size-en` = `size-fr` ,
`mimetype-en` = `mimetype-fr` ,
`meta-en` = `meta-fr` ,
`file-fr` = NULL ,
`size-fr` = NULL ,
`mimetype-fr` = NULL ,
`meta-fr` = NULL
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment