Home > Archive > PHP SQL > April 2004 > UPDATE COMMAND ?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| l'atelier Ho 2004-04-17, 5:30 pm |
| Hello to all,
I used the following MySQL command to update two feld:
UPDATE PRODUITS SET TEXTE_GER=TEXTE, TEXTE_FRE=TEXTE
On my local MySQL database with PhpMyAdmin I didn't have
had any problem. But this same command do not work by the
provider
Error message:
UPDATE PRODUITS SET TEXTE_GER = TEXTE,
TEXTE_FRE = TEXTE
MySQL answer:
Table 'haldiateho.PRODUITS' doesn't exist
The table PRODUITS exist!
Many thanks in advance for your help.
Regards
Otto
| |
| l'atelier Ho 2004-04-17, 6:30 pm |
| I find out!
> UPDATE PRODUITS SET TEXTE_GER=TEXTE, TEXTE_FRE=TEXTE
>
I did forgot that "produits" should be in lowercase!..
| |
| Andy Hassall 2004-04-17, 6:30 pm |
| On Sat, 17 Apr 2004 22:03:35 +0200, l'atelier Ho <ateho@freesurf.ch> wrote:
>Hello to all,
>
>I used the following MySQL command to update two feld:
>
>UPDATE PRODUITS SET TEXTE_GER=TEXTE, TEXTE_FRE=TEXTE
>
>On my local MySQL database with PhpMyAdmin I didn't have
>had any problem. But this same command do not work by the
>provider
>
>Error message:
>UPDATE PRODUITS SET TEXTE_GER = TEXTE,
>TEXTE_FRE = TEXTE
>
>MySQL answer:
>Table 'haldiateho.PRODUITS' doesn't exist
>
>The table PRODUITS exist!
Clearly it doesn't! How did you determine that it does? Post some proof...
--
Andy Hassall <andy@andyh.co.uk> / Space: disk usage analysis tool
http://www.andyh.co.uk / http://www.andyhsoftware.co.uk/space
|
|
|
|
|