Re: update tablename
| From: | Ignatius Reilly | Date: | Tue, 12 Nov 2002 11:47:32 +0000 |
| Subject: | Re: update tablename | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-23229@lists.php.net to get a copy of this message | ||
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
>
>