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.