SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 10:30 AM
| ||||
| ||||
 update with join Where is the error in this update with join update snx_comuni set sta_id = 2782 from snx_comuni inner join snx_province on snx_comuni.provincia_id = snx_province.provincia_id inner join snx_regioni on snx_province.regione_id = snx_regioni.regione_id where snx_regioni.codice_regione = 'PIE'      |
|
02-28-2008, 10:30 AM
| |||
| |||
| Re: update with join On 5 Dec, 12:12, Michele <nom...@nomail.it> wrote: > check the manual that correspond to your MySql server version for the > right syntax o use near > inner join snx_province on snx_comuni.provincia_id = snx_province.pr_id > a line > > :-(((( Well "inner" is unnecessary in MySQL, but it shouldn't have given an error. Is that really the full error that MySql reported? It usually says "corresponds" and not "correspond"?? |
|
02-28-2008, 10:30 AM
| |||
| |||
| Re: update with join On Wed, 05 Dec 2007 13:57:34 +0100, Captain Paralytic <paul_lautman@yahoo.com> wrote: > On 5 Dec, 12:12, Michele <nom...@nomail.it> wrote: >> check the manual that correspond to your MySql server version for the >> right syntax o use near >> inner join snx_province on snx_comuni.provincia_id = snx_province.pr_id >> a line >> >> :-(((( > > Well "inner" is unnecessary in MySQL, but it shouldn't have given an > error. > > Is that really the full error that MySql reported? It usually says > "corresponds" and not "correspond"?? And 'to' instead of 'o'... and 'at' instead of 'a'. So I'm curious about the full error message too. -- Rik Wasmus |
|
02-28-2008, 10:30 AM
| |||
| |||
| Re: update with join On 5 Dec, 13:01, "Rik Wasmus" <luiheidsgoe...@hotmail.com> wrote: > On Wed, 05 Dec 2007 13:57:34 +0100, Captain Paralytic > > <paul_laut...@yahoo.com> wrote: > > On 5 Dec, 12:12, Michele <nom...@nomail.it> wrote: > >> check the manual that correspond to your MySql server version for the > >> right syntax o use near > >> inner join snx_province on snx_comuni.provincia_id = snx_province.pr_id > >> a line > > >> :-(((( > > > Well "inner" is unnecessary in MySQL, but it shouldn't have given an > > error. > > > Is that really the full error that MySql reported? It usually says > > "corresponds" and not "correspond"?? > > And 'to' instead of 'o'... and 'at' instead of 'a'. So I'm curious about > the full error message too. > -- > Rik Wasmus Yeah, you ask 'em for the error message. All they have to do is copy'n'paste. But instead they type just part of it. |
|
02-28-2008, 10:30 AM
| |||
| |||
| Re: update with join On Wed, 05 Dec 2007 15:08:59 +0100, Michele <nomail@nomail.it> wrote: >> Is that really the full error that MySql reported? It usually says >> "corresponds" and not "correspond"?? > > corresponds > > > how can I resolve it?? First of all, by copy/pasting the _entire_ error message (and also the entire query if you don't exactly use the example given). -- Rik Wasmus |
|
02-28-2008, 10:30 AM
| |||
| |||
| Re: update with join On 5 Dec, 14:08, Michele <nom...@nomail.it> wrote: > > Is that really the full error that MySql reported? It usually says > > "corresponds" and not "correspond"?? > > corresponds > > how can I resolve it?? What we are trying to point out is that, despite asking you for the error that mysql reported, you have only typed in part of it. If you want help in trying to resolve it you have to copy'n'paste the full actual query that you are executing and the full actual error that mysql reports. |
|
02-28-2008, 10:30 AM
| |||
| |||
| Re: update with join thanks You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'snx_comuni inner join snx_province on snx_comuni.provincia_id = snx_province.pr' at line 1 with update snx_comuni set sta_id = 2782 snx_comuni inner join snx_province on snx_comuni.provincia_id = snx_province.provincia_id inner join snx_regioni on snx_province.regione_id = snx_regioni.regione_id where snx_regioni.codice_regione = 'PIE' |
|
02-28-2008, 10:30 AM
| ||||
| ||||
| Re: update with join On Wed, 05 Dec 2007 18:02:56 +0100, Michele <nomail@nomail.it> wrote: > thanks > > You have an error in your SQL syntax; check the manual that corresponds > to your MySQL server version for the right syntax to use near 'snx_comuni > inner join snx_province on snx_comuni.provincia_id = snx_province.pr' at > line 1 > > with > > update snx_comuni set sta_id = 2782 snx_comuni > inner join snx_province on snx_comuni.provincia_id = > snx_province.provincia_id > inner join snx_regioni on snx_province.regione_id = > snx_regioni.regione_id > where snx_regioni.codice_regione = 'PIE' A few posts back, I told you to use this: update snx_comuni inner join snx_province on snx_comuni.provincia_id = snx_province.provincia_id inner join snx_regioni on snx_province.regione_id = snx_regioni.regione_id set snx_comuni.sta_id = 2782 where snx_regioni.codice_regione = 'PIE' .... any particular reason why you chose not to use this one? -- Rik Wasmus |
 |
« Stripping the from beginning of field name when it occurs
|
SQL command to show only databases that contain a particular table »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 08:48 AM.
