is it possible to update the information_schema table in order to add leading text to column names?

user_682107 0
Viewed 5206

I am trying to execute this SQL as root:

UPDATE information_schema.COLUMNS SET COLUMN_NAME = CONCAT('emp',COLUMN_NAME)  WHERE TABLE_SCHEMA = 'edsdb'

But get the following error:

SQL Error [1044] [42000]: Access denied for user 'root'@'localhost' to database 'information_schema'
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user 'root'@'localhost' to database 'information_schema'

These tables that I need to 'fix' the column names off have a lot of columns in them. Is it possible to do this directly in SQL?

mysql sql
3 Answers
Related