草庐IT

mysql - 相同的 MySQL 查询在同一服务器上返回不同的结果

coder 2023-10-23 原文

我正在运行以下查询。有时它返回大约 100 条记录，正如预期的那样，其他时候它只返回一条记录，其中所有连接字段的值都为 NULL。此外，explain 几乎每次都会返回不同的结果。

这里是查询:

EXPLAIN
SELECT
`fieldreps`.`user_id` AS `fieldreps.user_id`,
 `fieldreps`.`availability_id` AS `fieldreps.availability_id`,
 `fieldreps`.`applicant_type` AS `fieldreps.applicant_type`,
 `fieldreps`.`license_number` AS `fieldreps.license_number`,
 `fieldreps`.`license_exp` AS `fieldreps.license_exp`,
 `fieldreps`.`license_state` AS `fieldreps.license_state`,
 `fieldreps`.`car` AS `fieldreps.car`,
 `fieldreps`.`authorized_worker` AS `fieldreps.authorized_worker`,
 `fieldreps`.`restrictions` AS `fieldreps.restrictions`,
 `fieldreps`.`night` AS `fieldreps.night`,
 `fieldreps`.`day` AS `fieldreps.day`,
 `fieldreps`.`longer` AS `fieldreps.longer`,
 `fieldreps`.`commitment` AS `fieldreps.commitment`,
 `fieldreps`.`travel_metro` AS `fieldreps.travel_metro`,
 `fieldreps`.`travel_states` AS `fieldreps.travel_states`,
 `fieldreps`.`big_employee` AS `fieldreps.big_employee`,
 `fieldreps`.`employed` AS `fieldreps.employed`,
 `fieldreps`.`retail` AS `fieldreps.retail`,
 `fieldreps`.`status` AS `fieldreps.status`,
 `fieldreps`.`start` AS `fieldreps.start`,
 `fieldreps`.`sales` AS `fieldreps.sales`,
 `fieldreps`.`study` AS `fieldreps.study`,
 `fieldreps`.`relevant` AS `fieldreps.relevant`,
 `fieldreps`.`experience` AS `fieldreps.experience`,
 `fieldreps`.`claims` AS `fieldreps.claims`,
 `fieldreps`.`education` AS `fieldreps.education`,
 `fieldreps`.`degree_details` AS `fieldreps.degree_details`,
 `fieldreps`.`degree_institution` AS `fieldreps.degree_institution`,
 `fieldreps`.`other_training` AS `fieldreps.other_training`,
 `fieldreps`.`jobs` AS `fieldreps.jobs`,
 `fieldreps`.`current_training` AS `fieldreps.current_training`,
 `fieldreps`.`interested` AS `fieldreps.interested`,
 `fieldreps`.`achievements` AS `fieldreps.achievements`,
 `fieldreps`.`passions` AS `fieldreps.passions`,
 `fieldreps`.`ambitions` AS `fieldreps.ambitions`,
 `fieldreps`.`max_travel_time` AS `fieldreps.max_travel_time`,
 `fieldreps`.`creation_time` AS `fieldreps.creation_time`,
 `fieldreps`.`resume` AS `fieldreps.resume`,
 `users`.`user_id` AS `users.user_id`,
 `users`.`email` AS `users.email`,
 `users`.`name` AS `users.name`,
 `users`.`password` AS `users.password`,
 `users`.`given_name` AS `users.given_name`,
 `users`.`title` AS `users.title`,
 `users`.`nationality` AS `users.nationality`,
 `tasks`.`task_id` AS `tasks.task_id`,
 `tasks`.`recurrence_id` AS `tasks.recurrence_id`,
 `tasks`.`parent_id` AS `tasks.parent_id`,
 `tasks`.`user_id` AS `tasks.user_id`,
 `tasks`.`campaign_id` AS `tasks.campaign_id`,
 `tasks`.`location_id` AS `tasks.location_id`,
 `tasks`.`title` AS `tasks.title`,
 `tasks`.`description` AS `tasks.description`,
 `tasks`.`earliest_start` AS `tasks.earliest_start`,
 `tasks`.`deadline` AS `tasks.deadline`,
 `tasks`.`km_estimate` AS `tasks.km_estimate`,
 `tasks`.`estimate` AS `tasks.estimate`,
 `datapoints`.`datapoint_id` AS `datapoints.datapoint_id`,
 `datapoints`.`task_id` AS `datapoints.task_id`,
 `datapoints`.`datatype_id` AS `datapoints.datatype_id`,
 `datapoints`.`value` AS `datapoints.value`,
 `datapoints`.`product_id` AS `datapoints.product_id`,
 `datapoints`.`recorded` AS `datapoints.recorded`,
 `datatypes`.`datatype_id` AS `datatypes.datatype_id`,
 `datatypes`.`datatype_template_id` AS `datatypes.datatype_template_id`,
 `datatypes`.`client_id` AS `datatypes.client_id`,
 `datatypes`.`name` AS `datatypes.name`,
 `datatypes`.`description` AS `datatypes.description`,
 `datatypes`.`options` AS `datatypes.options`,
 `locations`.`location_id` AS `locations.location_id`,
 `locations`.`retailer_group_id` AS `locations.retailer_group_id`,
 `locations`.`latitude` AS `locations.latitude`,
 `locations`.`longitude` AS `locations.longitude`,
 `locations`.`name` AS `locations.name`,
 `locations`.`address` AS `locations.address`,
 `locations`.`city` AS `locations.city`,
 `locations`.`state` AS `locations.state`,
 `locations`.`postal` AS `locations.postal`,
 `locations`.`phone` AS `locations.phone`,
 `locations`.`suburb` AS `locations.suburb`,
 `locations`.`country` AS `locations.country`,
 `locations`.`region` AS `locations.region`,
 `locations`.`coverage` AS `locations.coverage`,
 `locations`.`store_number` AS `locations.store_number`,
 `locations`.`store_type` AS `locations.store_type`

 FROM `fieldreps` AS `fieldreps`

 LEFT JOIN `users` ON (`fieldreps`.`user_id` = `users`.`user_id`)
 LEFT JOIN `tasks` ON (`fieldreps`.`user_id` = `tasks`.`user_id`)
 LEFT JOIN `datapoints` ON (`tasks`.`task_id` = `datapoints`.`task_id`)
 LEFT JOIN `datatypes` ON (`datapoints`.`datatype_id` = `datatypes`.`datatype_id`)
 LEFT JOIN `locations` ON (`tasks`.`location_id` = `locations`.`location_id`)

 WHERE `fieldreps`.`user_id` LIKE '5f5dc29c-832e-5646-9dc2-46d774bfb1ec'

我在 phpMyAdmin 中运行查询。数据库托管在 xeround.com 上(这可能是他们配置中的错误吗？)

我被难住了。我不确定从这里到哪里去。

提前致谢!

更新:

这是来自 phpMyAdmin 的转储:

-- phpMyAdmin SQL Dump
-- version 3.4.3.2
-- http://www.phpmyadmin.net
--
-- Generation Time: Jan 07, 2012 at 08:20 PM
-- Server version: 5.1.42
-- PHP Version: 5.3.1

SET 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 */;

--
-- Database: `big_development`
--

-- --------------------------------------------------------

--
-- Table structure for table `datapoints`
--

CREATE TABLE IF NOT EXISTS `datapoints` (
  `datapoint_id` varchar(36) COLLATE utf8_bin NOT NULL,
  `task_id` varchar(36) COLLATE utf8_bin NOT NULL,
  `datatype_id` varchar(36) COLLATE utf8_bin NOT NULL,
  `value` text COLLATE utf8_bin,
  `product_id` varchar(36) COLLATE utf8_bin DEFAULT NULL,
  `recorded` text COLLATE utf8_bin,
  PRIMARY KEY (`datapoint_id`),
  KEY `task_id` (`task_id`),
  KEY `datatype_id` (`datatype_id`),
  KEY `product_id` (`product_id`)
) ENGINE=Xeround DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- --------------------------------------------------------

--
-- Table structure for table `datatypes`
--

CREATE TABLE IF NOT EXISTS `datatypes` (
  `datatype_id` varchar(36) COLLATE utf8_bin NOT NULL,
  `datatype_template_id` varchar(36) COLLATE utf8_bin NOT NULL,
  `client_id` varchar(36) COLLATE utf8_bin NOT NULL,
  `name` text COLLATE utf8_bin,
  `description` text COLLATE utf8_bin,
  `options` text COLLATE utf8_bin,
  PRIMARY KEY (`datatype_id`),
  KEY `datatype_template_id` (`datatype_template_id`),
  KEY `client_id` (`client_id`)
) ENGINE=Xeround DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- --------------------------------------------------------

--
-- Table structure for table `fieldreps`
--

CREATE TABLE IF NOT EXISTS `fieldreps` (
  `user_id` varchar(36) COLLATE utf8_bin NOT NULL,
  `availability_id` varchar(36) COLLATE utf8_bin NOT NULL,
  `applicant_type` text COLLATE utf8_bin NOT NULL,
  `license_number` text COLLATE utf8_bin NOT NULL,
  `license_exp` text COLLATE utf8_bin,
  `license_state` text COLLATE utf8_bin,
  `car` text COLLATE utf8_bin NOT NULL,
  `authorized_worker` text COLLATE utf8_bin NOT NULL,
  `restrictions` text COLLATE utf8_bin NOT NULL,
  `night` text COLLATE utf8_bin NOT NULL,
  `day` text COLLATE utf8_bin NOT NULL,
  `longer` text COLLATE utf8_bin NOT NULL,
  `commitment` text COLLATE utf8_bin NOT NULL,
  `travel_metro` text COLLATE utf8_bin NOT NULL,
  `travel_states` text COLLATE utf8_bin NOT NULL,
  `big_employee` text COLLATE utf8_bin NOT NULL,
  `employed` text COLLATE utf8_bin NOT NULL,
  `retail` text COLLATE utf8_bin NOT NULL,
  `status` text COLLATE utf8_bin NOT NULL,
  `start` text COLLATE utf8_bin,
  `sales` text COLLATE utf8_bin NOT NULL,
  `study` text COLLATE utf8_bin NOT NULL,
  `relevant` text COLLATE utf8_bin NOT NULL,
  `experience` text COLLATE utf8_bin NOT NULL,
  `claims` text COLLATE utf8_bin NOT NULL,
  `education` text COLLATE utf8_bin NOT NULL,
  `degree_details` text COLLATE utf8_bin NOT NULL,
  `degree_institution` text COLLATE utf8_bin NOT NULL,
  `other_training` text COLLATE utf8_bin NOT NULL,
  `jobs` text COLLATE utf8_bin NOT NULL,
      `current_training` text COLLATE utf8_bin NOT NULL,
  `interested` text COLLATE utf8_bin NOT NULL,
  `achievements` text COLLATE utf8_bin NOT NULL,
  `passions` text COLLATE utf8_bin NOT NULL,
  `ambitions` text COLLATE utf8_bin NOT NULL,
  `max_travel_time` text COLLATE utf8_bin NOT NULL,
  `creation_time` text COLLATE utf8_bin,
  `resume` text COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`user_id`),
  KEY `availability_id` (`availability_id`)
) ENGINE=Xeround DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- --------------------------------------------------------

--
-- Table structure for table `locations`
--

CREATE TABLE IF NOT EXISTS `locations` (
  `location_id` varchar(36) COLLATE utf8_bin NOT NULL,
  `retailer_group_id` varchar(36) COLLATE utf8_bin NOT NULL,
  `latitude` text COLLATE utf8_bin,
  `longitude` text COLLATE utf8_bin,
  `name` text COLLATE utf8_bin,
  `address` text COLLATE utf8_bin,
  `city` text COLLATE utf8_bin,
  `state` text COLLATE utf8_bin,
  `postal` text COLLATE utf8_bin,
  `phone` text COLLATE utf8_bin,
  `suburb` text COLLATE utf8_bin,
  `country` text COLLATE utf8_bin,
  `region` text COLLATE utf8_bin,
  `coverage` tinyint(1) DEFAULT NULL,
  `store_number` text COLLATE utf8_bin,
  `store_type` text COLLATE utf8_bin,
  PRIMARY KEY (`location_id`),
  KEY `retailer_group_id` (`retailer_group_id`)
) ENGINE=Xeround DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- --------------------------------------------------------

--
-- Table structure for table `tasks`
--

CREATE TABLE IF NOT EXISTS `tasks` (
  `task_id` varchar(36) COLLATE utf8_bin NOT NULL,
  `recurrence_id` varchar(36) COLLATE utf8_bin NOT NULL,
  `parent_id` varchar(36) COLLATE utf8_bin DEFAULT NULL,
  `user_id` varchar(36) COLLATE utf8_bin NOT NULL,
  `campaign_id` varchar(36) COLLATE utf8_bin NOT NULL,
  `location_id` varchar(36) COLLATE utf8_bin NOT NULL,
  `title` text COLLATE utf8_bin,
  `description` text COLLATE utf8_bin,
  `earliest_start` text COLLATE utf8_bin,
  `deadline` text COLLATE utf8_bin,
  `km_estimate` text COLLATE utf8_bin,
  `estimate` int(11) DEFAULT NULL,
  PRIMARY KEY (`task_id`),
  KEY `campaign_id` (`campaign_id`),
  KEY `location_id` (`location_id`),
  KEY `user_id` (`user_id`),
  KEY `parent_id` (`parent_id`),
  KEY `recurrence_id` (`recurrence_id`)
) ENGINE=Xeround DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `user_id` varchar(36) COLLATE utf8_bin NOT NULL,
  `email` varchar(255) COLLATE utf8_bin NOT NULL,
  `name` text COLLATE utf8_bin,
  `password` varchar(255) COLLATE utf8_bin NOT NULL,
  `given_name` text COLLATE utf8_bin,
  `title` text COLLATE utf8_bin NOT NULL,
  `nationality` text COLLATE utf8_bin,
  PRIMARY KEY (`user_id`),
  KEY `user_id` (`user_id`)
) ENGINE=Xeround DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*!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 */;

编辑:

如果我删除除用户以外的所有表的连接，查询每次都有效。但是，一旦我添加任务连接，它就会中断。例如，此查询以与我发布的第一个查询相同的方式中断它:

SELECT
`fieldreps`.`user_id` AS `fieldreps.user_id`,
 `fieldreps`.`availability_id` AS `fieldreps.availability_id`,
 `fieldreps`.`applicant_type` AS `fieldreps.applicant_type`,
 `fieldreps`.`license_number` AS `fieldreps.license_number`,
 `fieldreps`.`license_exp` AS `fieldreps.license_exp`,
 `fieldreps`.`license_state` AS `fieldreps.license_state`,
 `fieldreps`.`car` AS `fieldreps.car`,
 `fieldreps`.`authorized_worker` AS `fieldreps.authorized_worker`,
 `fieldreps`.`restrictions` AS `fieldreps.restrictions`,
 `fieldreps`.`night` AS `fieldreps.night`,
 `fieldreps`.`day` AS `fieldreps.day`,
 `fieldreps`.`longer` AS `fieldreps.longer`,
 `fieldreps`.`commitment` AS `fieldreps.commitment`,
 `fieldreps`.`travel_metro` AS `fieldreps.travel_metro`,
 `fieldreps`.`travel_states` AS `fieldreps.travel_states`,
 `fieldreps`.`big_employee` AS `fieldreps.big_employee`,
 `fieldreps`.`employed` AS `fieldreps.employed`,
 `fieldreps`.`retail` AS `fieldreps.retail`,
 `fieldreps`.`status` AS `fieldreps.status`,
 `fieldreps`.`start` AS `fieldreps.start`,
 `fieldreps`.`sales` AS `fieldreps.sales`,
 `fieldreps`.`study` AS `fieldreps.study`,
 `fieldreps`.`relevant` AS `fieldreps.relevant`,
 `fieldreps`.`experience` AS `fieldreps.experience`,
 `fieldreps`.`claims` AS `fieldreps.claims`,
 `fieldreps`.`education` AS `fieldreps.education`,
 `fieldreps`.`degree_details` AS `fieldreps.degree_details`,
 `fieldreps`.`degree_institution` AS `fieldreps.degree_institution`,
 `fieldreps`.`other_training` AS `fieldreps.other_training`,
 `fieldreps`.`jobs` AS `fieldreps.jobs`,
 `fieldreps`.`current_training` AS `fieldreps.current_training`,
 `fieldreps`.`interested` AS `fieldreps.interested`,
 `fieldreps`.`achievements` AS `fieldreps.achievements`,
 `fieldreps`.`passions` AS `fieldreps.passions`,
 `fieldreps`.`ambitions` AS `fieldreps.ambitions`,
 `fieldreps`.`max_travel_time` AS `fieldreps.max_travel_time`,
 `fieldreps`.`creation_time` AS `fieldreps.creation_time`,
 `fieldreps`.`resume` AS `fieldreps.resume`,
 `users`.`user_id` AS `users.user_id`,
     `users`.`email` AS `users.email`,
 `users`.`name` AS `users.name`,
 `users`.`password` AS `users.password`,
 `users`.`given_name` AS `users.given_name`,
 `users`.`title` AS `users.title`,
 `users`.`nationality` AS `users.nationality`,
 `tasks`.`task_id` AS `tasks.task_id`,
 `tasks`.`recurrence_id` AS `tasks.recurrence_id`,
 `tasks`.`parent_id` AS `tasks.parent_id`,
 `tasks`.`user_id` AS `tasks.user_id`,
 `tasks`.`campaign_id` AS `tasks.campaign_id`,
 `tasks`.`location_id` AS `tasks.location_id`,
 `tasks`.`title` AS `tasks.title`,
 `tasks`.`description` AS `tasks.description`,
 `tasks`.`earliest_start` AS `tasks.earliest_start`,
 `tasks`.`deadline` AS `tasks.deadline`,
 `tasks`.`km_estimate` AS `tasks.km_estimate`,
 `tasks`.`estimate` AS `tasks.estimate`

 FROM `fieldreps` AS `fieldreps`

 LEFT JOIN `users` ON (`fieldreps`.`user_id` = `users`.`user_id`)
 LEFT JOIN `tasks` ON (`fieldreps`.`user_id` = `tasks`.`user_id`)

 WHERE `fieldreps`.`user_id` LIKE '5f5dc29c-832e-5646-9dc2-46d774bfb1ec'

最佳答案

连接和数据库整理不同。

关于mysql - 相同的 MySQL 查询在同一服务器上返回不同的结果，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/8772632/

mysqlfieldrepsutf8_binCOLLATEphpmyadminxeround

有关mysql - 相同的 MySQL 查询在同一服务器上返回不同的结果的更多相关文章

  1. ruby - 使用 ruby​​ 和 savon 的 SOAP 服务 - 2

    我正在尝试使用ruby​​和Savon来使用网络服务。测试服务为http://www.webservicex.net/WS/WSDetails.aspx?WSID=9&CATID=2require'rubygems'require'savon'client=Savon::Client.new"http://www.webservicex.net/stockquote.asmx?WSDL"client.get_quotedo|soap|soap.body={:symbol=>"AAPL"}end返回SOAP异常。检查soap信封，在我看来soap请求没有正确的命名空间。任何人都可以建议我

  2. ruby - 具有身份验证的私有(private) Ruby Gem 服务器 - 2

    我想安装一个带有一些身份验证的私有(private)Rubygem服务器。我希望能够使用公共(public)Ubuntu服务器托管内部gem。我读到了http://docs.rubygems.org/read/chapter/18.但是那个没有身份验证-如我所见。然后我读到了https://github.com/cwninja/geminabox.但是当我使用基本身份验证(他们在他们的Wiki中有)时，它会提示从我的服务器获取源。所以。如何制作带有身份验证的私有(private)Rubygem服务器？这是不可能的吗？谢谢。编辑:Geminabox问题。我尝试“捆绑”以安装新的gem..

  3. ruby - ECONNRESET (Whois::ConnectionError) - 尝试在 Ruby 中查询 Whois 时出错 - 2

    我正在用Ruby编写一个简单的程序来检查域列表是否被占用。基本上它循环遍历列表，并使用以下函数进行检查。require'rubygems'require'whois'defcheck_domain(domain)c=Whois::Client.newc.query("google.com").available?end程序不断出错(即使我在google.com中进行硬编码)，并打印以下消息。鉴于该程序非常简单，我已经没有什么想法了-有什么建议吗？/Library/Ruby/Gems/1.8/gems/whois-2.0.2/lib/whois/server/adapters/base.

  4. ruby - 为什么 4.1%2 使用 Ruby 返回 0.0999999999999996？但是 4.2%2==0.2 - 2

    为什么4.1%2返回0.0999999999999996？但是4.2%2==0.2。 最佳答案 参见此处:WhatEveryProgrammerShouldKnowAboutFloating-PointArithmetic实数是无限的。计算机使用的位数有限(今天是32位、64位)。因此计算机进行的浮点运算不能代表所有的实数。0.1是这些数字之一。请注意，这不是与Ruby相关的问题，而是与所有编程语言相关的问题，因为它来自计算机表示实数的方式。 关于ruby-为什么4.1%2使用Ruby返

  5. ruby - Highline 询问方法不会使用同一行 - 2

    设置:狂欢ruby1.9.2高线(1.6.13)描述:我已经相当习惯在其他一些项目中使用highline，但已经有几个月没有使用它了。现在，在Ruby1.9.2上全新安装时，它似乎不允许在同一行回答提示。所以以前我会看到类似的东西:require"highline/import"ask"Whatisyourfavoritecolor?"并得到:Whatisyourfavoritecolor?|现在我看到类似的东西:Whatisyourfavoritecolor?|竖线(|)符号是我的终端光标。知道为什么会发生这种变化吗？ 最佳答案

  6. ruby-on-rails - 启动 Rails 服务器时 ImageMagick 的警告 - 2

    最近，当我启动我的Rails服务器时，我收到了一长串警告。虽然它不影响我的应用程序，但我想知道如何解决这些警告。我的估计是imagemagick以某种方式被调用了两次？当我在警告前后检查我的git日志时。我想知道如何解决这个问题。-bcrypt-ruby(3.1.2)-better_errors(1.0.1)+bcrypt(3.1.7)+bcrypt-ruby(3.1.5)-bcrypt(>=3.1.3)+better_errors(1.1.0)bcrypt和imagemagick有关系吗？/Users/rbchris/.rbenv/versions/2.0.0-p247/lib/ru

  7. ruby-on-rails - s3_direct_upload 在生产服务器中不工作 - 2

    在Rails4.0.2中，我使用s3_direct_upload和aws-sdkgems直接为s3存储桶上传文件。在开发环境中它工作正常，但在生产环境中它会抛出如下错误，ActionView::Template::Error(noimplicitconversionofnilintoString)在View中，create_cv_url,:id=>"s3_uploader",:key=>"cv_uploads/{unique_id}/${filename}",:key_starts_with=>"cv_uploads/",:callback_param=>"cv[direct_uplo

  8. ruby - 如果指定键的值在数组中相同，如何合并哈希 - 2

    我有一个这样的哈希数组:[{:foo=>2,:date=>Sat,01Sep2014},{:foo2=>2,:date=>Sat,02Sep2014},{:foo3=>3,:date=>Sat,01Sep2014},{:foo4=>4,:date=>Sat,03Sep2014},{:foo5=>5,:date=>Sat,02Sep2014}]如果:date相同，我想合并哈希值。我对上面数组的期望是:[{:foo=>2,:foo3=>3,:date=>Sat,01Sep2014},{:foo2=>2,:foo5=>5:date=>Sat,02Sep2014},{:foo4=>4,:dat

  9. ruby-on-rails - 在 Rails 和 ActiveRecord 中查询时忽略某些字段 - 2

    我知道我可以指定某些字段来使用pluck查询数据库。ids=Item.where('due_at但是我想知道，是否有一种方法可以指定我想避免从数据库查询的某些字段。某种反拔？posts=Post.where(published:true).do_not_lookup(:enormous_field) 最佳答案 Model#attribute_names应该返回列/属性数组。您可以排除其中一些并传递给pluck或select方法。像这样:posts=Post.where(published:true).select(Post.attr

  10. ruby - 检查字符串是否包含散列中的任何键并返回它包含的键的值 - 2

    我有一个包含多个键的散列和一个字符串，该字符串不包含散列中的任何键或包含一个键。h={"k1"=>"v1","k2"=>"v2","k3"=>"v3"}s="thisisanexamplestringthatmightoccurwithakeysomewhereinthestringk1(withspecialcharacterslike(^&*$#@!^&&*))"检查s是否包含h中的任何键的最佳方法是什么，如果包含，则返回它包含的键的值？例如，对于上面的h和s的例子，输出应该是v1。编辑:只有字符串是用户定义的。哈希将始终相同。 最佳答案

随机推荐