泽民博客 ☰ Menu

sqlint Yearning MYSQL

Posted by 夏泽民 Jun 6, 2021

https://github.com/stripe/safesql

阅读全文

SQL条件!=null查不出数据

Posted by 夏泽民 Jun 6, 2021

WHERE ( order_amount != null and order_amount != ‘’ and received_amount != null and received_amount != ‘’ ) 　　查询结果，一条也没有！ 　在SQL中逻辑表达式的可能值包括TRUE、FALSE和UNKNOWN，它们被称之为三值逻辑。

阅读全文

MySQL 字段类型占用空间

Posted by 夏泽民 Jun 6, 2021

TINYINT 1个字节 SMALLINT 2个字节 MEDIUMINT 3个字节 INT, INTEGER 4个字节 BIGINT 8个字节 FLOAT(p) 如果0 <= p <= 24为4个字节, 如果25 <= p <= 53为8个字节 FLOAT 4个字节 DOUBLE [PRECISION], item REAL 4个字节 DECIMAL(M,D), NUMERIC(M,D) 变长（0-4个字节） BIT(M) 大约(M+7)/8个字节 https://blog.csdn.net/free_ant/article/details/52936722

阅读全文

mysql获取表结构

Posted by 夏泽民 Jun 6, 2021

//SELECT TABLE_SCHEMA, TABLE_NAME FROM INFORMATION_SCHEMA.TABLES; //SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA=’schema’ AND TABLE_NAME=’table’; //SHOW FULL COLUMNS FROM ‘table’; //show create table ‘table’; sqlingo 就是通过SHOW FULL COLUMNS FROM ‘table’; 来获取表结构生成orm的结构体，来保证代码和数据库的一致性的。

阅读全文

redismock

Posted by 夏泽民 Jun 6, 2021

https://github.com/go-redis/redismock db, mock := redismock.NewClientMock() mock.ExpectGet(key).RedisNil()

阅读全文

Search

Blog Categories

jekyll (35)
web (334)
technology (2)
php (201)
linux (415)
spark (51)
deep_learning (2)
storage (290)
golang (1081)
cryptology (15)
lang (74)
docker (100)
zookeeper (11)
elasticsearch (86)
java (7)
algorithm (134)
hadoop (2)
slug (1)
architect (46)
k8s (107)
node (82)
python (18)
mysql (42)
rust (4)
elasticSearch (1)
arch (1)
Javascript (1)
kafka (2)
nginx (7)

Popular posts

Anything in here will be replaced on browsers that support the canvas element

Recent posts

Tags

This blog is maintained by 夏泽民

Get in touch with me at 465474307@qq.com

Subscribe to our mailing list

* indicates required