Patrick Roane escribiÃ:
I am trying to rename my table, but I get a syntax
error.
ALTER TABLE myblobs RENAME myBlobs;
Can anyone tell me where the problem is here? I went
to the mysql ref. site and I think this is the right
way to do this.
thanks-
=====
Patrick Roane
Web design and development
www.franklin-band.com
Fox River Grove, Il.
This is a typical Windows problem. If you read carefully the paragraph
in MySQL docs, it says:
<< If you use ALTER TABLE tbl_name RENAME TO new_tbl_name without any
other options, MySQL simply renames any files that correspond to the
table tbl_name... >>
What's happening? It's easy to understand if you look at the words
"simply renames any files". As you know in Windows filesystems "myblobs"
and "myBlobs" are the same filename. So simply rename the table to any
other name and then rename it back to "myBlobs". I.e.
ALTER TABLE myblobs RENAME foo;
ALTER TABLE foo RENAME myBlobs;
That's all folks.
I.Cividanes (icividanes at gmail dot com)
PHP Developer
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
