I have an employee table with 4 fields which are name,address,gender and age. Later on I added another column position. My problem is I do not know how to insert the contents of column position into the existing table. Any idea on how can this be done? Thanks
Assuming you have the contents, and you know which content goes in which row, it's a matter of using UPDATE statements to update the rows so that they contain the new contents.
Yes assuming I have more than 1000 rows how can I insert the new column and its contents?
Why should the number of rows matter?
go to phpmyadmin, export it, or (edit with phpmyadmin ) , open in excel, edit it, and import back.
Or create a batch updater, and edit the new columns.
