MySQL Tutorial MySQL Advanced MySQL Database Account Management MySQL References

MySQL VALUES Keyword



The MySQL VALUES keyword is used to specify the values of an MySQL INSERT INTO statement. There are two ways of using VALUES keyword which are mentioned below:

Syntax

The below syntax specifies column names and respective values to be inserted.

INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);

The below syntax specifies values only. Therefore, it is essential to specify values in the same order as the columns in the table.

INSERT INTO table_name 
VALUES (value1, value2, value3, ...);

Example:

Consider a database containing a table called Employee with the following records:

EmpIDNameCityAgeSalary
1JohnLondon253000
2MarryNew York242750
3JoParis272800
4KimAmsterdam303100
5RameshNew Delhi283000
6HuangBeijing282800

  • Using below query, two new records are added in the Employee table:

    INSERT INTO Employee (EmpID, Name, City, Age, Salary)
    VALUES (7, 'Suresh', 'Mumbai', 29, 2900);
    INSERT INTO Employee 
    VALUES (8, 'Zayne', 'Oslo', 31, 3400);
    
    -- see the result
    SELECT * from Employee
    

    Now the Employee table will contain following records:

    EmpIDNameCityAgeSalary
    1JohnLondon253000
    2MarryNew York242750
    3JoParis272800
    4KimAmsterdam303100
    5RameshNew Delhi283000
    6HuangBeijing282800
    7SureshMumbai292900
    8ZayneOslo313400
  • Insert Data Only in Specified Columns: To insert data in specified columns, it is necessary to specify column names. See the example below:

    INSERT INTO Employee (EmpID, Name, Age)
    VALUES (7, 'Suresh', 29);
    
    -- see the result
    SELECT * from Employee
    

    Now the Employee table will contain following records:

    EmpIDNameCityAgeSalary
    1JohnLondon253000
    2MarryNew York242750
    3JoParis272800
    4KimAmsterdam303100
    5RameshNew Delhi283000
    6HuangBeijing282800
    7Suresh 29

❮ MySQL Keywords