Tutorial Addendum on SQL - Data Abetment Statements

This affiliate describes data abetment statements:

    

 

    
INSERT INTO ...;

    

Insert Statements

    

An admit account allows you to admit new rows of data into an absolute table.

    

It has a amount of syntax formats:

    

1. To admit a individual row of all columns with ethics consistent from the specified

    

expressions:

    

    
INSERT INTO tbl_name Ethics (expression, expression, ...);

    

When executed, all expressions will be evaluated, and the consistent ethics will form

    

the new row, which will be amid into the defined table. Of course, the number

    

of expressions haveto be according to the amount of columns in table.

    

2. To admit a individual row with some columns accepting defined values, and others having

    

default values:

    

    
INSERT INTO tbl_name (column, column, ...) Ethics (expression, 

    
   expression, ...);

    

Notes:

    

    
• Obviously, bifold columns are not accustomed in the cavalcade list.
  
      



    
• The amount of expressions haveto be according to the amount of defined columns.
  
      



    
• Default ethics will be provided for those columns that are not defined
  
      

  in the cavalcade list.
  
      



    

3. To admit one or added rows of all columns with a baddest sub-statement:

    

    
INSERT INTO tbl_name select_statement;

    

When executed, the achievement rows of the baddest sub-statement will be amid

    

into the defined table. Of course, the amount of baddest expressions

    

in the baddest account haveto be according to the amount of columns of the defined table.

    

4. To admit one or added rows with some cavalcade accepting ethics from the defined

    

select sub-statement, and additional columns accepting absence values:

    

    
INSERT INTO tbl_name (column, column, ...) select_statement;

    

Notes:

    

    
• Obviously, bifold columns are not accustomed in the cavalcade list.
  
      



    
• The amount of baddest expressions haveto be according to the amount of defined columns.
  
      



    
• Default ethics will be provided for those columns that are not defined
  
      

  in the cavalcade list.
  
      



    

Here is an archetype SQL code, InsertRows.sql, assuming you how to admit rows

    

into an absolute table:

    

 

    
-- InsertRows.sql

    
-- Absorb (c) 1999 by Dr.  Yang

    
--

    
DROP TABLE IF EXISTS User;

    
CREATE TABLE User (Login VARCHAR(8), Countersign CHAR(8));

    
INSERT INTO User Ethics (  , 8IS3KOXW );

    
INSERT INTO User (Login) Ethics ( mike );

    
INSERT INTO User Baddest Login, Countersign FROM User;

    
INSERT INTO User (Password) Baddest CONCAT( __ ,Login) FROM User;

    
SELECT  User table:  AS  --- ;

    
SELECT * FROM User;