which ver of mysql are you using? multiple table update is possible only
with ver starting from 4.0.4.
HTH......
Nitin
----- Original Message -----
From: "Laercio Xisto Braga Cavalcanti" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, March 26, 2004 11:39 PM
Subject: Multiple-table Update
> 'm using Multiple-table Update with the above sintax:
> mysql> desc italica;
> +----------------+---------------+------+-----+---------+-------+
> | Field | Type | Null | Key | Default | Extra |
> +----------------+---------------+------+-----+---------+-------+
> | ita_empresa | decimal(10,0) | | | 0 | |
> | ita_matricula | decimal(10,0) | | PRI | 0 | |
> | ita_dv | decimal(1,0) | | PRI | 0 | |
> | ita_nome | varchar(50) | YES | | NULL | |
> | ita_fone | varchar(19) | YES | | NULL | |
> | ita_nascimento | date | YES | | NULL | |
> | ita_adesao | date | YES | | NULL | |
> | ita_ultpag | date | YES | | NULL | |
> +----------------+---------------+------+-----+---------+-------+
> 8 rows in set (0.00 sec)
> mysql> desc paciente
> -> ;
>
+-----------------+---------------+------+-----+------------+---------------
-+
> | Field | Type | Null | Key | Default | Extra
> |
>
+-----------------+---------------+------+-----+------------+---------------
-+
> | pac_codigo | int(11) | | PRI | NULL |
> auto_increment |
> | pac_nome | varchar(100) | YES | | NULL |
> |
> | pac_rg | int(11) | | | 0 |
> |
> | pac_nascimento | date | | | 0000-00-00 |
> |
> | pac_sexo | enum('M','F') | | | M |
> |
> | pac_endereco | varchar(50) | | | |
> |
> | pac_numero | int(11) | | | 0 |
> |
> | pac_complemento | varchar(50) | YES | | NULL |
> |
> | pac_celular | varchar(9) | YES | | NULL |
> |
> | pac_fone | varchar(9) | YES | | NULL |
> |
> | pac_fone_com | varchar(9) | YES | | NULL |
> |
> | pac_convenio | enum('S','N') | | | S |
> |
> | pac_matricula | int(11) | YES | | NULL |
> |
> | pac_adesao | date | YES | | NULL |
> |
> | pac_email | varchar(50) | YES | | NULL |
> |
> | pac_dv | int(1) | YES | | NULL |
> |
> | pac_bairro | varchar(50) | YES | | NULL |
> |
> | pac_cep | varchar(10) | YES | | NULL |
> |
> | pac_cidade | varchar(50) | YES | | NULL |
> |
> | pac_ultimopag | date | YES | | NULL |
> |
>
+-----------------+---------------+------+-----+------------+---------------
-+
> 20 rows in set (0.00 sec)
>
> update paciente, italica
> SET pac_nome = ita_nome,
> pac_fone = ita_fone,
> pac_nascimento = ita_nascimento,
> pac_ultimopag = ita_ultpag
> WHERE ita_matricula = pac_matricula
> AND ita_dv = pac_dv;
>
> and I got the following error:
>
> ERROR 1064: You have an error in your SQL syntax near ' italica
> SET pac_nome = ita_nome,
> pac_f' at line 1
>
>
> What can I do?
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
