

This is useful for providing a new name to the current table column by using a renaming query. Also, the ALTER COLUMN can be used for dropping the column present in the table. But it only took a couple of minutes to add that to the tables. Basically, MySQL ALTER COLUMN command allows the admin to modify an existing table with the addition of one or multiple columns to it. THANK YOU THANK YOU THANK YOU!! I did run into one snag, that being my users tables don't have (or rather didn't have) auto increment primary keys, which is a "gotta have" for this script. And in another 2 hours, I had another table up and running.

I had it up and running with my users table for a couple of the fields in just under an hour!!!! A few more hours in and I had the whole table integrated.
#Mysql tableedit code#
phpMyEdit generates PHP code for displaying/editing MySQL tables in HTML. Easily modify your MySQL database data with easy functions Useful for websites & large projects where it makes managing data easier & faster Supports the Promise-API, you will be able to use.

Based on the reviews, I thought I'd give a shot. phpMyEdit application provides an instant table editor. I had just settled into developing my own editor when while doing a google for something related to my development, a link to this script popped up. I'd already been through weeks of installing and troubleshooting "full feature" flops, "simple" editors (which is what I need for the end users who requested it) that simply. Before I found this script, I'd just about thrown up my hands that a simple HTML based data editor for mySQL tables even existed.
