- 博客(2)
- 资源 (2)
- 收藏
- 关注
原创 在Navicat中呈现数据字典
USE information_schema;//这个不要变 SELECT C.COLUMN_NAME AS '字段名', C.COLUMN_TYPE AS '数据类型', C.IS_NULLABLE AS '允许为空', C.EXTRA AS 'PK', C.COLUMN_COMMENT AS '字段说明' FROM COLUMNS C INNER JOIN TABLES T ON C.TABLE_SCHEMA = T.TABLE_SCHEMA AND ...
2021-06-29 14:32:52
499
原创 如何在SQL数据库通过触发器自动插入最新的时间哪
create trigger remark_time on remark instead of insert as begin transaction begin declare @remarkid int,@novelid int,@userid int ,@con nvarchar(500) select @remarkid= remark_id from inserted select @novelid= novel_id from inserted select @userid= ...
2021-06-25 10:25:51
680
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人