Data dodania Pytanie
2017-03-18 22:03 Get each day of the week as columns MySQL and PHP »
I am writing a web application in PHP with MySQL. I have a table called counts and this is how data is stored in that table: Table: counts id co...
(1) odpowiedzi
2017-03-18 22:03 How to prepare for mySQL too many requests? »
Thanks for taking time to my problem. I am new to MySQL. My problem is I want to make many (about 1000 clients' requests) select/insert queries...
(1) odpowiedzi
2017-03-18 21:03 How to insert id to database from text input »
Hi I've been searching how to do this for over 2 hours so I'll ask here. I have an eventlineitems table with product_id. On the create form I want to...
(1) odpowiedzi
2017-03-18 20:03 Which method is more efficient when it comes to fetching data from database? »
I'm trying to fetch user data from MySQL database and output it in a HTML table. I found a jQuery plugin that automatically sorts tables and allows u...
(1) odpowiedzi
2017-03-18 15:03 Unable to get data for id »
I'm using metamug to build my REST API. I wrote a query to fetch name of student, provided the id. But doesn't work. Gives 204 status code in response...
(1) odpowiedzi
2017-03-17 21:03 Laravel where like not working properly »
I would like to use the query builder with the LIKE operator but it's not working properly. Here is my code in my controller : public function list...
(3) odpowiedzi
2017-03-17 18:03 Connect to staging database from a local environment - Laravel 5 »
Goal Locally on my Mac OS, I'm trying to connect to my staging database that are running and hosted on my Ubuntu VM. Steps In my config/database...
(1) odpowiedzi
2017-03-17 09:03 Select parent row cell value for child row in MySQL »
I am importing data from an Excel sheet, and I am at a point where I have one table with parent and child rows. Child rows have around the same column...
(4) odpowiedzi
2017-03-16 21:03 Facebook signup not displaying message properly if user has already been registered »
The developer who made it is claiming that this is clearly because of an old PHP version in use. My current PHP version on my server is 5.2.17. I have...
(0) odpowiedzi
2017-03-16 15:03 Double Passing Rows into MySQL Databases using PHP »
eBay Platform Notifications recommends periodic polling of the GetOrders API to ensure each and every order is received. In my case, I have Platform ...
(1) odpowiedzi
2017-03-16 12:03 Delete post with smallest id SQL »
Delete from post where id_post in ( select MIN(id_post) from post where id_owner='2' ) Returns: "You can't specify target table 'pos...
(2) odpowiedzi
2017-03-16 12:03 Multiple SQL Statements in Java (with ?allowMultiQueries=true) »
I have a question. I work with a lot of SQL Queries and try to work out the best and fastest solution to handle a lot of queries (about 10'000 SQL-que...
(1) odpowiedzi
2017-03-15 22:03 Let's see if you can solve this one, open items hell »
I am trying to calculate Open column based on the following scenario. For a unique sales order + sales_order_item, if Billed_Item is NULL, Open = Or...
(2) odpowiedzi
2017-03-15 21:03 Fetch specific data from Database for a product »
I'm using WooCommerce and I need to fetch data from my woocommerce database: I know, I can get the regular price of an item with this code: $regPric...
(1) odpowiedzi
2017-03-15 18:03 Python is slow when iterating over a cursor »
I have the following code that runs very slowly (6.5sec for iterating over 57,390 rows) : import mysql.connector cnx=mysql.connector.connect(host=*...
(0) odpowiedzi
2017-03-15 05:03 Codeigniter SQL Query Syntax »
I'm using Codeigniter3 and have a problem with an query The default value of the variable day is 14. I want to convert sql query below to the codeign...
(1) odpowiedzi
2017-03-14 23:03 Adding a LIMIT 1 to a simple MySQL Query causes it to hang »
I have a strange issue where by adding LIMIT 1 to a query, it causes the query to never return. And yet, when I remove that LIMIT 1 the query works ...
(0) odpowiedzi
2017-03-14 17:03 Inconsistent results when passing array to ActiveRecord#where »
I'm using Rails 4.2.7.1, Ruby 2.3.1 and MySQL as my DB. I have a background job that is responsible for collecting analytics about the database which ...
(1) odpowiedzi
2017-03-14 15:03 MySQL fast check if hash exists »
I'm trying to create a MySQL function which takes n and m as input and generates random n unique combinations of m ids from result of query. The func...
(2) odpowiedzi
2017-03-14 07:03 Get all parents and children of a tree recursively »
I have a mysql table as id ***************** parent_id ************** title 1 ***************** 0 ***************** Student Managment 2 ******...
(2) odpowiedzi
2017-03-13 23:03 Direct Insert versus using MySQLi: query behaves differently »
I'm facing a rather odd issue. I use PHP 7.0 with a MySQL 5.5 DB on Azure. When testing queries on the database, I use Sequel Pro to directly perform ...
(0) odpowiedzi
2017-03-13 18:03 Is it possible to select this in one query? »
I'm writing a program to manage my investment. I try to get total market value of current holding in special date. I have two table, one is transactio...
(2) odpowiedzi
2017-03-13 14:03 Duplicate DB Entries on Double Request even after SELECT First »
I am not sure if I have put right words in title to explain. But here it is. Application: Coldfusion/MySQL Problem exceptionally occurred during bad...
(2) odpowiedzi
2017-03-13 02:03 How do I connect a "related products" table »
I have the following tables products table product_id name desc with a has many relation to suggested products table id product_id suggested_pr...
(1) odpowiedzi
2017-03-13 02:03 Ruby + Sequel + Sinatra + MySQL connection issues »
Hi have a simple web app built in ruby, sinatra and sequel connected to a mysql DB. Im using Ubuntu 14.04.3 LTS ruby 2.0.0 gem 'sinatra', '1.4.5' gem...
(1) odpowiedzi
2017-03-12 22:03 Stored procedure error OUT or INOUT argument 1 for routine [procedurename] is not a variable or NEW pseudo-variable in BEFORE trigger »
I am using the ColdFusion code to call a stored procedure: <cffunction access="public" name="create" output="FALSE" returntype="numeric" hint="Thi...
(2) odpowiedzi
2017-03-12 21:03 Need assistance with this SQL query »
This is an example of my table. I have multiple entries on multiple rows for a given post_id (this is metadata for posts). post_id | meta_key | meta_...
(5) odpowiedzi
2017-03-12 17:03 Spring-Boot, Mysql DB - can't connect to database »
I am trying to connect to mysql database, but it's not working. I took a course from udemy and followed all steps, but i am getting always the same er...
(2) odpowiedzi
2017-03-12 10:03 Export from localhost to remote on the same LAN »
I want to export one of my database to my Raspberry. I tried through PHPMyadmin, but on import I got this errormessage: SQL query: -- -- Database: `...
(3) odpowiedzi
2017-03-11 21:03 GROUP BY and custom order »
I've read through the answers on MySQL order by before group by but applying it to my query ends up with a subquery in a subquery for a rather simple ...
(2) odpowiedzi
2017-03-11 17:03 Strings vs integers for storing data »
What would be considered the best practise when it comes to storing datatypes to the database? For instance, you have a support ticket feature in whi...
(4) odpowiedzi
2017-03-11 13:03 CONCAT columns with Laravel 5 eloquent »
Consider me as laravel beginner The goal is: I have two colums, now I need the id to be prefixed with the component name of same row in the table. ...
(1) odpowiedzi
2017-03-11 10:03 Special character output in html from mysql »
I am using a plugin in Wordpress that stores some html code in a field. This column is mediumtext utf8_general_ci When I want to output this informat...
(2) odpowiedzi
2017-03-11 07:03 (Django) Does MySQL foreign key cascade delete parent or children first »
Currently, I am using Django with a MySQL backend database. Let us having the following database schema class Parent(models.Model): parent_id ...
(1) odpowiedzi
2017-03-11 00:03 Alternative to BigQuery for medium-sized data »
This is a follow-up to the question Why doesn't BigQuery perform as well on small data sets. Let's suppose I have a data-set that is ~1M rows. I...
(7) odpowiedzi