• Welcome to the PopMalt Forums! Whether you're new to forums or a veteran, welcome to our humble home on the web! We're a 20-year old forum community with thousands of discussions on entertainment, lifestyle, leisure, and more.

    Our rules are simple. Be nice and don't spam. Registration is free, so what are you waiting for? Join today!.

MyPhpAdmin

clasione

New Member
I just had to edit something in MyPhpAdmin where I had a list of columns. I wasn't sure how to add a column so I just went in and edited one that wasn't important....

What's the story on adding a column to a current database... I didn't notice an add option, just delete and edit....

It may have been "insert new row" at the bottom of the page, but I wasn't sure about that....
 

Mirage

Secret Agent
Staff member
V.I.P.
At the bottom of the structure page for a table is an option to insert field. This is a column. The default is insert field "At end." You can specify where you want to insert it in the dropdown menu. After "field name" etc.

You then can specify the options for the field. This includes length, data type, default, and then special setting such as "unique", which means all rows will have to have different values for this column. You can almost always leave these extra options alone unless you are building a database from scratch.
 
Top