Sedang Disiapkan

phpmyadmin db update

Request for phpmyadmin assistance to update a mysql db table.

I have a db table that has 12,000 "year" posts ranging from 1999 to 2005. I need each year/POST to be updated WITH 2 years to insteead range from 2001 to 2007.

Possible alternative to updating directly in phpmyadmin is to correctly upload an already updated table (in excel... which was downloaded from phpmyadmin and updated by me. This file now already has correct years across all 12,000 posts). I am however unable to locate a way to properly import and update the posts of a single db table via Excel.

We are also looking to establish a relationship as some more work will come from this as we are starting with some db updates/work. This is just the first task. Please quote only on the request described above however.

Thanks

Kemahiran: Linux, Sistem Admin

Lihat lebih lanjut: phpmyadmin import update table, phpmyadmin update excel, excel phpmyadmin update, update tables phpmyadmin, phpmyadmin table update, update mysql, linux update, db, c update, mysql import excel table, excel update mysql, import mysql excel excel, phpmyadmin excel import, update work, phpmyadmin mysql, admin assistance, excel table mysql, mysql update table, update excel, admin excel work, mysql import excel, excel import mysql, mysql table excel, range table, import upload

Tentang Majikan:
( 22 ulasan ) Kuluin, Australia

ID Projek: #331486