How to update Table columns without losing data

Asked Feb 28 '18 at 10:03

Active Feb 28 '18 at 10:08

Viewed 201 times

I have existing table that contains

id|name|age|gender| and this one contains a data already which is

id|name     |age|gender|
------------------------
1 |mengaw   |18| Male  | and more.....

now i updated my database on localhost becomes

so how can I update my table columns? instead of doing a insert code again?

Im using mysql phpmyadmin

edited Feb 28 '18 at 10:08

jarlh

asked Feb 28 '18 at 10:03

Mengaw

Which dbms are you using? – jarlh Feb 28 '18 at 10:05
I think that you need a tool to compare schema and data between databases. Or perhaps the best it's to delete the first table and copy the table that you have on localhost. – Jaime García Pérez Feb 28 '18 at 10:07
@jarrlh phpmyadmin – Mengaw Feb 28 '18 at 10:07
@PHX255 but how about the data? because in localhost are outdated data's only the columns are updated – Mengaw Feb 28 '18 at 10:08
I that case use Quest Toad for Mysql. You can do a schema compare and sync the structure of both databases (source and destination).https://www.toadworld.com/p/downloads you have 30 days with Trial. – Jaime García Pérez Feb 28 '18 at 10:11
1

See this link ->https://dba.stackexchange.com/questions/86107/how-can-i-export-just-the-structure-of-a-mysql-database – Balan Feb 28 '18 at 10:11
https://stackoverflow.com/questions/225772/compare-two-mysql-databases more tools for schema sync – Jaime García Pérez Feb 28 '18 at 10:13
ok guys i will check those links and update – Mengaw Feb 28 '18 at 10:17

0 Answers0