maria-db
  1. maria-db-insert
PreviousNext

Insert - (MariaDB CRUD Operation)

In MariaDB, insert is one of the four basic operations of CRUD (Create, Read, Update, and Delete) that can be performed on a database. It allows you to add new records to a table.

Syntax

The syntax for inserting data into a MariaDB table is as follows:

INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);

Here, table_name is the name of the table you want to insert data into, column1, column2, column3, etc. are the names of the columns you want to insert data into, and value1, value2, value3, etc. are the values you want to insert into those columns.

If you want to insert data into all columns in the table, you can omit the column list as follows:

INSERT INTO table_name
VALUES (value1, value2, value3, ...);

Example

INSERT INTO employees (first_name, last_name, hire_date, job_title, salary)
VALUES ('John', 'Doe', '2021-01-01', 'Developer', 50000.00);

Output

The above SQL statement will insert a new record into the employees table with the values John for first_name, Doe for last_name, 2021-01-01 for hire_date, Developer for job_title, and 50000.00 for salary.

Explanation

In the above example, we are inserting a new record into the employees table with the specified values for first_name, last_name, hire_date, job_title, and salary.

Use

The insert operation can be used to add new records to a MariaDB table, which is useful for populating a database with initial data or adding new data as it becomes available.

Important Points

  • Insert is one of the four basic operations of CRUD (Create, Read, Update, and Delete) that can be performed on a MariaDB database.
  • The syntax for inserting data into a MariaDB table includes specifying the table name, column names, and values to be inserted.
  • If the column names are omitted, data will be inserted into all columns in the table.
  • The insert operation is useful for adding new records to a MariaDB table.

Summary

In summary, the insert operation in MariaDB allows you to add new records to a database table. The syntax includes specifying the table name, column names, and values to be inserted. This operation is useful for populating a database with initial data or adding new data as it becomes available.

Drop TableSelect
Published on: