List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:March 27 2002 8:09pm
Subject:Re: What is wrong in this query???
View as plain text  
At 21:03 +0100 3/27/02, Javier Armendáriz wrote:
>Can someone tellme the problem in this query??????
>
>Is there any problem updating two tables in the same query???

Do you find that syntax to be allowed anywhere in the MySQL manual?

There is work on this kind of thing being done for MySQL 4.1.
It's not ready yet.

>
>update alumno, alumnocurso
>set
>alumno.nombre='Blas',
>alumno.apellidos='Martinez Maertinez',
>alumno.nacimiento='1990-09-12',
>alumno.telefono = '666666666',
>alumnocurso.incorporacion = '2002-3-16',
>alumnocurso.finalizacion='0000-0-0',
>alumnocurso.observaciones = 'Observaciones id 4'
>where alumno.id = '4'
>and alumnocurso.id = '4'
>and alumno.id = alumnocurso.id_alumno ;

Thread
How can I Sort by Relevance?Walter D. Funk27 Mar
  • Re: How can I Sort by Relevance?Paul DuBois27 Mar
  • Re: How can I Sort by Relevance?Rodney Broom27 Mar
  • Re: How can I Sort by Relevance?Jeff Kilbride27 Mar
    • What is wrong in this query???Javier Armend├íriz27 Mar
      • Re: What is wrong in this query???Paul DuBois27 Mar
RE: How can I Sort by Relevance?Lopez David E-r9374c27 Mar
RE: What is wrong in this query???Rick Emery27 Mar