•   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://f0c2.mh8dociw.tw |

http://88.mh8dociw.tw |

http://13.mh8dociw.tw |

http://f7356.mh8dociw.tw |

http://5a2.mh8dociw.tw |

http://9533f.mh8dociw.tw |

蚊帐里的母亲