How to add data code to the table in navicat

There are the following methods to add data to a table in Navicat: Insert a single piece of data: Use the INSERT INTO statement to specify the table name, column name and value. To insert multiple pieces of data in batches: Use the INSERT INTO statement, enclosing the list of values ​​in parentheses. Insert data from another table: Use the SELECT statement to select data from another table and insert it into the target table. Insert the result of an expression or function: Use the INSERT INTO statement to insert the result of an expression or function as a value. Inserting NULL values: Use the INSERT INTO statement with NULL as the value. Insert data using prepared statements: Create a prepared statement, set parameter values, and then execute the code in

Navicat to add data to the table

Insert a single piece of data

<code class="sql">INSERT INTO table_name (column_name1, column_name2, ...) VALUES (value1, value2, ...);</code>

Insert multiple pieces of data in batches

<code class="sql">INSERT INTO table_name (column_name1, column_name2, ...) VALUES
(value11, value12, ...),
(value21, value22, ...),
...;</code>

Insert from another table Selected data

<code class="sql">INSERT INTO table_name (column_name1, column_name2, ...)
SELECT column_name1, column_name2, ...
FROM another_table_name
WHERE condition;</code>

Insert the result of an expression or function

<code class="sql">INSERT INTO table_name (column_name) VALUES (expression_or_function());</code>

Insert NULL value

<code class="sql">INSERT INTO table_name (column_name) VALUES (NULL);</code>

Insert data using prepared statements

<code class="java">// 创建一个预处理语句
PreparedStatement statement = connection.prepareStatement("INSERT INTO table_name (column_name1, column_name2, ...) VALUES (?, ?, ...);");

// 设置参数值
statement.setString(1, "value1");
statement.setInt(2, 123);

// 执行预处理语句
statement.executeUpdate();</code>

Example

Insert data into the table named "employees":

<code class="sql">-- 插入单条数据
INSERT INTO employees (name, email) VALUES ('John Smith', 'john.smith@example.com');

-- 批量插入数据
INSERT INTO employees (name, email) VALUES
('Jane Doe', 'jane.doe@example.com'),
('Peter Jones', 'peter.jones@example.com');

-- 从另一个表插入数据
INSERT INTO employees (name, email)
SELECT name, email
FROM users
WHERE role = 'employee';</code>

The above is the detailed content of How to add data code to the table in navicat. For more information, please follow other related articles on the PHP Chinese website!