Home php (phpmyAdmin) How to add column?

(phpmyAdmin) How to add column?




There is a column with a username, password, registration date and identifier. How can I add another column with a record “About myself” and with a avatar? Do I have to remove the table and remake it?

Answer 1

First you need to find from the list of tables, you search for the table and in its row to click the structure


Next, you must specify the number of added columns and the location of their location in the list. After pressing the button forward, make the same as when creating a table (Fill the field parameters)

Answer 2, Authority 100%

I found the answer to my question. This problem can be implemented thanks to SQL query:

alter table & lt; Table name & gt; add & lt; column name & gt; varchar (20);

Programmers, Start Your Engines!

Why spend time searching for the correct question and then entering your answer when you can find it in a second? That's what CompuTicket is all about! Here you'll find thousands of questions and answers from hundreds of computer languages.

Recent questions