To add data to a MySQL database, you can use the following code:
INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);
Here, table_name
is the name of the table in the database where you want to insert data. column1
, column2
, column3
, etc. are the names of the columns in the table that you want to insert values into, and value1
, value2
, value3
, etc. are the actual values that you want to insert.
For example, if you have a table called students
with columns id
, name
, age
, and gender
, and you want to add a new student with an ID of 1, a name of “John Doe”, an age of 20, and a gender of “Male”, you would use the following code:
INSERT INTO students (id, name, age, gender)
VALUES (1, 'John Doe', 20, 'Male');
This will insert a new row into the students
table with the specified values for each column.