Data dodania Pytanie
2017-06-19 16:06 MSReport is showing 1 day behind for expiry date, compared to CRM? »
Currently when I look at the expiry date section for insurance on my MSReport Builder it is 03/04/2017, but the expiry date section for my insurance i...
(1) odpowiedzi
2017-06-19 16:06 Ruby - Rails - SQL query - reordering words in a search term »
I'm working on a project with a search function that is set up as follows: if params[:search_term].present? && params[:search_term].length &g...
(2) odpowiedzi
2017-06-19 14:06 Linking one Sequelize model to two different fields from another model »
I have two models: BusinessEntity, and Invoice I want the Invoice to have a seller and a buyer, both pointing to BusinessEntity records. So, I exp...
(1) odpowiedzi
2017-06-19 14:06 How to concatenate post_title with post_content with html - wordpress »
I'm using get_post(post_id) to get post_title and post_content. I would like to concatenate them, that post_title will become first paragraph in new s...
(1) odpowiedzi
2017-06-19 11:06 Efficient strategy to split database records into processed/unprocessed »
I often encounter this use case: I have a queue table with a high number (several millions) of records to process (synchronize with a remote API, ......
(1) odpowiedzi
2017-06-19 09:06 How to find the closest value in PHP »
How to determine the RESULTS field in table users, base on USER SCORE field with the provisions of the value closest to SCORE BRAND field. This is ...
(4) odpowiedzi
2017-06-18 22:06 MySQL - Find available time slots »
I'm working on a booking system, where it should be possible for users to book services with different service duration. I already have a MySQL table...
(1) odpowiedzi
2017-06-18 16:06 Wordpress : Sql select posts with all related meta »
I need to get an array of posts with all related meta. So it should be looks like that: post postfields from post table : [ ...
(1) odpowiedzi
2017-06-18 14:06 MySql select value if confition match or select first if not match »
I'm trying to select a user profile from a MySql database. I also have another table that contains user's telephone because they can have multiple pho...
(1) odpowiedzi
2017-06-18 14:06 Which db manager for a 100Go Table? »
I realize a 2G / 3G / 4G data retrieval project as part of my studies. I have to store this data, and to make queries on it. My table : [freq {float},...
(1) odpowiedzi
2017-06-18 13:06 Port 3306 not listening? Can't connect to MySQL remotely »
I'm trying to connect to MySQL remotely with pymysql and I'm getting the error message: (2003, "Can't connect to MySQL server on 'ip address' ([WinEr...
(1) odpowiedzi
2017-06-17 21:06 SQL count of intersections with total field »
For example we have this ServiceRequests source table in database: | Id | ClientDepartment | ServiceType | DateTimeServiced | |----|----------------...
(2) odpowiedzi
2017-06-17 13:06 How to enable pdo_mysql in the php docker image »
I have a basic Dockerfile with the following in: FROM php:7.1-apache RUN apt-get update && docker-php-ext-install pdo_mysql COPY . /var/www E...
(2) odpowiedzi
2017-06-17 12:06 MYSQL select count for every unique row even if count is zero »
I've trouble writing select where I can get multiple Counts for every unique row, I've searched whole web and wrote select but it's not working the wa...
(2) odpowiedzi
2017-06-17 11:06 Generating PHP Passwords for a database without PHP »
PHP includes a pair of functions to generate and validate passwords, using, I believe, BCrypt. This makes it easy to use password hashes stored in a d...
(2) odpowiedzi
2017-06-16 16:06 utf8mb4 in MySQL Workbench and JDBC »
I've been working with a UTF-8 encoded MySQL DB that now needs to be able to store 4-byte emojis, so I decided to change from utf8 encoding to utf8mb4...
(3) odpowiedzi
2017-06-16 14:06 mysql 7 + joins on a table, how to speed up? »
I have 7 tables. Table 1 is the 'parent table' and has_many relationships with tables 2-7. I'd like to make a query that grabs the rows of table 1, ...
(2) odpowiedzi
2017-06-16 09:06 Query time slows from 7 seconds to 40 seconds on adding a mediocre join, am I missing something? »
Advance apologies if this question is dumb. So I have a large table with results of a survey: Table Survey (120million rows):    &nbs...
(2) odpowiedzi
2017-06-15 16:06 confused of mysql like query with escape character? »
I have a table there are below data select * from t; +----+----------------+ | id | a | +----+----------------+ | 1 | u5929u732b | ...
(3) odpowiedzi
2017-06-15 12:06 MySql - Get Min, Max, and 3 random Rows »
I want a MySql query to get 5 rows which include min price row, max price row and other 3 random row. Table: ID Product Price 1 data 2 2 dat...
(6) odpowiedzi
2017-06-15 11:06 How to access ACF fields for a custom post type using 'wpdb'? »
I have two WordPress installs, one is to be used as an intranet and the other is public. I need to pull in the data for a custom post type from the pu...
(2) odpowiedzi
2017-06-15 09:06 insert or update in postgresql 9.1 »
I have a bunch of insert statements with varying number of columns for their respective tables, i need to execute these queries if the record doesn't ...
(3) odpowiedzi
2017-06-15 06:06 How to use LEFT OUTER JOIN to identify missing products by vendor? »
This query has been fun to figure out but I have come to place where I need some help. I have several tables and the ultimate question is: How man...
(3) odpowiedzi
2017-06-15 04:06 rails cannot create a new item »
I am working on creating a small rails app, and I have ran into a problem that I believe is in the backend of my database, but I don't know how to sol...
(3) odpowiedzi
2017-06-14 15:06 Sequelize foreign key error on Heroku but not local testing »
I am new developer and am trying to teach myself Sequelize and mysql with some little test projects. What I have right now is a little RPG team streng...
(1) odpowiedzi
2017-06-14 14:06 SQL how to do an outer join properly »
I have a table filled with the phone numbers of a company. My problem is, we have a row for every number an employee have, so if he have a main phone ...
(5) odpowiedzi
2017-06-14 11:06 Update data into table from dynamically created input field »
I have 2 models Tour.php public function Itinerary() { return $this->hasMany('App\Itinerary', 'tour_id'); } and Itinerary.php public funct...
(2) odpowiedzi
2017-06-13 22:06 How to delete entity with JOINs using JPA and Hibernate »
I have following entities: I want to delete WordSet by id and username of the user using JPA. Here is entity declarations: User @Entity @Data @T...
(2) odpowiedzi
2017-06-13 10:06 AJAX data not passing to PHP »
I am having trouble passing AJAX data to PHP. I am experienced with PHP but new to JavaScript. HTML / JavaScript <input type="text" id="commodity...
(2) odpowiedzi
2017-06-13 09:06 Is it fine to use pure PhP/MySql queries in Wordpress? »
Wordpress uses it's own version of php and queries data in its own way. Would it be a bad technique to use WP with pure mySQL commands like "SELECT * ...
(3) odpowiedzi
2017-06-13 09:06 Mysql To MongoDb design Issue »
I am planning to move my mysql db of chat_latest and chat_messages to mongodb. Old Mysql tables: chat_latest: User1 User2 LatestState 1 2 ...
(0) odpowiedzi
2017-06-12 15:06 Confused about when mysql code is injection proof using PDO »
I understand the basic idea of how mysql statements can be vulnerable, but every time I try to find a useful guide, the ways to achieve this with PDO ...
(1) odpowiedzi
2017-06-12 11:06 Using `rand()` with `having` »
I have a table that contains a list of records. Each iteration, a random set of these must be picked, starting from a specific offset. Each row has a ...
(0) odpowiedzi
2017-06-12 11:06 How to insert emoji into MYSQL 5.5 and higher using Django ORM »
I am trying to insert emoji's into a certain filed in my mysql table. I ran alter command and changed the collation to "utf8mb4_general_ci" ALTER ...
(0) odpowiedzi
2017-06-12 04:06 Moving from Relational Database to Big Data »
Currently I have an application hosted on the Google Cloud Platform that offers web analytics and provides session activity (clicks, downloads etc) an...
(1) odpowiedzi