6

I administrate my MySQL database by Adminer 4.1.0. Now I wanted to add a column to an existing table and I didn't find how to do it except typing ALTER TABLE into the "SQL command" window. Lack of such a basic feature is not crippling for me (I know SQL enough), but still annoying. So did I miss something, or is SQL command window really the only way to add a column to an existing table in Adminer?

Pavel V.
  • 2,653
  • 10
  • 43
  • 74

1 Answers1

13

Off course it is possible, just little hidden, took me some tie to find it. Click to the table, then "alter table" and then the plus (+) icon next to the column you want to add the new column after.

Pavel V.
  • 2,653
  • 10
  • 43
  • 74
  • 1
    you answered your own question :) :) . By the way your answered helped me so thanks. – Zakir hussain Jul 18 '19 at 12:16
  • You answered your own question like you answered other person's question. lol. But your answer was very helpful. thanks! – Mark Lozano Dec 02 '20 at 00:58
  • @MarkLozano There is even an option to ask a question and answer at the same time. I have never done that, but this is not my only case of the workflow "make some research - ask - in case of no answer do more research - find the solution - answer" :-) As long as you don't ommit the first step, it's ok. – Pavel V. Dec 02 '20 at 15:07