        ____________555

   Insert   , -
  Select.       - 
     .    Insert :

INSERT INTO < > < Select>

, ,    01d_Pers    -
         Pers. 
   :

INSERT INTO 01d_Pers SELECT * FROM Pers WHERE Year_b < 1939

 01d_Pers      
Pers.

   Insert    
     ,      
 .

    Update:

UPDATE < > SET <  <>=<

WHERE<ycnoBMe>

          -
,    . ,     -
    I   2    I,    -
      :

UPDATE Pers SET Dep = '  WHERE Dep = ' 2'
    Delete:

DELETE FROM < > WHERE <>

        ,   -
 . ,     
 I          -
,         :

DELETE FROM Pers WHERE Dep = ' 1'

10.1.4   

     Create Table:

CREATE TABLE < >
(<  < > <>(<>)>)

         .
       PRIMARY KEY, 
  ,       .    -
      NOT NULL, , 
         . :

CREATE TABLE Pers(

Mum smailint Not Null Primary Key,

Dep char(15) ,

Fam char(20) Not Null,

Nam
Par

Nam char(20) Not Null,

Par char(20) Not Null,

Year_b smailint DEFAULT 1950,

Sex char(l) DEFAULT ''

