1.   w3schools.com  
    THE WORLD'S LARGEST WEB DEVELOPER SITE
      
        
                      HTML      CSS      JAVASCRIPT      SQL      PYTHON      PHP      BOOTSTRAP      HOW TO      W3.CSS      JQUERY      JAVA      MORE                         FORUM      EXERCISES       REFERENCES     
                  
      
        
    SQL Tutorial
    SQL HOMESQL IntroSQL SyntaxSQL SelectSQL Select DistinctSQL WhereSQL And, Or, NotSQL Order BySQL Insert IntoSQL Null ValuesSQL UpdateSQL DeleteSQL Select TopSQL Min and MaxSQL Count, Avg, SumSQL LikeSQL WildcardsSQL InSQL BetweenSQL AliasesSQL JoinsSQL Inner JoinSQL Left JoinSQL Right JoinSQL Full JoinSQL Self JoinSQL UnionSQL Group BySQL HavingSQL ExistsSQL Any, AllSQL Select IntoSQL Insert Into SelectSQL CaseSQL Null FunctionsSQL Stored ProceduresSQL Comments
    SQL Database
    SQL Create DBSQL Drop DBSQL Backup DBSQL Create TableSQL Drop TableSQL Alter TableSQL ConstraintsSQL Not NullSQL UniqueSQL Primary KeySQL Foreign KeySQL CheckSQL DefaultSQL IndexSQL Auto IncrementSQL DatesSQL ViewsSQL InjectionSQL Hosting
    SQL References
    SQL Keywords
      ADD  ADD CONSTRAINT  ALTER  ALTER COLUMN  ALTER TABLE  ALL  AND  ANY  AS  ASC  BACKUP DATABASE  BETWEEN  CASE  CHECK  COLUMN  CONSTRAINT  CREATE  CREATE DATABASE  CREATE INDEX  CREATE OR REPLACE VIEW  CREATE TABLE  CREATE PROCEDURE  CREATE UNIQUE INDEX  CREATE VIEW  DATABASE  DEFAULT  DELETE  DESC  DISTINCT  DROP  DROP COLUMN  DROP CONSTRAINT  DROP DATABASE  DROP DEFAULT  DROP INDEX  DROP TABLE  DROP VIEW  EXEC  EXISTS  FOREIGN KEY  FROM  FULL OUTER JOIN  GROUP BY  HAVING  IN  INDEX  INNER JOIN  INSERT INTO  INSERT INTO SELECT  IS NULL  IS NOT NULL  JOIN  LEFT JOIN  LIKE  LIMIT  NOT  NOT NULL  OR  ORDER BY  OUTER JOIN  PRIMARY KEY  PROCEDURE  RIGHT JOIN  ROWNUM  SELECT  SELECT DISTINCT  SELECT INTO  SELECT TOP  SET  TABLE  TOP  TRUNCATE TABLE  UNION  UNION ALL  UNIQUE  UPDATE  VALUES  VIEW  WHERE
    MySQL Functions
      String Functions  ASCII  CHAR_LENGTH  CHARACTER_LENGTH  CONCAT  CONCAT_WS  FIELD  FIND_IN_SET  FORMAT  INSERT  INSTR  LCASE  LEFT  LENGTH  LOCATE  LOWER  LPAD  LTRIM  MID  POSITION  REPEAT  REPLACE  REVERSE  RIGHT  RPAD  RTRIM  SPACE  STRCMP  SUBSTR  SUBSTRING  SUBSTRING_INDEX  TRIM  UCASE  UPPER  Numeric Functions  ABS  ACOS  ASIN  ATAN  ATAN2  AVG  CEIL  CEILING  COS  COT  COUNT  DEGREES  DIV  EXP  FLOOR  GREATEST  LEAST  LN  LOG  LOG10  LOG2  MAX  MIN  MOD  PI  POW  POWER  RADIANS  RAND  ROUND  SIGN  SIN  SQRT  SUM  TAN  TRUNCATE  Date Functions  ADDDATE  ADDTIME  CURDATE  CURRENT_DATE  CURRENT_TIME  CURRENT_TIMESTAMP  CURTIME  DATE  DATEDIFF  DATE_ADD  DATE_FORMAT  DATE_SUB  DAY  DAYNAME  DAYOFMONTH  DAYOFWEEK  DAYOFYEAR  EXTRACT  FROM_DAYS  HOUR  LAST_DAY  LOCALTIME  LOCALTIMESTAMP  MAKEDATE  MAKETIME  MICROSECOND  MINUTE  MONTH  MONTHNAME  NOW  PERIOD_ADD  PERIOD_DIFF  QUARTER  SECOND  SEC_TO_TIME  STR_TO_DATE  SUBDATE  SUBTIME  SYSDATE  TIME  TIME_FORMAT  TIME_TO_SEC  TIMEDIFF  TIMESTAMP  TO_DAYS  WEEK  WEEKDAY  WEEKOFYEAR  YEAR  YEARWEEK  Advanced Functions  BIN  BINARY  CASE  CAST  COALESCE  CONNECTION_ID  CONV  CONVERT  CURRENT_USER  DATABASE  IF  IFNULL  ISNULL  LAST_INSERT_ID  NULLIF  SESSION_USER  SYSTEM_USER  USER  VERSION
    SQL Server Functions
      String Functions  ASCII  CHAR  CHARINDEX  CONCAT  Concat with +  CONCAT_WS  DATALENGTH  DIFFERENCE  FORMAT  LEFT  LEN  LOWER  LTRIM  NCHAR  PATINDEX  QUOTENAME  REPLACE  REPLICATE  REVERSE  RIGHT  RTRIM  SOUNDEX  SPACE  STR  STUFF  SUBSTRING  TRANSLATE  TRIM  UNICODE  UPPER  Numeric Functions  ABS  ACOS  ASIN  ATAN  ATN2  AVG  CEILING  COUNT  COS  COT  DEGREES  EXP  FLOOR  LOG  LOG10  MAX  MIN  PI  POWER  RADIANS  RAND  ROUND  SIGN  SIN  SQRT  SQUARE  SUM  TAN  Date Functions  CURRENT_TIMESTAMP  DATEADD  DATEDIFF  DATEFROMPARTS  DATENAME  DATEPART  DAY  GETDATE  GETUTCDATE  ISDATE  MONTH  SYSDATETIME  YEAR  Advanced Functions  CAST  COALESCE  CONVERT  CURRENT_USER  IIF    ISNULL  ISNUMERIC  NULLIF  SESSION_USER  SESSIONPROPERTY  SYSTEM_USER  USER_NAME
    MS Access Functions
      String Functions  Asc  Chr  Concat with &  CurDir  Format  InStr  InstrRev  LCase  Left  Len  LTrim  Mid  Replace  Right  RTrim  Space  Split  Str  StrComp  StrConv  StrReverse  Trim  UCase  Numeric Functions  Abs  Atn  Avg  Cos  Count  Exp  Fix  Format  Int  Max  Min  Randomize  Rnd  Round  Sgn  Sqr  Sum  Val  Date Functions  Date  DateAdd  DateDiff  DatePart  DateSerial  DateValue  Day  Format  Hour  Minute  Month  MonthName  Now  Second  Time  TimeSerial  TimeValue  Weekday  WeekdayName  Year  Other Functions  CurrentUser  Environ  IsDate  IsNull  IsNumeric
    SQL OperatorsSQL Data TypesSQL Quick Ref
    SQL Examples
    SQL ExamplesSQL QuizSQL ExercisesSQL Certificate      

        
      
      
        
          
                            
                         
    SQL INSERT INTO Statement
    ❮ Previous  Next ❯
    The SQL INSERT INTO Statement
    The INSERT INTO statement is used to insert new records in a table.
    INSERT INTO Syntax
    It is possible to write the INSERT INTO statement in two ways.
    The first way specifies both the column names and the values to be inserted:
    INSERT INTO table_name (column1, column2, column3, ...)
    VALUES (value1, value2, value3, ...);
    If you are adding values for all the columns of the table, you do not need to specify the column names in the SQL query. However, make sure the order of the values is in the same order as the columns in the table. The INSERT INTO syntax would be as follows:
    INSERT INTO table_name
    VALUES (value1, value2, value3, ...);
    Demo Database
    Below is a selection from the "Customers" table in the Northwind sample database:
      
        CustomerID    CustomerName    ContactName    Address    City    PostalCode    Country  
      
        89    White Clover Markets    Karl Jablonski    305 - 14th Ave. S. Suite 3B    Seattle    98128    USA  
      
        90

    		    Wilman Kala    Matti Karttunen    Keskuskatu 45    Helsinki    21240    Finland  
      
        91

    		    Wolski    Zbyszek    ul. Filtrowa 68    Walla    01-012    Poland  
        
    INSERT INTO Example
    The following SQL statement inserts a new record in the "Customers" table:
    Example
    INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country)
    VALUES ('Cardinal', 'Tom B. Erichsen', 'Skagen 21', 'Stavanger', '4006', 'Norway');
    Try it Yourself »
    The selection from the "Customers" table will now look like this:
      
        CustomerID    CustomerName    ContactName    Address    City    PostalCode    Country  
      
        89    White Clover Markets    Karl Jablonski    305 - 14th Ave. S. Suite 3B    Seattle    98128    USA  
      
        90

    		    Wilman Kala    Matti Karttunen    Keskuskatu 45    Helsinki    21240    Finland  
      
        91

    		    Wolski    Zbyszek    ul. Filtrowa 68    Walla    01-012    Poland  
      
        92    Cardinal    Tom B. Erichsen    Skagen 21    Stavanger    4006    Norway  
    Did you notice that we did not insert any number into the CustomerID field?
    The CustomerID column is an auto-increment field and will be generated automatically when a new record is inserted into the table.
    Insert Data Only in Specified Columns
    It is also possible to only insert data in specific columns.
    The following SQL statement will insert a new record, but only insert data in the "CustomerName", "City", and "Country" columns (CustomerID will be updated automatically):
    Example
    INSERT INTO Customers (CustomerName, City, Country)
    VALUES ('Cardinal', 'Stavanger', 'Norway');
    Try it Yourself »
    The selection from the "Customers" table will now look like this:
      
        CustomerID    CustomerName    ContactName    Address    City    PostalCode    Country  
      
        89    White Clover Markets    Karl Jablonski    305 - 14th Ave. S. Suite 3B    Seattle    98128    USA  
      
        90

    		    Wilman Kala    Matti Karttunen    Keskuskatu 45    Helsinki    21240    Finland  
      
        91

    		    Wolski    Zbyszek    ul. Filtrowa 68    Walla    01-012    Poland  
      
        92    Cardinal    null    null     Stavanger    null    Norway  
    Test Yourself With Exercises
    Exercise:
    Insert a new record in the Customers table.
     Customers CustomerName, Address, City, PostalCode,Country 'Hekkan Burger','Gateveien 15','Sandnes','4306','Norway';

    Start the Exercise

    ❮ Previous  Next ❯
        2. 
http://www.mh8dociw.tw |

http://m.mh8dociw.tw |

http://wap.mh8dociw.tw |

http://3g.mh8dociw.tw |

http://4g.mh8dociw.tw |

http://5g.mh8dociw.tw |

http://mobile.mh8dociw.tw |

http://vip.mh8dociw.tw |

http://ios.mh8dociw.tw |

http://anzhuo.mh8dociw.tw |

http://c.mh8dociw.tw |

http://d1970.mh8dociw.tw |

http://31.mh8dociw.tw |

http://6fdd.mh8dociw.tw |

http://5.mh8dociw.tw |

http://14a4e.mh8dociw.tw |

林小兰说免费阅读