Discover gists NET牛人

123 gists results Add gist

热词

install-onlyoffice git filter-branch backup_sqlserver PostgreSQL-Manager netstat-nc tcping backup_mysql backup_oracle install-dotnet install-azuresqledge git-clear-history git-ssh openssl-ssl iptables ufw install-PostgreSQL dotnet-publish crontab locale fdisk-lsblk mysql-datadir install-mysql8 netsh-http aspnet_regiis install-iis docker-oracle docker-manager npm-publish nodejs-common vscode-remote-ssh profile oracle_expdp_impdp ncu OracleManager frp sqlserver-backup-database dead_link_detection ln firewall-cmd-iptables zip-tar rwx ab netsh-interface install-docker install-nodejs yum ifcfg acme swap git-guide kill-nohup install-nginx clock mysqldump Scaffold-DbContext install-mysql5.7 nginx install-sqlserver cmd sqlcmd-sa kernel nginx-proxy_pass wget bbr ssh

netnr/ drop.sql 2018-09-21 14:18

SqlServer 删除所有表

-- 删除所有表
DECLARE @sql VARCHAR(8000);
WHILE EXISTS (SELECT name FROM sysobjects WHERE type = 'U')
BEGIN
    SELECT @sql = 'DROP TABLE ' + name
    FROM sysobjects
    WHERE (type = 'U');

    PRINT (@sql);

查看详情

netnr/ truncate.sql 2018-09-21 14:16

truncate 清空所有表，mysql 数据库

-- 生成清理所有表语句;
SELECT CONCAT('truncate TABLE ', TABLE_SCHEMA, '.', TABLE_NAME, ';')
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA IN ( '数据库名' );

查看详情

netnr/ Scaffold-DbContext 2018-09-21 11:37

dotnet ef core 生成实体

# 公共依赖
Install-Package Microsoft.EntityFrameworkCore.Tools

# MySQL
Install-Package Pomelo.EntityFrameworkCore.MySql
Scaffold-DbContext "Server=.;Port=3306;Database=netnr;uid=root;pwd=123" Pomelo.EntityFrameworkCore.MySql -Force -UseDatabaseNames -DataAnnotations -NoPluralize -NoOnConfiguring -Context ContextBase

#SQLServer
Install-Package Microsoft.EntityFrameworkCore.SqlServer
Scaffold-DbContext "Server=.;Database=netnr;uid=sa;pwd=123" Microsoft.EntityFrameworkCore.SqlServer

查看详情

netnr/ install-mysql5.7.sh 2018-09-20 14:22

linux 安装 MySQL5.7

wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm
rpm -ivh mysql57-community-release-el7-9.noarch.rpm
yum install mysql-server

mysqld --initialize # 初始化

chown mysql:mysql -R /var/lib/mysql # 设置权限

systemctl start mysqld  # 启动
service mysqld restart  # 重启

查看详情

netnr/ nginx.conf 2018-08-28 22:47

nginx 配置文件

####### nginx.conf
user www www;

worker_processes auto;
worker_cpu_affinity auto;

error_log /home/wwwlogs/nginx_error.log crit;

pid /usr/local/nginx/logs/nginx.pid;

查看详情

netnr/ B站自动答题.js 2018-08-19 17:31

B站自动答题

var bbk = {
    //问题序号
    qno: 0,
    //答案序号
    ano: 0,
    init: function () {
        bbk.answer();
    },
    /**当前题目序号 */
    currNo: function () {

查看详情

netnr/ install-sqlserver 2018-12-07 08:02

CentOS7安装mssql-server

# 下载 Microsoft SQL Server Red Hat 存储库配置文件
curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server-2019.repo

yum install mssql-server # 安装

# 更改2GB内存限制为512MB（可选）
cd /opt/mssql/bin
mv sqlservr sqlservr.old
python
oldfile = open("sqlservr.old", "rb").read()

查看详情

netnr/ cmd 2018-12-29 21:58

Windows 常用命令操作记录

# 修改密码
net user Administrator 123

# 启用 Administrator 管理员账号
net user Administrator /active:yes

# 查看计算机名称
hostname

# wmic 命令系列

查看详情

netnr/ sqlcmd-sa 2018-12-29 17:10

sqlcmd命令模式启用SQLServer管理员账号sa远程登录

# 连接
sqlcmd -S .

# 启用sa
alter login sa enable

# 设置sa密码
alter login sa with password="Abc123!@#"

# 启用混合模式登录，修改注册表 regedit

查看详情

netnr/ kernel.sh 2018-12-18 23:42

CentOS 升级内核，BBR 内核要求为 4.9

uname -r # 查看内核

rpm -import https://www.elrepo.org/RPM-GPG-KEY-elrepo.org # 导入ELRepo仓库的公共密钥

rpm -Uvh http://www.elrepo.org/elrepo-release-7.0-3.el7.elrepo.noarch.rpm # CentOS 7

yum install https://www.elrepo.org/elrepo-release-8.el8.elrepo.noarch.rpm # CentOS 8

yum --disablerepo="*" --enablerepo="elrepo-kernel" list available # 查看
yum --enablerepo=elrepo-kernel install kernel-ml.x86_64 kernel-ml-devel.x86_64 # 安装

查看详情

热词

链接