To insert data into a MySQL table, you can use the INSERT INTO statement.

Syntax:

INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);
  • table_name: The name of the table where you want to insert data.
  • (column1, column2, column3, ...): Specify the columns in the table for which you want to insert values.
  • VALUES (value1, value2, value3, ...): Specify the corresponding values for the columns.

Example:

INSERT INTO employees (employee_id, first_name, last_name, hire_date, salary) VALUES (1, 'John', 'Doe', '2022-01-01', 50000.00);

In this example, data is inserted into the employees table for columns employee_id, first_name, last_name, hire_date, and salary.