Home  >  Article  >  Database  >  How to insert data using SQL statements

How to insert data using SQL statements

藏色散人
藏色散人forward
2019-11-27 18:03:345710browse

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')

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!

Statement:
This article is reproduced at:cnblogs.com. If there is any infringement, please contact admin@php.cn delete