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

MySQL insert data

INSERT INTOSQL statements are used in the MySQL table to insert data.

You can insert data into the datasheet through the mysql > command prompt window, or through the PHP script.

Grammar

The following is the common INSERT INTOSQL syntax for inserting data into an MySQL data table:

INSERT INTO table_name (field1, field2,...fieldN) VALUES (value1, value2,...valueN)

If the data is character type, you must use single or double quotation marks, such as "value".

Insert data through the command prompt window

Here we will use the SQL INSERT INTO statement to insert data into the MySQL data table runoob_tbl

Example

In the following example, we will insert three pieces of data into the runoob_tbl table:

Root@host# mysql-u root-p password;Enter password:*mysql > use RUNOOB;Database changedmysql > INSERT INTO runoob_tbl-> (runoob_title, runoob_author, submission_date)-> VALUES-> ("Learning PHP", "Rookie course", NOW ()) Query OK, 1 rows affected, 1 warnings (0.01sec) mysql > INSERT INTO runoob_tbl-> (runoob_title, runoob_author, submission_date)-> VALUES-> ("Learning MySQL", "Rookie course", NOW ()) Query OK, 1 rows affected, 1 warnings (0.01 sec) mysql > INSERT INTO runoob_tbl-> (runoob_title, runoob_author, submission_date)-> VALUES-> ("JAVA tutorial", "RUNOOB.COM", '2016-05-06'); Query OK, 1 rows affected (0.00 sec) mysql >

Note: using the arrow mark-> is not part of the SQL statement, it just represents a new line. If a SQL statement is too long, we can use the enter key to create a new line to write the SQL statement. The command Terminator of the SQL statement is a semicolon.

In the above example, we did not provide the data for runoob_id because we set it to the AUTO_INCREMENT property when we created the table. Therefore, this field is automatically incremented without us to set it. In the instance, NOW () is a MySQL function that returns a date and time.

Next, we can view the data table data with the following statement:

Read the data table:

Select * from runoob_tbl

Output result:

Insert data using PHP scripts

You can use the mysqli_query () function of PHP to execute the SQL INSERT INTO command to insert data.

This function takes two arguments and returns TRUE on successful execution, or FALSE otherwise.

Syntax mysqli_query (connection,query,resultmode); parameter description connection is required. Specifies the MySQL connection to be used. Query is required, specifying the query string. Resultmode

Optional. A constant. It can be any of the following values:

MYSQLI_USE_RESULT (use this if you need to retrieve a large amount of data)

MYSQLI_STORE_RESULT (default)

Example

In the following example, the program receives three field data entered by the user and inserts it into the data table:

Add data

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.