Insert Rows In MySQL Table Tutorial Example

How To Insert Rows In MySQL Table Tutorial Example

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

-- How To Insert Rows In MySQL Table Tutorial Example

INSERT INTO  test(TestID ,TestName,TestAge) VALUES
(2 , 'Douglas', 34),
(3 , 'Jennifer', 35),
(4 , 'Michael', 49),
(5 , 'Pat', 40),
(6 , 'Susan', 55),
(7 , 'Hermann', 53),
(8 , 'Shelley', 29),
(9 , 'William', 21),
(10, 'Alexander', 42);

-- that's it!! some rows have 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 Rows In MySQL Table Tutorial Example - Result in MySQL Query Editor

 

Related Tutorial Examples

1. MySQL greatest() Function String Value Example
2. MySQL group concat function SQL Example
3. MySQL concat function rows SQL Example
4. MySQL concat function SQL Aliase Example
5. MySQL concat columns string Aliase SQL Example
6. Creating a Table(s) with datatype using SQL Command MySQL Example
7. MySQL Stored Procedure: CREATE TABLE SELECT... Example
8. 20 steps to make CakePHP Blog Project