-
select A,B,C,'0' as D from table; D字段值的内容(即‘0’)
-
select A,B,C,(select max(A) from table) as D from table;D字段值的内容为Mac(A)
INSERT INTO t_key_a_info (KEY_ID,
APP_ID,
KEY_NAME,
KEY_CIPHER,
KEY_CHECK,
KEY_ALG,
KEY_PRO_TYPE,
KEY_LENGTH,
KEY_INDEX,
KEY_STATUS,
KEY_VERSION,
ADD_TIME,
UPDATA_TIME,
ARCHIVE_REASON,
DATA_STATUS,
)
SELECT KEY_ID,
APP_ID,
KEY_NAME,
KEY_CIPHER,
KEY_CHECK,
KEY_ALG,
KEY_PRO_TYPE,
KEY_LENGTH,
KEY_INDEX,
KEY_STATUS,
KEY_VERSION,
NOW() AS ADD_TIME,
NOW() AS UPDATA_TIME,
'秘钥过期' AS ARCHIVE_REASON,DATA_STATUS
FROM t_key_info;
select语句查询数据 并新增字段列并赋值
最新推荐文章于 2024-04-29 07:14:23 发布