MySQL中的insert set 和 insert values用法

insert into table(col1,col2,col3) values('val1','val2','val3');

insert into table set col1='val1',col2='val2',col3='val3';

mysql> insert into tmp14 values(1);
ERROR 1136 (21S01): Column count doesn't match value count at row 1
mysql> insert into tmp14 set id=1;
Query OK, 1 row affected (0.00 sec)

mysql> select * from tmp14;
+------+---------------------+
| id  | td         |
+------+---------------------+
|  1 | 2022-03-31 16:28:07 |
+------+---------------------+
1 row in set (0.00 sec)

mysql> create table tmp14(id int,td timestamp,td2 timestamp);
ERROR 1067 (42000): Invalid default value for 'td2'

mysql> alter table tmp14 add column td2 timestamp;
ERROR 1067 (42000): Invalid default value for 'td2'

[txadmin@node2 ~]$ psql

txdb_default=# create table tmp14(id int,td timestamp);
CREATE TABLE
txdb_default=# insert into tmp14 set id=1;
ERROR: syntax error at or near "set"
位置: insert into tmp14 set id=1;
            ^