Data dodania Pytanie
2017-02-18 22:02 Slow mysql query (using IN) »
I have a simple query: SELECT Description, Temp1, Temp2, SensorData.DateAndTime FROM SensorData INNER Join Sensors on Sensors.ChipId=SensorData...
(2) odpowiedzi
2017-02-18 17:02 Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.JDBCConnectionException: Could not open connection »
I am new to Spring-MVC and Hibernate. Trying to create a test web application with Spring-MVC(4.0.3) , Hibernate(4.3.5) and using MySQL as back end. ...
(2) odpowiedzi
2017-02-18 17:02 Is all my Facebook information stored in a session after I login? »
I am kind of a rookie in PHP and MySQL, so please bear with me :-) I'm also sorry if this has been asked before. From the little that I have gathered...
(1) odpowiedzi
2017-02-18 09:02 Is it possible to get query faster? »
I'm new to SQL and need help I have 4 tables: helmet arm +------+---------+-----+--------+ +------+---------+-...
(4) odpowiedzi
2017-02-17 21:02 Deleting Records from huge MySQL innoDB Table »
I know this question has been asked a hundred times, but unfortunately none of these answers helped, since most are many many years old, it should jus...
(1) odpowiedzi
2017-02-17 13:02 What is best practise for storing custom data for Wordpress »
Context: I need to create a form with a lot of customisations and quite a few fields (20+) for a site and rather than installing a plugin and modifyin...
(3) odpowiedzi
2017-02-17 01:02 Python pyodbc cursor vs database cursor »
I use python every day with a heavy emphasis on database work. Using pyodbc my standard start is something like connection_hostname = pyodbc.connec...
(1) odpowiedzi
2017-02-16 15:02 Connecting to MySQL database slow, takes n seconds »
Why is connecting to my InnoDB database often delayed by an integer amount of seconds? Some background I have a very small MySQL database, consistin...
(1) odpowiedzi
2017-02-16 11:02 How do I update multiple rows in one query »
I know this question may be asked too many times on these forums but I genuinely cannot find a solid answer. They all give different methods. Anyway...
(3) odpowiedzi
2017-02-16 10:02 Find period since last pause in MySQL »
I need to find the period without pause in days since last pause. I have a next table: id | user | date ----------------------- 1 | 1 | 16.02...
(7) odpowiedzi
2017-02-15 14:02 java "database is locked" SQL exception »
I am creating a really DB intensive java program, but I encountered an error on the connections. The code is: try{ Statement st; Resu...
(2) odpowiedzi
2017-02-15 10:02 Matching debit with credit per transaction in mysql or with better algothrim? »
First let me explain table structure and my required output. userid date amount 123 2017-01-01 5 123 2017-01-03 2 ...
(2) odpowiedzi
2017-02-15 09:02 Why PDO doesn't allow multiple placeholders with the same name? »
I'm using PHP, and MySQL with PDO. Sometimes I need to prepare a statement with one variable (placeholder) used more than once in this query. Example...
(1) odpowiedzi
2017-02-15 09:02 Laravel Migration Error : Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes »
Migration error on Laravel 5.4 with php artisan make:auth [Illuminate\Database\QueryException] ...
(2) odpowiedzi
2017-02-14 20:02 Doctrine\ ORM\ Mapping\ MappingException in Symfony »
The full error that I got was: [Doctrine\ORM\Mapping\MappingException] Property "followed" in "BackendBundl...
(1) odpowiedzi
2017-02-14 08:02 How can I restrict selecting to only rows which have common value? »
Here is my table structure: // users +----+--------+ | id | name | +----+--------+ | 1 | Jack | | 2 | Peter | | 3 | John | | 4 | Barman | ...
(2) odpowiedzi
2017-02-14 04:02 mysql Databases how can I fix this? »
Hi Im trying to set up a database to store emails using ruby, sinatra, ActiveRecord, and mysql. Any suggestions on what im doing wrong? Im trying to o...
(0) odpowiedzi
2017-02-14 03:02 Laravel Migration table not created »
I am a new learner of Laravel.And I follow the tutorial to create a articles table.Here's part of my code in /database/migrations/2017_02_13_145946_cr...
(1) odpowiedzi
2017-02-14 01:02 Mysql sub select with SUM() and group by »
I am trying to create a query that does a calculation in a subquery that requires the SUM function and a group by. My query returns the error "Subquer...
(2) odpowiedzi
2017-02-13 22:02 Write a prepared statement with nullable values in conditions »
Is there a way to write a prepared statement where a value is compared to another value in a condition and I don't know, whether this value is NULL or...
(1) odpowiedzi
2017-02-13 19:02 SQL query works by itself but breaks with 'unknown column in on clause' in stored procedure »
My select query with an inner joined subquery works when I run it alone, but results in the error Unknown column 'cities.state' in 'on clause' in the ...
(3) odpowiedzi
2017-02-13 08:02 SQL: Order by rowID and then by column based on the rowid »
I have the following 'departments' table: +-------+-------------+-------------------+ | rowid | department | parent_department | +-------+----------...
(1) odpowiedzi
2017-02-13 07:02 Create an subquery alias to use it in Laravel Query Builder »
I want to create something like an alias to SQL subquery so I can use it like a plain SQL field. For example, I've got 3 tables: user, user_comments a...
(1) odpowiedzi
2017-02-13 02:02 How to define unique index on multiple columns in sequelize »
How do I define a unique index on a combination of columns in sequelize. For example I want to add a unique index on user_id, count and name. var Ta...
(1) odpowiedzi
2017-02-13 01:02 Rails 5 Query when using both single and multiple association relationships »
I have a rails app with the following setup: class Organization < ApplicationRecord has_many :user_orgs has_many :users, :through => :u...
(1) odpowiedzi
2017-02-12 19:02 Query into wordpress db from laravel »
I have setup my main application in Laravel and set up WordPress for blog (CRUDE) operation. Installed WordPress inside public folder and configured d...
(2) odpowiedzi
2017-02-12 16:02 MySQL Priority Search »
I'm writing a small app to suggest sports based on a number of features about that sport and then offer up a selection based on most relevant. I'm cu...
(0) odpowiedzi
2017-02-12 13:02 PHP MySQL function dies »
Ive written my function just to check if the database connection is working. And it seems like he cant connect to my database, thats no problem, but ...
(3) odpowiedzi
2017-02-12 01:02 Is there any better way to do sorting option? »
So, I'm trying to make option that will sort results from database. I found a way to do this, but I'm not sure it's best. if(!isset($_GET['sort']) ||...
(1) odpowiedzi
2017-02-12 00:02 Search mysql with wildcard and put results into php array »
Say I have appearances of this is the RED color, this is the BLUE color, this is WHATEVER color as parts of the different sentences they belong to, in...
(2) odpowiedzi
2017-02-11 18:02 Converted MS-SQL stored proc to MYSQL but now it wont create due to syntax errors »
I have a strong MS-SQL background but have never seen a line of mysql until yesterday. I need to convert my ms-sql stored proc to mysql and I thought ...
(1) odpowiedzi
2017-02-11 18:02 Optimising many-to-many query in MySQL »
I have a table called 'items' that looks something like this... id | name –––––––––––– 1 | APPLES 2 | BANANAS 3 | ORANGES...
(2) odpowiedzi
2017-02-11 11:02 Database field update, input doesn't change »
Rails 4.1.1 Ruby 2.1.2 I have updated my production database with the following migration... class UpdateLimitOnCustomerNameField < ActiveRecord:...
(1) odpowiedzi
2017-02-11 08:02 Creating IF statement that if "Variable" != NULL then WHERE clause »
I want to have a query that will let me select ALL from the table if the variable is null, and my only option here is PURE MYSQL here is my CODE SELE...
(3) odpowiedzi
2017-02-11 08:02 How can I connect to multiple databases in laravel for the same query? »
I want to execute a raw query which is related to all databases in laravel. So I don't want to point to a specific database. How can I do that in lara...
(2) odpowiedzi