Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
labs:postgresql [2016/06/27 16:09] – [Creating Tables] adminlabs:postgresql [2017/07/25 16:22] (current) – [Update Statements] admin
Line 51: Line 51:
  
  
 +To update a table with a value in another table:
 +  
 +  update table2 set t2field = t1.field from table1 t1 where table2.keyfield2 = t1.keyfield1;
 ===== Creating Database ===== ===== Creating Database =====
  
Line 64: Line 67:
  
   CREATE TABLE table_name (   CREATE TABLE table_name (
-      id integer NOT NULL default nextval('inscription_id_seq'),+ id integer NOT NULL default nextval('inscription_id_seq'),
  eagle_id char(9),  eagle_id char(9),
  floor_to_graffito_height varchar(30),  floor_to_graffito_height varchar(30),
labs/postgresql.1467043744.txt.gz · Last modified: 2016/06/27 16:09 by admin
CC Attribution-Noncommercial-Share Alike 4.0 International
Driven by DokuWiki Recent changes RSS feed Valid CSS Valid XHTML 1.0