Skip to content

Instantly share code, notes, and snippets.

@amitaibu
Created November 4, 2012 09:12
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 amitaibu/4010869 to your computer and use it in GitHub Desktop.
Save amitaibu/4010869 to your computer and use it in GitHub Desktop.
db_query("UPDATE {field_data_message_text} SET delta = delta + 1 WHERE bundle = 'message_type_email';");
@amitaibu
Copy link
Author

amitaibu commented Nov 4, 2012

db_query("UPDATE {field_data_message_text} SET delta = delta + 1 WHERE bundle = 'message_type_email';");

@bitamar
Copy link

bitamar commented Nov 4, 2012

This worked for me:
UPDATE field_data_message_text SET delta = delta + 1 WHERE bundle = 'message_type_email' ORDER BY entity_type, entity_id, language, delta DESC;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment