Home
Sign Up
Sign In
›
MySQL 5.5 Community Server
›
MySQL 5.6 Community Server
›
Percona Configuration Wizard
›
XtraBackup 搭建主从复制
Great Sites on MySQL
›
Percona
›
MySQL Performance Blog
›
Severalnines
推荐管理工具
›
Sequel Pro
›
phpMyAdmin
推荐书目
›
MySQL Cookbook
MySQL 相关项目
›
MariaDB
›
Drizzle
参考文档
›
http://mysql-python.sourceforge.net/MySQLdb.html
Advertisement
V2EX
›
MySQL
请问mysql如何查询id能被3整除的数据
lusin
·
Mar 7, 2013
· 5746 views
This topic created in 5004 days ago, the information mentioned may be changed or developed.
MySQL
ID
整除
3 replies
•
1970-01-01 08:00:00 +08:00
ljbha007
Mar 7, 2013
1
select * from my_table where id % 3 = 0
cjou
Mar 7, 2013
2
SELECT id From `table` WHERE id mod 3=0;
likexian
Mar 7, 2013
3
http://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.html#function_mod
About
·
Help
·
Advertise
·
Blog
·
API
·
FAQ
·
Privacy
·
Solana
·
952 Online
Highest 6679
·
Select Language
创意工作者们的社区
World is powered by solitude
VERSION: 3.9.8.5 · 35ms ·
UTC 19:48
·
PVG 03:48
·
LAX 11:48
·
JFK 14:48
♥ Do have faith in what you're doing.
❯