It insert a new row in a table<\/p>\n
SQL INSERT INTO Syntax<\/strong><\/p>\n It can be used in two form<\/p>\n 1) Without mentioning column names . In that case we must enter values for all fields .<\/p>\n INSERT INTO table_name VALUES (value1, value2.)<\/p>\n 2) By mentioning column names and values<\/p>\n INSERT INTO table_name (column1, column2) VALUES (value1, value2)<\/p>\n MySQL Table – users<\/strong><\/p>\n +—-+——+ Example<\/strong><\/p>\n mysql> INSERT INTO users values(5,”AS”); mysql> select * from users \u00a0; It insert a new row in a table SQL INSERT INTO Syntax It can be used in two form 1) Without mentioning column names . In that case we must enter values for all fields . INSERT INTO table_name VALUES (value1, value2.) 2) By mentioning column names and values INSERT INTO table_name (column1, column2) VALUES … Continue reading SQL INSERT INTO<\/span>
\n| id | name |
\n+—-+——+
\n| \u00a01 | PHP \u00a0|
\n| \u00a02 | JS \u00a0\u00a0|
\n| \u00a03 | HTML |
\n| \u00a04 | PHP \u00a0|
\n+—-+——+<\/p>\n
\nQuery OK, 1 row affected (0.02 sec)<\/p>\n
\n+—-+——+
\n| id | name |
\n+—-+——+
\n| \u00a01 | PHP \u00a0|
\n| \u00a02 | JS \u00a0\u00a0|
\n| \u00a03 | HTML |
\n| \u00a04 | PHP \u00a0|
\n| \u00a05 | AS \u00a0\u00a0|
\n+—-+——+
\n5 rows in set (0.00 sec)<\/p>\n","protected":false},"excerpt":{"rendered":"