Insert Single Row In MySQL Table Tutorial Example

How To Insert Single Row In MySQL Table Tutorial Example

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

   -- How To Insert Single Row In MySQL Table Tutorial Example

   INSERT INTO  test(TestID ,TestName,TestAge) VALUES (1 , 'Donald', 33);

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

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

How To Insert Single Row In MySQL Table Tutorial Example - Result in MySQL Query Editor

 

Related Tutorial Examples

1. MySQL concat function columns string SQL Example
2. MySQL concat function columns Aliase SQL Example
3. MySQL concat function columns SQL Example
4. MySQL concat function character string Aliase SQL Example
5. MySQL concat function string Aliase SQL Example
6. Creating Database(s) using SQL Command MySQL Example
7. MySQL Stored Procedure Function: How to Drop a Function Example
8. 20 steps to make CakePHP Blog Project