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');

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

Output:

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');