How to add a new column to all the tables in a database in mysql

See more:

MySQL

I have a database 'portfolio' and it contains the portfolio of all the users and there are over 1000 tables inside this portfolio database.
I need to add a new column "Date" to all the tables.

However, i am getting the following error:

Error Code: 1054. Unknown column 'Tables' in 'field list'




Any help will be appreciated. Thank you in advance.

What I have tried:

use portfolio;
show tables;


select CONCAT("Alter Table ", TABLE_SCHEMA,`.`,Tables, " Add Column presentDate date") from INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA = "portfolio";

The result for show tables is as follows:

Tables_in_portfolio
123
222
p3647
4458e
76367jgfkg
......and so on