uhoh help with update

[aebstract]

Okay I have 2 databases, almost similar. One is more up to date with newer information, a lot of the information is the same though. I accidentally wrote over an entire column in one of my tables. I need to update it with my old database info from that column. The other columns need to be left alone though.

I did a simple select q1, id from table to get all the results and exported it out but it gave it to me in the form of an insert, obviously. (coming out of phpmyadmin)

 

INSERT INTO `participants` (`q1`, `id`) VALUES (6.216, 1),

(6.048, 2),

(99.999, 3),

(6.866, 4),

(6.105, 6),

(4.730, 7),

(4.685, ,

(5.044, 9),

(4.822, 10),

(4.730, 11),

(6.066, 115),

(4.977, 12),

(5.041, 13),

(4.760, 14),

(5.297, 15),

(5.377, 16),

(5.276, 17),

(5.295, 18),

(7.966, 19),

(5.286, 20),

(99.999, 21),

(99.999, 22),

(5.340, 23),

(5.368, 24),

(5.075, 25),

(7.040, 26),

(6.998, 27),

(7.013, 28),

(7.054, 29),

(7.508, 30),

(7.026, 31),

(7.002, 32),

(99.999, 33),

(6.986, 34),

(7.006, 35),

(99.999, 36),

(7.077, 37),

(7.063, 38),

(6.939, 39),

(7.135, 40),

(6.682, 41),

(6.990, 42),

(7.116, 43),

(7.125, 44),

(5.988, 45),

(6.073, 47),

(5.985, 48),

(6.086, 49),

(99.999, 50),

(8.657, 51),

(7.001, 52),

(6.989, 53),

(7.009, 54),

(6.983, 55),

(7.007, 56),

(6.966, 57),

(5.412, 58),

(4.906, 59),

(4.718, 60),

(4.980, 61),

(5.983, 62),

(6.021, 63),

(99.999, 64),

(4.489, 65),

(5.283, 66),

(4.388, 67),

(5.024, 68),

(6.538, 69),

(6.581, 71),

(99.999, 73),

(99.999, 74),

(6.710, 75),

(4.985, 76),

(5.803, 77),

(5.908, 78),

(6.075, 79),

(4.794, 80),

(99.999, 81),

(5.390, 82),

(6.002, 83),

(5.994, 84),

(6.304, 85),

(99.999, 86),

(6.157, 87),

(6.144, 88),

(99.999, 132),

(7.142, 131),

(7.033, 130),

(7.081, 92),

(6.977, 93),

(4.616, 94),

(7.419, 95),

(5.323, 96),

(5.412, 97),

(4.380, 98),

(4.427, 99),

(4.726, 100),

(4.719, 101),

(5.292, 102),

(5.585, 103),

(5.617, 104),

(5.345, 105),

(6.240, 106),

(5.695, 107),

(6.006, 108),

(4.832, 109),

(6.934, 110),

(7.580, 111),

(7.019, 112),

(7.481, 113),

(7.008, 114),

(4.576, 116),

(5.824, 117),

(6.085, 118),

(5.546, 119),

(99.999, 120),

(5.940, 121),

(7.369, 122),

(9.051, 123),

(7.203, 124),

(5.720, 125),

(5.835, 127),

(4.466, 128),

(4.766, 129),

(5.286, 133),

(5.219, 134),

(21.705, 135),

(5.026, 136),

(0.000, 137),

(0.000, 138),

(0.000, 139),

(0.000, 140),

(0.000, 141),

(0.000, 142),

(0.000, 143),

(0.000, 144),

(0.000, 145),

(0.000, 146),

(0.000, 147),

(0.000, 148),

(0.000, 149),

(0.000, 150),

(0.000, 151),

(0.000, 152),

(0.000, 153),

(0.000, 154),

(0.000, 155),

(0.000, 156),

(0.000, 157);

 

Anything simple to fix my problem?

[jdavidbakr]

Run that insert on the other database?