aebstract Posted April 27, 2010 Share Posted April 27, 2010 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? Quote Link to comment https://forums.phpfreaks.com/topic/199971-uhoh-help-with-update/ Share on other sites More sharing options...
jdavidbakr Posted April 28, 2010 Share Posted April 28, 2010 Run that insert on the other database? Quote Link to comment https://forums.phpfreaks.com/topic/199971-uhoh-help-with-update/#findComment-1050106 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.