php - How should ip2long converted IP's be stored in MySQL?

Question

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

I don't know enough about the function, or ip's, to determine how my column structure should be for storing this. Any suggestions?

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

406 views

1 Answer

深蓝 · Answer 1 · 2021-10-23T18:24:40+0000

answered Oct 24, 2021 by 深蓝 (71.8m points)

Simply use an unsigned INT field for it.

Also see http://lists.mysql.com/cluster/2781 for a discussion about it.

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…