To add a new column in the MySQL table is simple and easy. I will help you to add a new column in the existing MySQL table. Follow the steps
- Open the Database and click your Database and choose the table, where you want to add a new column.
- There click in the Structure menu and go to the below and see the add option.
- Now give the column number, how many you want to add there and set the adding column position and click Go.
Note: there have many position of adding column that’s like at the beginning of the table, after table primary key and after any column, which column have in the table.
If you want to follow this video link: https://www.youtube.com/watch?v=O57PVQGi2CI&feature=youtu.be
Question and answer is powered by AnsPress.io