How to insert a value into a column without specifying the column name in MySQL INSERT INTO statement?

In order to insert a value in a column without specifying a column name in the INSERT INTO statement, we must give the number of values ​​that matches the number of columns in the table, and also Note the data type of the column.

Example

In the example below, we inserted the value without specifying the column name.

mysql> Insert into student values(100,'Gaurav','Ph.D');
Query OK, 1 row affected (0.08 sec)

mysql> Select * from student;
+--------+--------+--------+
| RollNO | Name   | Class  |
+--------+--------+--------+
| 100    | Gaurav | Ph.D   |
+--------+--------+--------+

1 row in set (0.00 sec)

mysql> Insert into student values(200,'Rahul','Ph.D'),(300,'Aarav','B.tech');
Query OK, 2 rows affected (0.12 sec)
Records: 2 Duplicates: 0 Warnings: 0

mysql> Select * from student;

+--------+--------+--------+
| RollNO | Name   | Class  |
+--------+--------+--------+
| 100    | Gaurav | Ph.D   |
| 200    | Rahul  | Ph.D   |
| 300    | Aarav  | B.tech |
+--------+--------+--------+

3 rows in set (0.00 sec)

If we don’t care about the total number of columns and their data types, MySQL will throw an error as shown below -

mysql> Insert into student values(400,'Raman',M.Tech);
ERROR 1054 (42S22): Unknown column 'M.Tech' in 'field list'

mysql> Insert into student values(400,'Raman');
ERROR 1136 (21S01): Column count doesn't match value count at row 1

The above is the detailed content of How to insert a value into a column without specifying the column name in MySQL INSERT INTO statement?. For more information, please follow other related articles on the PHP Chinese website!