Skip to content

Instantly share code, notes, and snippets.

@apoorvam
Created January 14, 2020 14:45
Show Gist options
  • Select an option

  • Save apoorvam/7130710ab199b896c4de7baada614e09 to your computer and use it in GitHub Desktop.

Select an option

Save apoorvam/7130710ab199b896c4de7baada614e09 to your computer and use it in GitHub Desktop.
Queries
ALTER TABLE xbox_data.3on3_freestyle modify column recordTime datetime;
ALTER TABLE xbox_data.3on3_freestyle RENAME COLUMN recordTime TO record_time;
ALTER TABLE xbox_data.beatsplosion_for_kinect modify column recordTime datetime;
ALTER TABLE xbox_data.beatsplosion_for_kinect RENAME COLUMN recordTime TO record_time;
ALTER TABLE xbox_data.brawlhalla modify column recordTime datetime;
ALTER TABLE xbox_data.brawlhalla RENAME COLUMN recordTime TO record_time;
ALTER TABLE xbox_data.fishing_planet modify column recordTime datetime;
ALTER TABLE xbox_data.fishing_planet RENAME COLUMN recordTime TO record_time;
ALTER TABLE xbox_data.fortnite modify column recordTime datetime;
ALTER TABLE xbox_data.fortnite RENAME COLUMN recordTime TO record_time;
ALTER TABLE xbox_data.frozen_free_fall_snowball_fight modify column recordTime datetime;
ALTER TABLE xbox_data.frozen_free_fall_snowball_fight RENAME COLUMN recordTime TO record_time;
ALTER TABLE xbox_data.fruit_ninja_kinect_2 modify column recordTime datetime;
ALTER TABLE xbox_data.fruit_ninja_kinect_2 RENAME COLUMN recordTime TO record_time;
ALTER TABLE xbox_data.happy_wars modify column recordTime datetime;
ALTER TABLE xbox_data.happy_wars RENAME COLUMN recordTime TO record_time;
ALTER TABLE xbox_data.just_dance_2020 modify column recordTime datetime;
ALTER TABLE xbox_data.just_dance_2020 RENAME COLUMN recordTime TO record_time;
ALTER TABLE xbox_data.killer_instinct modify column recordTime datetime;
ALTER TABLE xbox_data.killer_instinct RENAME COLUMN recordTime TO record_time;
ALTER TABLE xbox_data.kinect_sports_rivals modify column recordTime datetime;
ALTER TABLE xbox_data.kinect_sports_rivals RENAME COLUMN recordTime TO record_time;
ALTER TABLE xbox_data.kungfu_for_kinect modify column recordTime datetime;
ALTER TABLE xbox_data.kungfu_for_kinect RENAME COLUMN recordTime TO record_time;
ALTER TABLE xbox_data.pinball_fx3 modify column recordTime datetime;
ALTER TABLE xbox_data.pinball_fx3 RENAME COLUMN recordTime TO record_time;
ALTER TABLE xbox_data.powerstar_golf modify column recordTime datetime;
ALTER TABLE xbox_data.powerstar_golf RENAME COLUMN recordTime TO record_time;
ALTER TABLE xbox_data.roblox modify column recordTime datetime;
ALTER TABLE xbox_data.roblox RENAME COLUMN recordTime TO record_time;
ALTER TABLE xbox_data.shape_up modify column recordTime datetime;
ALTER TABLE xbox_data.shape_up RENAME COLUMN recordTime TO record_time;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment