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?
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?