[UPHPU] mysql modify vs. change

Sat Oct 13 00:21:56 MDT 2007

It appears that you can change a MySQL column's data type with both  
'modify' and 'change'. What is the difference between the two? In my  
notes, I had 'modify' down to use for altering a data type and  
'change' for renaming a column. phpMyAdmin used 'change' to change a  
column's data type though. Are the two synonymous?
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2425 bytes
Desc: not available
Url : http://uphpu.org/pipermail/uphpu/attachments/20071013/56c76565/smime.bin