INSERT a row record (INSERT) _ MySQL

INSERT a row record (INSERT) into a MySQL data table INSERT new data using the INSERT statement

Syntax: INSERT [INTO] tbl_name [(col_name,...)] VALUES (pression ,...),...

INSERT [INTO] tbl_name SET col_name = expression ,...

Let's start to use the INSERT statement to add records. this is an SQL statement. you need to specify the table for which you want to INSERT data rows or the table that puts values by row. The INSERT statement has several forms:

You can specify the values of all columns:

For example:

Shell> mysql