By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,191 Members | 1,256 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,191 IT Pros & Developers. It's quick & easy.

Moving data from specific column to another

P: 1
Hi,

I have some large data collected from another system that are for year 2014 and 2015. These are entered into our MySQL database. There are about 20 columns of data.
eg: Column A, B,C,D, E .....

I just realized that data 2014 should be inserted from column E onwards.
And 2015 data should be inserted from column A onwards.

When I look through the data inserted the last 4 columns for 2014 is null.

Is there a sql command that can move the data without moving the data to another table?
Oct 12 '16 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.