Home > Database > phpMyAdmin > body text

How to insert data using SQL statements

藏色散人
Release: 2019-11-27 18:03:34
forward
5720 people have browsed it

The following column phpmyadmin usage tutorial will introduce you to the method of inserting data using SQL statements. I hope it will be helpful to friends in need!

How to insert data using SQL statements

Use SQL statements to operate data tables

Click Super in the main interface of phpMyAdminHow to insert data using SQL statements Link to open the SQL statement editing area and enter the complete SQL statement to query, add, modify and delete data.

Use SQL statements to insert data

Use the insert statement to insert data into the data table tb_admin, and click the "Execute" button to insert a piece of data into the data table.

How to insert data using SQL statements

Execution statement:

insert into tb_admin(`name`,`pwd`) values('tm','111')
Copy after login

Execution result:

How to insert data using SQL statements

Successfully added data information:

How to insert data using SQL statements

For the convenience of writing, you can use the attribute list on the right to select the column to be operated. Just select the column you want to add, double-click its option or click the "

How to insert data using SQL statements

The above is the detailed content of How to insert data using SQL statements. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:cnblogs.com
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template