Mysql updating dates in a table

Austin William Wright diamondmagic at users.sourceforge.net
Tue Aug 4 16:12:02 MST 2009


Austin William Wright wrote:
> [...]
> Replace all instances of tablename and columnname with the targets, and
> change DATE NOT NULL as necessary. That should work.
Whoops, Thunderbird formatted my fonts for me, ignore the pipes (wysiwyg
fail):
ALTER TABLE `tablename` CHANGE `columnname` `columnname` DATE NOT NULL

Austin Wright.



More information about the PLUG-discuss mailing list