请问mysql如何查询id能被3整除的数据

V2EX = way to explore

V2EX 是一个关于分享和探索的地方

For Existing Member Sign In

Great Sites on MySQL

› Percona

推荐管理工具

› Sequel Pro

推荐书目

› MySQL Cookbook

MySQL 相关项目

› MariaDB

参考文档

› http://mysql-python.sourceforge.net/MySQLdb.html

This topic created in 4798 days ago, the information mentioned may be changed or developed.

3 replies • 1970-01-01 08:00:00 +08:00

ljbha007

Mar 7, 2013

select * from my_table where id % 3 = 0

cjou

Mar 7, 2013

SELECT id From `table` WHERE id mod 3=0;

likexian

Mar 7, 2013