MariaDB Insert

by Online Tutorials Library July 14, 2022

MariaDB Insert Data

In MariaDB, INSERT INTO statement is used to insert data in a selected table.

Syntax:

 INSERT INTO table (column1, column2, … ) VALUES (expression1, expression2, … ), (expression1, expression2, … ), …;  

You can use it also with WHERE condition.

 INSERT INTO table (column1, column2, … ) SELECT expression1, expression2, … FROM source_table [WHERE conditions];  

Note: While inserting records in MariaDB table, you must provide a value for every NOT NULL column. You can only omit a column if the column allows NULL values.

Example:

Let’s insert some data in “Students” table.

 INSERT INTO Students (student_id, student_name, student_address, admission_date) VALUES(1,’Ajeet’,’Delhi’,’2016-01-07 00:00:00′); 

Mariadb Insert data 1

Now the records are inserted in the table. You can check it by using SELECT statement.

Output:

Mariadb Insert data 2

Insert Multiple Records in Table

You can also insert multiple values in MariaDB table at one time.

Example:

 INSERT INTO Students (student_id, student_name, student_address, admission_date) VALUES (3,’Bret’,’Australia’,’2016-05-07 00:00:00′), (4,’Mahesh’,’Ghaziabad’,’2016-06-07 00:00:00′), (5,’Kanchan’,’Meerut’,’2016-02-07 00:00:00′), (6,’Robert’,’LA’,’2016-08-07 00:00:00′); 

Mariadb Insert data 3

Now check the inserted records by using SELECT statement.

Output:

Mariadb Insert data 4

Next TopicMariaDB Select

MariaDB Insert

MariaDB Insert Data

Note: While inserting records in MariaDB table, you must provide a value for every NOT NULL column. You can only omit a column if the column allows NULL values.

Insert Multiple Records in Table

Smoke Testing

Traditional Marketing

You may also like