求这样一个查询语句!取出不连续记录 MYSQL 中如何选出几个不连续记录:取出某个字段 中第1条,第6条,第12条,第24条记录(这几条记录之间没有任何联系),用一条select 语句能否实现?是不是要用到limit 子句?求解! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 贴建表及插入记录的SQL,及要求结果出来看看 表结构如下:-- phpMyAdmin SQL Dump-- version 3.4.5-- http://www.phpmyadmin.net---- 主机: localhost-- 生成日期: 2012 年 03 月 06 日 01:35-- 服务器版本: 5.5.16-- PHP 版本: 5.3.8SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";SET time_zone = "+00:00";/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;/*!40101 SET NAMES utf8 */;---- 数据库: `desces`---- ------------------------------------------------------------ 表的结构 `z_jiage`--CREATE TABLE IF NOT EXISTS `z_jiage` ( `id` int(11) NOT NULL AUTO_INCREMENT, `jiage` double(10,2) NOT NULL, `item_id` int(10) NOT NULL, `add_date` date NOT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=193 ;---- 转存表中的数据 `z_jiage`--INSERT INTO `z_jiage` (`id`, `jiage`, `item_id`, `add_date`) VALUES(1, 6.00, 35, '1998-01-01'),(2, 6.00, 35, '1998-02-01'),(3, 5.00, 35, '1998-03-01'),(4, 5.00, 35, '1998-04-01'),(5, 5.00, 35, '1998-05-01'),(6, 4.00, 35, '1998-06-01'),(7, 5.00, 35, '1998-07-01'),(8, 5.00, 35, '1998-08-01'),(9, 5.00, 35, '1998-08-01'),(10, 5.00, 35, '1998-10-01'),(11, 5.00, 35, '1998-11-01'),(12, 5.00, 35, '1998-12-01'),(13, 5.00, 35, '1999-01-01'),(14, 5.00, 35, '1999-02-01'),(15, 5.00, 35, '1999-03-01'),(16, 5.00, 35, '1999-04-01'),(17, 5.00, 35, '1999-05-01'),(18, 5.00, 35, '1999-06-01'),(19, 5.00, 35, '1999-07-01'),(20, 5.00, 35, '1999-08-01'),(21, 5.00, 35, '1999-08-01'),(22, 5.00, 35, '1999-10-01'),(23, 5.00, 35, '1999-11-01'),(24, 5.50, 35, '1999-12-01'),(25, 5.50, 35, '2000-01-01'),(26, 5.50, 35, '2000-02-01'),(27, 5.50, 35, '2000-03-01'),(28, 5.50, 35, '2000-04-01'),(29, 5.50, 35, '2000-05-01'),(30, 5.50, 35, '2000-06-01'),(31, 5.50, 35, '2000-07-01'),(32, 5.50, 35, '2000-08-01'),(33, 5.50, 35, '2000-08-01'),(34, 2.80, 35, '2000-10-01'),(35, 2.80, 35, '2000-11-01'),(36, 2.80, 35, '2000-12-01'),(37, 2.80, 35, '2001-01-01'),(38, 2.80, 35, '2001-02-01'),(39, 2.80, 35, '2001-03-01'),(40, 2.80, 35, '2001-04-01'),(41, 2.80, 35, '2001-05-01'),(42, 2.80, 35, '2001-06-01'),(43, 2.80, 35, '2001-07-01'),(44, 2.60, 35, '2001-08-01'),(45, 2.60, 35, '2001-08-01'),(46, 2.60, 35, '2001-10-01'),(47, 2.60, 35, '2001-11-01'),(48, 2.60, 35, '2001-12-01'),(49, 2.50, 35, '2002-01-01'),(50, 2.50, 35, '2002-02-01'),(51, 2.50, 35, '2002-03-01'),(52, 2.50, 35, '2002-04-01'),(53, 2.50, 35, '2002-05-01'),(54, 2.50, 35, '2002-06-01'),(55, 2.50, 35, '2002-07-01'),(56, 2.50, 35, '2002-08-01'),(57, 2.50, 35, '2002-08-01'),(58, 2.50, 35, '2002-10-01'),(59, 2.50, 35, '2002-11-01'),(60, 2.50, 35, '2002-12-01'),(61, 2.80, 35, '2003-01-02'),(62, 2.80, 35, '2003-02-02'),(63, 2.80, 35, '2003-03-02'),(64, 2.80, 35, '2003-04-02'),(65, 3.00, 35, '2003-05-02'),(66, 2.80, 35, '2003-06-02'),(67, 2.80, 35, '2003-07-02'),(68, 2.80, 35, '2003-08-02'),(69, 2.80, 35, '2003-08-02'),(70, 2.80, 35, '2003-10-02'),(71, 2.80, 35, '2003-11-02'),(72, 2.80, 35, '2003-12-02'),(73, 2.80, 35, '2004-01-02'),(74, 2.80, 35, '2004-02-02'),(75, 5.50, 35, '2004-03-02'),(76, 6.00, 35, '2004-04-02'),(77, 6.00, 35, '2004-05-02'),(78, 5.50, 35, '2004-06-02'),(79, 5.50, 35, '2004-07-02'),(80, 6.50, 35, '2004-08-02'),(81, 6.50, 35, '2004-08-02'),(82, 7.00, 35, '2004-10-02'),(83, 7.00, 35, '2004-11-02'),(84, 7.50, 35, '2004-12-02'),(85, 7.30, 35, '2005-01-02'),(86, 7.30, 35, '2005-02-02'),(87, 11.00, 35, '2005-03-02'),(88, 11.00, 35, '2005-04-02'),(89, 11.00, 35, '2005-05-02'),(90, 11.00, 35, '2005-06-02'),(91, 11.00, 35, '2005-07-02'),(92, 8.00, 35, '2005-08-02'),(93, 8.00, 35, '2005-08-02'),(94, 6.50, 35, '2005-10-02'),(95, 7.50, 35, '2005-11-02'),(96, 7.50, 35, '2005-12-02'),(97, 7.00, 35, '2006-01-02'),(98, 7.00, 35, '2006-02-02'),(99, 7.00, 35, '2006-03-02'),(100, 7.00, 35, '2006-04-02'),(101, 7.00, 35, '2006-05-02'),(102, 7.00, 35, '2006-06-02'),(103, 7.00, 35, '2006-07-02'),(104, 7.00, 35, '2006-08-02'),(105, 7.00, 35, '2006-08-02'),(106, 5.00, 35, '2006-10-02'),(107, 5.00, 35, '2006-11-02'),(108, 5.00, 35, '2006-12-02'),(109, 5.00, 35, '2007-01-02'),(110, 5.00, 35, '2007-02-02'),(111, 5.00, 35, '2007-03-02'),(112, 5.00, 35, '2007-04-02'),(113, 5.00, 35, '2007-05-02'),(114, 5.00, 35, '2007-06-02'),(115, 5.50, 35, '2007-07-02'),(116, 5.50, 35, '2007-08-02'),(117, 5.50, 35, '2007-08-02'),(118, 8.00, 35, '2007-10-02'),(119, 8.00, 35, '2007-11-02'),(120, 8.00, 35, '2007-12-02'),(121, 8.00, 35, '2008-01-02'),(122, 8.00, 35, '2008-02-02'),(123, 8.00, 35, '2008-03-02'),(124, 8.00, 35, '2008-04-02'),(125, 7.00, 35, '2008-05-02'),(126, 7.00, 35, '2008-06-02'),(127, 7.00, 35, '2008-07-02'),(128, 7.00, 35, '2008-08-02'),(129, 7.00, 35, '2008-08-02'),(130, 8.00, 35, '2008-10-02'),(131, 7.00, 35, '2008-11-02'),(132, 5.50, 35, '2008-12-02'),(133, 5.50, 35, '2009-01-02'),(134, 5.50, 35, '2009-02-02'),(135, 5.50, 35, '2009-03-02'),(136, 5.50, 35, '2009-04-02'),(137, 7.00, 35, '2009-05-02'),(138, 7.00, 35, '2009-06-02'),(139, 7.00, 35, '2009-07-02'),(140, 7.00, 35, '2009-08-02'),(141, 7.00, 35, '2009-08-02'),(142, 7.00, 35, '2009-10-02'),(143, 8.50, 35, '2009-11-02'),(144, 10.00, 35, '2009-12-02'),(145, 12.00, 35, '2010-01-02'),(146, 12.00, 35, '2010-02-02'),(147, 12.00, 35, '2010-03-02'),(148, 12.00, 35, '2010-04-02'),(149, 12.00, 35, '2010-05-02'),(150, 14.50, 35, '2010-06-02'),(151, 14.00, 35, '2010-07-02'),(152, 12.00, 35, '2010-08-02'),(153, 12.00, 35, '2010-08-02'),(154, 16.00, 35, '2010-10-02'),(155, 17.00, 35, '2010-11-02'),(156, 17.00, 35, '2010-12-02'),(157, 15.00, 35, '2011-01-02'),(158, 15.00, 35, '2011-02-02'),(159, 15.00, 35, '2011-03-02'),(160, 15.00, 35, '2011-04-02'),(161, 15.00, 35, '2011-05-02'),(162, 15.00, 35, '2011-06-02'),(163, 15.00, 35, '2011-07-02'),(164, 15.00, 35, '2011-08-02'),(165, 15.00, 35, '2011-08-02'),(166, 8.00, 35, '2011-10-02'),(167, 9.00, 35, '2011-11-02'),(168, 8.50, 35, '2011-12-02');/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;现在就是要选出表 z_jiage 中 若干条不相干的记录,如中第1条,第7条,第12条,第25条,按照 日期add_time字段排序 select * from z_jiage where id in (1,7,12,25); 数据库连接加上characterEncoding=utf8后,控制台输出感叹号 相关文章 的实现方法。 数据外调出现一下错误,请高手帮忙解决 mysql 查询 延时 mysql里如何得到格林时间 ? MYSQL数据丢失,查看MYD文件,内容还在,MYISAMCHK检查提示Data records:0 Deleted blocks:4218,能否恢复? 怎么没有人帮我啊,这个问题我提出来很久啦 修改用户密码??? 装了个MYSQL是否影响开机的速度. MYSQl千万级数据构造树效率,求高手 mysql批量删除数据的存储过程怎么写 求一个sql语句,关于导入数据的
-- phpMyAdmin SQL Dump
-- version 3.4.5
-- http://www.phpmyadmin.net
--
-- 主机: localhost
-- 生成日期: 2012 年 03 月 06 日 01:35
-- 服务器版本: 5.5.16
-- PHP 版本: 5.3.8SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;--
-- 数据库: `desces`
---- ----------------------------------------------------------
-- 表的结构 `z_jiage`
--CREATE TABLE IF NOT EXISTS `z_jiage` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`jiage` double(10,2) NOT NULL,
`item_id` int(10) NOT NULL,
`add_date` date NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=193 ;--
-- 转存表中的数据 `z_jiage`
--INSERT INTO `z_jiage` (`id`, `jiage`, `item_id`, `add_date`) VALUES
(1, 6.00, 35, '1998-01-01'),
(2, 6.00, 35, '1998-02-01'),
(3, 5.00, 35, '1998-03-01'),
(4, 5.00, 35, '1998-04-01'),
(5, 5.00, 35, '1998-05-01'),
(6, 4.00, 35, '1998-06-01'),
(7, 5.00, 35, '1998-07-01'),
(8, 5.00, 35, '1998-08-01'),
(9, 5.00, 35, '1998-08-01'),
(10, 5.00, 35, '1998-10-01'),
(11, 5.00, 35, '1998-11-01'),
(12, 5.00, 35, '1998-12-01'),
(13, 5.00, 35, '1999-01-01'),
(14, 5.00, 35, '1999-02-01'),
(15, 5.00, 35, '1999-03-01'),
(16, 5.00, 35, '1999-04-01'),
(17, 5.00, 35, '1999-05-01'),
(18, 5.00, 35, '1999-06-01'),
(19, 5.00, 35, '1999-07-01'),
(20, 5.00, 35, '1999-08-01'),
(21, 5.00, 35, '1999-08-01'),
(22, 5.00, 35, '1999-10-01'),
(23, 5.00, 35, '1999-11-01'),
(24, 5.50, 35, '1999-12-01'),
(25, 5.50, 35, '2000-01-01'),
(26, 5.50, 35, '2000-02-01'),
(27, 5.50, 35, '2000-03-01'),
(28, 5.50, 35, '2000-04-01'),
(29, 5.50, 35, '2000-05-01'),
(30, 5.50, 35, '2000-06-01'),
(31, 5.50, 35, '2000-07-01'),
(32, 5.50, 35, '2000-08-01'),
(33, 5.50, 35, '2000-08-01'),
(34, 2.80, 35, '2000-10-01'),
(35, 2.80, 35, '2000-11-01'),
(36, 2.80, 35, '2000-12-01'),
(37, 2.80, 35, '2001-01-01'),
(38, 2.80, 35, '2001-02-01'),
(39, 2.80, 35, '2001-03-01'),
(40, 2.80, 35, '2001-04-01'),
(41, 2.80, 35, '2001-05-01'),
(42, 2.80, 35, '2001-06-01'),
(43, 2.80, 35, '2001-07-01'),
(44, 2.60, 35, '2001-08-01'),
(45, 2.60, 35, '2001-08-01'),
(46, 2.60, 35, '2001-10-01'),
(47, 2.60, 35, '2001-11-01'),
(48, 2.60, 35, '2001-12-01'),
(49, 2.50, 35, '2002-01-01'),
(50, 2.50, 35, '2002-02-01'),
(51, 2.50, 35, '2002-03-01'),
(52, 2.50, 35, '2002-04-01'),
(53, 2.50, 35, '2002-05-01'),
(54, 2.50, 35, '2002-06-01'),
(55, 2.50, 35, '2002-07-01'),
(56, 2.50, 35, '2002-08-01'),
(57, 2.50, 35, '2002-08-01'),
(58, 2.50, 35, '2002-10-01'),
(59, 2.50, 35, '2002-11-01'),
(60, 2.50, 35, '2002-12-01'),
(61, 2.80, 35, '2003-01-02'),
(62, 2.80, 35, '2003-02-02'),
(63, 2.80, 35, '2003-03-02'),
(64, 2.80, 35, '2003-04-02'),
(65, 3.00, 35, '2003-05-02'),
(66, 2.80, 35, '2003-06-02'),
(67, 2.80, 35, '2003-07-02'),
(68, 2.80, 35, '2003-08-02'),
(69, 2.80, 35, '2003-08-02'),
(70, 2.80, 35, '2003-10-02'),
(71, 2.80, 35, '2003-11-02'),
(72, 2.80, 35, '2003-12-02'),
(73, 2.80, 35, '2004-01-02'),
(74, 2.80, 35, '2004-02-02'),
(75, 5.50, 35, '2004-03-02'),
(76, 6.00, 35, '2004-04-02'),
(77, 6.00, 35, '2004-05-02'),
(78, 5.50, 35, '2004-06-02'),
(79, 5.50, 35, '2004-07-02'),
(80, 6.50, 35, '2004-08-02'),
(81, 6.50, 35, '2004-08-02'),
(82, 7.00, 35, '2004-10-02'),
(83, 7.00, 35, '2004-11-02'),
(84, 7.50, 35, '2004-12-02'),
(85, 7.30, 35, '2005-01-02'),
(86, 7.30, 35, '2005-02-02'),
(87, 11.00, 35, '2005-03-02'),
(88, 11.00, 35, '2005-04-02'),
(89, 11.00, 35, '2005-05-02'),
(90, 11.00, 35, '2005-06-02'),
(91, 11.00, 35, '2005-07-02'),
(92, 8.00, 35, '2005-08-02'),
(93, 8.00, 35, '2005-08-02'),
(94, 6.50, 35, '2005-10-02'),
(95, 7.50, 35, '2005-11-02'),
(96, 7.50, 35, '2005-12-02'),
(97, 7.00, 35, '2006-01-02'),
(98, 7.00, 35, '2006-02-02'),
(99, 7.00, 35, '2006-03-02'),
(100, 7.00, 35, '2006-04-02'),
(101, 7.00, 35, '2006-05-02'),
(102, 7.00, 35, '2006-06-02'),
(103, 7.00, 35, '2006-07-02'),
(104, 7.00, 35, '2006-08-02'),
(105, 7.00, 35, '2006-08-02'),
(106, 5.00, 35, '2006-10-02'),
(107, 5.00, 35, '2006-11-02'),
(108, 5.00, 35, '2006-12-02'),
(109, 5.00, 35, '2007-01-02'),
(110, 5.00, 35, '2007-02-02'),
(111, 5.00, 35, '2007-03-02'),
(112, 5.00, 35, '2007-04-02'),
(113, 5.00, 35, '2007-05-02'),
(114, 5.00, 35, '2007-06-02'),
(115, 5.50, 35, '2007-07-02'),
(116, 5.50, 35, '2007-08-02'),
(117, 5.50, 35, '2007-08-02'),
(118, 8.00, 35, '2007-10-02'),
(119, 8.00, 35, '2007-11-02'),
(120, 8.00, 35, '2007-12-02'),
(121, 8.00, 35, '2008-01-02'),
(122, 8.00, 35, '2008-02-02'),
(123, 8.00, 35, '2008-03-02'),
(124, 8.00, 35, '2008-04-02'),
(125, 7.00, 35, '2008-05-02'),
(126, 7.00, 35, '2008-06-02'),
(127, 7.00, 35, '2008-07-02'),
(128, 7.00, 35, '2008-08-02'),
(129, 7.00, 35, '2008-08-02'),
(130, 8.00, 35, '2008-10-02'),
(131, 7.00, 35, '2008-11-02'),
(132, 5.50, 35, '2008-12-02'),
(133, 5.50, 35, '2009-01-02'),
(134, 5.50, 35, '2009-02-02'),
(135, 5.50, 35, '2009-03-02'),
(136, 5.50, 35, '2009-04-02'),
(137, 7.00, 35, '2009-05-02'),
(138, 7.00, 35, '2009-06-02'),
(139, 7.00, 35, '2009-07-02'),
(140, 7.00, 35, '2009-08-02'),
(141, 7.00, 35, '2009-08-02'),
(142, 7.00, 35, '2009-10-02'),
(143, 8.50, 35, '2009-11-02'),
(144, 10.00, 35, '2009-12-02'),
(145, 12.00, 35, '2010-01-02'),
(146, 12.00, 35, '2010-02-02'),
(147, 12.00, 35, '2010-03-02'),
(148, 12.00, 35, '2010-04-02'),
(149, 12.00, 35, '2010-05-02'),
(150, 14.50, 35, '2010-06-02'),
(151, 14.00, 35, '2010-07-02'),
(152, 12.00, 35, '2010-08-02'),
(153, 12.00, 35, '2010-08-02'),
(154, 16.00, 35, '2010-10-02'),
(155, 17.00, 35, '2010-11-02'),
(156, 17.00, 35, '2010-12-02'),
(157, 15.00, 35, '2011-01-02'),
(158, 15.00, 35, '2011-02-02'),
(159, 15.00, 35, '2011-03-02'),
(160, 15.00, 35, '2011-04-02'),
(161, 15.00, 35, '2011-05-02'),
(162, 15.00, 35, '2011-06-02'),
(163, 15.00, 35, '2011-07-02'),
(164, 15.00, 35, '2011-08-02'),
(165, 15.00, 35, '2011-08-02'),
(166, 8.00, 35, '2011-10-02'),
(167, 9.00, 35, '2011-11-02'),
(168, 8.50, 35, '2011-12-02');/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
现在就是要选出表 z_jiage 中 若干条不相干的记录,如中第1条,第7条,第12条,第25条,按照 日期add_time字段排序