'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]
