You can not do it directly. You have to create a new table as a copy of the old one: CREATE TABLE new_table SELECT * FROM old_table Your problem will be that the MySQL "PHP" user will probably not have the CREATE rights. Ignatius ____________________________________________ "Rodrigo San Martin" <rodrigo@stud.ntnu.no> wrote in message news:20021112113152.9310.qmail@pb1.pair.com... > Hi. > I want to change a tablename in my database. How do i do that? I want to do > it from a webpage so i need to use php. > > > > > > ------------------------------------------ > Rodrigo San Martin > Institutt for datateknologi og informatikk > > http://www.idi.ntnu.no/~rodrigo > > > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
