PostgreSQL

Скачать в pdf «PostgreSQL»


test=> SELECT * FROM friend;


firstname


| lastname


| city


|


state


|


age


Mike


| Nichols


| Tampa


|


FL


|


19


Cindy


| Anderson


| Denver


|


CO


|


23


Sam


| Jackson


| Allentown


|


pa


|


22


(3 rows)


test=> INSERT INTO friend VALUES (‘Jim’, ‘Barnes’, ‘


Ocean


City’,’ 1


NJ


, 25)


INSERT 19056 1


test=> SELECT *


FROM friend;


firstname


| lastname


| city


|


state


|


age


Mike


| Nichols


| Tampa


|


FL


|


19


Cindy


| Anderson


| Denver


|


CO


|


23


Sam


| Jackson


| Allentown


|


pa


|


22


Jim


| Barnes


| Ocean City


|


NJ


|


25


(4 rows)


test=> DELETE FROM friend WHERE lastname = ‘Barnes’;


DELETE 1


test=> SELECT *

Скачать в pdf «PostgreSQL»