304
edits
Language and development rules: Difference between revisions
Jump to navigation
Jump to search
m
→PostgreSQL specificities
| Line 262: | Line 262: | ||
There is an exception | There is an exception | ||
The SQL "UPDATE FROM" : | The SQL "UPDATE FROM": | ||
Syntax | |||
MySQL Syntax: | |||
<source lang="sql"> | <source lang="sql"> | ||
UPDATE table_taget as target, table_source as source SET fieldtarget=source.fieldsource | UPDATE table_taget as target, table_source as source SET fieldtarget=source.fieldsource | ||
| Line 269: | Line 270: | ||
</source> | </source> | ||
Syntax | PgSQL Syntax: | ||
<source lang="sql"> | <source lang="sql"> | ||
UPDATE table_taget as target SET fieldtarget=source.fieldsource | UPDATE table_taget as target SET fieldtarget=source.fieldsource | ||