Insert Specific Columns In MySQL Tutorial Example

How To Insert Specific Columns In MySQL Tutorial Example

Open your MySQL Query Editor then copy & paste the below code to Insert specific columns into a database table "test" in MySQL Database Server

-- How To Insert Specific Columns In MySQL Tutorial Example

INSERT INTO  test(TestName,TestAge) VALUES ('Noor.Hasan', 28);

-- that's it!! a row with specific columns has been inserted in mysql database table "test"

      -- is comment in MySQL
      -- in fact it is comment in MSSQL and Oracle as well
   

How To Insert Specific Columns In MySQL Tutorial Example - Result in MySQL Query Editor

 

Related Tutorial Examples

1. MySQL least() Function Numeric Value Example
2. MySQL greatest() Function Datetime Example
3. MySQL now() Datetime Function Example
4. MySQL greatest() Function String Value Example
5. MySQL greatest() Function Numeric Value Example
6. Inserting data into Table(s) using SQL Command MySQL Example
7. MySQL Stored Procedure: INSERT INTO SELECT... Example
8. 20 steps to make CakePHP Blog Project