Bug #896 Use of functions in ALTER TABLE xx COMMENT syntax

• Submitted: 23 Jul 2003 6:12
• Modified: 4 Oct 2005 12:03
• Reporter: Udo Willers
• Status: Won't fix
• Category: MySQL Server
• Severity: S4 (Feature request)
• CPU Architecture: Any

[23 Jul 2003 6:12] Udo Willers

Description:
It is only possible to use Strings in the ALTER TABLE Syntax to change the table comment. I would like to use a function i.e. NOW() which returns a string to insert the current date in the table comment.

How to repeat:
ALTER  TABLE  `testtable`  COMMENT  = NOW(  )

Suggested fix:
Allow the use of functions who return a string in the syntax.

[4 Oct 2005 12:03] Valeriy Kravchuk

Thank you for a suggestion. But I do not think it is really needed. You may use shell to substitute properly formatted date command results. Many editors (even simple vi) allows to insert the results of any command execution or simply a timestamp. You can even use CVS or other source code control system to substitute some parts of a comment string in the script, and then pass it to mysql...

So, I do now think somebody will bother trying to impelement the feature you are asking for in the nearest future.