Data dodania Pytanie
2017-04-22 22:04 How to speed up this SQL index query? »
Given the following SQL table : Employee(ssn, name, dept, manager, salary) You discover that the following query is significantly slowe...
(2) odpowiedzi
2017-04-22 22:04 Why is query execution time so high for Mysql Native driver for node.js? Any alternatives? »
Why does same query take around 300 ms more than actual execution time when using Mysql native driver for Nodejs , even with or without using "crea...
(1) odpowiedzi
2017-04-22 04:04 How to seed pivot table in Laravel 5.4? »
I am following a tutorial called Incremental API in laracasts by Jeffrey Way. There is a different coding between Laravel 4 faker class seeding and ...
(3) odpowiedzi
2017-04-21 16:04 How to overcome org.springframework.dao.RecoverableDataAccessException? »
Dear StackOverFlow Community, I keep receiving connectivity issues when connecting my Spring project to a MySQL server. I have tried various tricks ...
(0) odpowiedzi
2017-04-21 13:04 combining multiple SQL tables »
I'm trying to create a friends list when a user logs into my java applications. I have 3 tables, USERS, FRIENDS and SONGS. The user table: ID| USERN...
(2) odpowiedzi
2017-04-21 08:04 Calling MySQL Stored Procedure using VB6 with OUT Parameter »
I have written this procedure in MySQL (Server 5.5) DELIMITER $$ DROP PROCEDURE IF EXISTS `InsertList` $$ CREATE DEFINER=`root`@`localhost` PROCED...
(2) odpowiedzi
2017-04-20 23:04 Storing sql queries in enum. Is it good practice ? »
Is is a good practice to use an enum to store sql queries as constants ? I already have more than 20 private static final queries in my class, so I...
(0) odpowiedzi
2017-04-20 15:04 Merging a SELECT query and a SELECT COUNT query »
I have a table (associations) in MySql with unique and duplicate keys: id | key 1 | a 2 | b 3 | b 4 | c 5 | d 6 | d And I have a table (produ...
(3) odpowiedzi
2017-04-20 13:04 How to use FIND_IN_SET in sequelize with mysql DB »
How to use the FIND_IN_SET in sequelize ORM or any equivalent in sequelize. ...
(0) odpowiedzi
2017-04-20 13:04 laravel slow query issue »
I want to optimize my query I am executing with Laravel. I'm using MySQL for my project and I have a table named locations. It has more than 2 million...
(2) odpowiedzi
2017-04-20 02:04 get 3 peole have higher value from sql »
i have a table look like at the top. i want to show the 3 students that have higher value, i have tried command $higher= mysqli_query($connection,...
(3) odpowiedzi
2017-04-19 23:04 Removing Duplicates from complex MySQL Select Query »
All my projects are stored in the com_projects table. Each project can have multiple locations, which are stored in the com_location table. The com_...
(1) odpowiedzi
2017-04-19 20:04 SQL Query: Order by greatest of two columns »
I've tried about a dozen different methods to solve this issue, and everything I try is breaking my query... I have the following code that is used to...
(1) odpowiedzi
2017-04-19 14:04 how to insert dummy rows in sql without using insert query? »
I have the following query select '2016' as yr,warehouse as product,sum(answertext) p1 , round((sum(abc)/(select sum(abc) from [table 1])*100),2) p2...
(1) odpowiedzi
2017-04-19 07:04 Saving nested JSON data into a MySQL database using Hibernate »
I am strucked with this issue. I have created a POJO for nested JSON and I am getting data in MarketPrice object where marketPrices is an ArrayList wh...
(2) odpowiedzi
2017-04-18 19:04 How to arrange id using IN clause? »
I have a mysql query which is like this: select * from tbl_post where id IN (16,18,14) and I want to display in order of 16,18,14 as in query. But ...
(0) odpowiedzi
2017-04-18 16:04 Select records from table if certain value exists, if not, select other records »
I have a table like this: projectName | info -------------------- all | i1 all | i2 all | i3 name1 | i4 name1 | i...
(2) odpowiedzi
2017-04-18 12:04 Optimisation in badly-performing query »
I have the following query which is working correctly, however it is running very poorly. I am suspecting that my issue is with the two comparison con...
(5) odpowiedzi
2017-04-18 08:04 SQL count second column for-each unique row of first column »
I have this sample many-to-many table for students & subjects in a university student | subject ----------------- James | English James | Phy...
(5) odpowiedzi
2017-04-18 05:04 Get Order Notes from a Woocommerce Order / WC_Order object? »
I can add an order note (private note) with: $order->add_order_note($info_for_order); But when I tried to get the values in some page with: ge...
(1) odpowiedzi
2017-04-17 11:04 MySQL Update using INNER JOIN with ORDER BY and LIMIT »
I'm trying to do an update using an inner join with limit and order by (although the order by is not essential. From what I have read up the standard ...
(2) odpowiedzi
2017-04-17 08:04 Select dates between date range and sum over a column »
I have the following tables: Let's assume the first table represents a booking made by a customer for a hotel. +------------+-----------+---------...
(1) odpowiedzi
2017-04-17 03:04 Universal user profile for subproject sites – securely trasfering user data from main server »
I have a site (A) for main project with user system (which is supposed to display all student competitions and academic events in my country for regis...
(1) odpowiedzi
2017-04-17 02:04 Searching Arabic names discard the differences between "أ" , "ا" in mysql »
I am storing Arabic name in my database. In Arabic there are some letters that may written in different format such as "ا"، "أ"، "آ" it all repr...
(1) odpowiedzi
2017-04-16 23:04 Theoretical evaluation of SQL query cost »
I need to evaluate a SQL query in theory by analyzing the results and the number of lines looked upon. Any link to information online is welcomed as I...
(1) odpowiedzi
2017-04-16 17:04 How to define a parameter value when the value is not defined? »
I have a problem with this MySQL command: cmdTemp = New MySqlCommand("SET @qty = " & Qty & "; update(tb_harvest) set actual = (case when @qty...
(2) odpowiedzi
2017-04-16 16:04 Idempotent table and index creation with value insertion in MySQL »
I have some SQL Server schema changes that I'm trying to convert to MySQL. I know about CREATE TABLE IF NOT EXISTS in MySQL. I don't think I can use t...
(2) odpowiedzi
2017-04-16 15:04 HTML : load thumbnail image and full image faster »
I have a blog website that loads the images slowly i want to know how to make them load faster and: I am using same image for thumbnail and story. t...
(2) odpowiedzi
2017-04-15 21:04 Adding "and" between last two database results in foreach loop »
I want to add the word "and" between the last two MySQL results. I can add commas but I need to add commas between the first ones and then "and" betwe...
(5) odpowiedzi
2017-04-15 17:04 How to store multiple records in the same SQL column with PHP? »
What would be a proper way to store multiple values in the same SQL column with help of PHP. For example, in a system that stores Contact/Client deta...
(4) odpowiedzi
2017-04-15 17:04 Block site visitor with IPv6 using PHP and MYSQL »
On my website I try to block bad users and bots. After detecting bad behaviour (ignoring robots.txt, too many clicks etc) the users IP address is adde...
(0) odpowiedzi
2017-04-15 02:04 automatic order id system check existence in mysql database »
What I am trying to achieve is I have a systematic order generating system for my website I am just not able to check if the order id already exist if...
(0) odpowiedzi
2017-04-14 19:04 Laravel: N to N (mysql) relation using Eloquent ORM »
I got 4 tables: // Table countries +----+------+ | Id | Name | +----+------+ | 1 | USA | | 2 | GB | +----+------+ // Table platforms +----+----...
(1) odpowiedzi
2017-04-14 19:04 order by from 2 column from different tables »
I am trying to pull all the items for sales on a POS system. I have a few tables I need to join and order/group by. I hope I can get this explained....
(1) odpowiedzi
2017-04-14 18:04 MySQL Error 1442 »
I have two tables: sanction with these attributes: DriverID, Calification, Points people with these attributes: pID, city , TotalPoints And i...
(0) odpowiedzi