Basic usage of insert statement

The INSERT statement is typically used to add new rows of data to a relational database table. The following is the basic `INSERT` syntax:

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

where "table_name" is the name of the table you want to insert values ​​into, and "column1, column2, column3" in brackets after it lists all the columns in the table or Specify column names into which you can insert values.

Next, after the `VALUES` keyword, you need to list the corresponding values ​​to correspond to the previously listed columns.

For example, if you have a table named "`employees`" with 3 columns: `id` (integer type), `name` (string type) and `salary` (float type) point type), to add an employee row, enter the following SQL statement:

```sql
INSERT INTO employees (id, name, salary)
VALUES (1, 'John Smith', 48000.00);
```

This `INSERT` statement will add "id" as "1", "name" as "John Smith" and "salary" Add a new row for "48000.00" to the "employees" table.

The above is the detailed content of Basic usage of insert statement. For more information, please follow other related articles on the PHP Chinese website!