Shulou(Shulou.com)06/01 Report--

This article mainly introduces how to use SQL statements to insert data, the article is very detailed, has a certain reference value, interested friends must read it!

Manipulate data tables using SQL statements

Click the hyperlink in the phpMyAdmin main interface, open the SQL statement editing area, and enter the complete SQL statement to query, add, modify and delete data.

Insert data using SQL statements

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.

Execute the statement:

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

Execution result:

Successfully added data information:

For ease of writing, you can use the list of properties to the right to select the column you want to operate on, just select the column you want to add, double-click its option, or click "

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.