Kirisame
  • 首页
  • 归档
  • 分类
  • 关于
  • 友链

Puppet Enterprise outdated version install "apt gpg expired"

Puppet Enterprise在安装的时候提示未验证12345678910111213142025-04-21T09:06:35.553+00:00 - [Error]: Could not update: Execution of '/usr/bin/apt-get -q -y -o DPkg::Options::=--force-confold install pe-java11
2025-04-23

New article deploy way

新的文章部署方式采用Git Action来对文章进行部署推送,只要在本地写好文章后进行分支的push即可完成部署,这篇文章是用来测试的。
2025-04-22
Linux

SQL 索引与数据库安全

SQL 索引与数据库安全INDEX1234567891011121314151617181920212223242526272829303132-- 创建索引CREATE INDEX idx_state ON customers (state);-- 查看索引-- 主键 聚集索引SHOW INDEXES IN customers;+-----------+------------+--------
2023-08-29
Linux

SQL 数据库与表操作

SQL 数据库与表操作DATABASE12CREATE DATABASE DB_NAME;DROP DATABASE DB_NAME; TABLE123456789101112131415161718192021222324252627282930313233343536373839USE DB_NAME;-- 创建表CREATE TABLE customers( customer_id
2023-08-29
Linux

SQL 数据类型

SQL 数据类型字符串类型 STRINGS123456CHAR() -- 存储固定长度字符VARCHAR() -- 存储可变长度字符 ~64KBMEDIUMTEEXT -- 存储很长的字符 16MBLONGTEXT -- 存储巨长的字符 4GBTINYTEXT -- 存储短短的字符 255bytesTXT -
2023-08-28
Linux

SQL TRANSACTON

SQL TRANSACTION事务 TRANSACTION1234567891011-- 类似于一个线程,创建以后会执行里面的SQL语句-- 下面这句用于创建线程START TRANSACTION;INSERT INTO orders (customer_id, order_date, status)VALUES (1, '2019-01-01', 1);INSERT INTO
2023-08-27
Linux

SQL TRIGGER

SQL TRIGGER触发器12345678910111213141516171819202122DELIMITER $$CREATE TRIGGER payments_after_insert AFTER INSERT ON payments FOR EACH ROWBEGIN UPDATE invoices SET payment_total = payment_tot
2023-08-27
Linux

SQL PROCEDURE与函数

SQL PROCEDURE与函数存储过程 Stored Procedure用来存储SQL代码,在开发时使用。 PROCEDURE12345678910111213141516171819202122232425262728293031323334353637383940414243444546-- DELIMITER 修改分隔符DELIMITER $$CREATE PROCEDURE get_cl
2023-08-27
Linux

SQL VIEW

表123456789101112131415161718192021222324252627282930313233-- 表clients+-----------+-------------+--------------------------+---------------+-------+--------------+| client_id | name | address
2023-08-26
Linux

SQL 函数

表12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182-- 表orders+----------+-------------+--------
2023-08-26
Linux
1234

搜索

Hexo Fluid