CREATE TABLE `test` (

  `id` int(10) NOT NULL AUTO_INCREMENT,

  `user` varchar(50) DEFAULT NULL,

  `create_time` timestamp NULL DEFAULT current_timestamp(),

 UNIQUE KEY `id` (`id`)

) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4;

insert into test values(1, "tony", now());

insert into test values(2, "jack", now());

SELECT COLUMN_NAME, IS_NULLABLE, DATA_TYPE, COLUMN_KEY, EXTRA FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA="test" AND TABLE_NAME="test" ORDER BY ORDINAL_POSITION\G;

*************************** 1. row ***************************

COLUMN_NAME: id

IS_NULLABLE: NO

  DATA_TYPE: int

COLUMN_KEY: PRI

 EXTRA: auto_increment

*************************** 2. row ***************************

COLUMN_NAME: user

IS_NULLABLE: YES

  DATA_TYPE: varchar

 COLUMN_KEY:

      EXTRA:

*************************** 3. row ***************************

COLUMN_NAME: create_time

IS_NULLABLE: YES

  DATA_TYPE: timestamp

 COLUMN_KEY:

      EXTRA:

MariaDB [test]> select id from test1  FORCE INDEX(`PRIMARY`)  where id=2;

ERROR 1146 (42S02): Table 'test.test1' doesn't exist