
11-12-2007, 02:18 AM
|
 |
|
|
Join Date: Sep 2007
Location: ON, Canada
Posts: 108
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
Quote:
Originally Posted by webgod
I have direct access to the server and a GUI interface, so it was as a easy as point and click for me.
but being a developer myself, the correct SQL query is:
ALTER TABLE userfield MODIFY COLUMN Field55 Decimal(5,3);
Reference:
http://dev.mysql.com/doc/refman/5.0/en/alter-table.html
Field55 may be different in your installation, so make sure it refers to the data column for the 1/4 ET and/or 1/8 ET
Back up your table/DB before attempting any schema alterations, I take absolutely no responsibility for the code above, and have not tested or verified it's compatibility on any system.
.
|
So does running this query fix the <10.00s times going to the bottom of the list???
|