how to insert values
时间: 2023-07-07 11:43:41 浏览: 104
To insert values into a table, you can use the SQL `INSERT INTO` statement. Here's an example:
```
INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);
```
In this example, you'll need to replace "table_name" with the name of the table you want to insert values into, and "column1", "column2", "column3", etc. with the names of the columns you want to insert values into. You'll also need to specify the corresponding values for each column.
For example, if you wanted to insert a new row into the "customers" table with a customer ID of 1, a name of "John Smith", and an email of "john@example.com", you could use the following code:
```
INSERT INTO customers (customer_id, name, email)
VALUES (1, 'John Smith', 'john@example.com');
```
I hope this helps! Let me know if you have any other questions.
阅读全文