Re: Alter all tables in a Database

[Nelson Dawson]

Thanks for the reply Jay it does not work.
the alter table happens
| MySQLCMD |
+---------------------------------------------------------+
| Alter Table 'nelson'.'CX' Add column Logged_Data |
| Alter Table 'nelson'.'selftests' Add column Logged_Data |
| Alter Table 'nelson'.'test' Add column Logged_Data |
| Alter Table 'nelson'.'test2' Add column Logged_Data |
+---------------------------------------------------------+

But when i check the structure for the tables the field does not exist.

Look forward to your reply.

Regards
Nelson Dawson