How to insert data using SQL statements

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

Use SQL statements to operate data tables

ClickSuper in the main interface ofphpMyAdminLink 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.

Execution statement:

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

Execution result:

Successfully added data information:

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 "

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!