Data dodania Pytanie
2017-08-07 13:08 How to search in mysql? »
how to select doctor_id which has ability_id equal 1 and 2 and also 3? ( so the answer is 70) I know that I cant use IN statement doctor_id| abilit...
(2) odpowiedzi
2017-08-07 13:08 Laravel: Query to return data depending the ID I pass in URL »
First of all excuse me if when you read all the question you think isn't clear or question should be edited, please, make a edit and i will accept it....
(2) odpowiedzi
2017-08-07 12:08 How to hide repeating part of the retrieved data values using php and codeigniter »
I have obtain following table as a result of this mysql statement SELECT * FROM expenses, income WHERE expenses.projectname=income.projectname AN...
(5) odpowiedzi
2017-08-07 04:08 Return the last row in mysql query from left join »
I am trying to get the last row of table2 that I left join with table1. Table1 column: id name created date Table2 column: id last_login ip_ad...
(2) odpowiedzi
2017-08-06 16:08 40 seconds strange sql performance puzzle »
I'm running a query to update my user's field like the following: UPDATE Members SET abc = abc + 1 where Members.id in ( SELECT DISTINCT(memberId) FR...
(1) odpowiedzi
2017-08-06 11:08 php empty result for language table »
I am trying to add multiple language options with the database. I created a table as follows. And my PHP function is: public function Languag...
(3) odpowiedzi
2017-08-06 09:08 C# : Unable to print data as unicode characters from MYSQL database »
Hi I have developed a windows application which allows user to save data and see data in tamil font. I installed 'Bamini' font (Tamil font), and set t...
(3) odpowiedzi
2017-08-05 22:08 MySQL add column with spaces in php »
I would like to add column to my MySQL-database with spaces. In terms of SO-questions this is as close as I've come Insert data in mysql colum with ...
(3) odpowiedzi
2017-08-05 07:08 Getting a user's position in a queue table is too slow »
I have a MariaDB table that looks like this: +--------+--------+--------+---------------------+ | realm | key2 | userId | date | +-...
(1) odpowiedzi
2017-08-05 02:08 Why is MySQL consuming so much memory? »
I have mysql 5.6.36 database where the size is ~35G running on CentOS 7.3 with 48G of RAM. [UPDATE 17-08-06] I will update relevant information here....
(5) odpowiedzi
2017-08-04 11:08 Pagination MySQL PHP »
I'm trying to use pagination for a customer table using PHP, MySQL & Bootstrap. I wrote this code: <div class="container mx-auto"> <!--...
(3) odpowiedzi
2017-08-04 11:08 Database table entry stooped when ajax code is on in cusom plugin in wordpress »
when ajax code is in running mode,at that time database entry stopped,when i comment ajax code that time database operation performed successfully, ri...
(1) odpowiedzi
2017-08-04 10:08 Mysql using monthname with month »
I'm trying to get the name of the Month through Monthname, but it just returns (NULL) Date = 4 MONTHNAME(str_to_date(Month(Date), '%m')) ...
(2) odpowiedzi
2017-08-04 05:08 PHP PDO OOP: Why only one value is being send/insert into MySQL? »
Hye guys, I really need help .. I manage to submit this value into DB but it only submit one, not all values. Below I attached the example. I had ent...
(1) odpowiedzi
2017-08-03 11:08 Inconsistent query results from MySQL »
Today we have spotted a strange behavior in SQL queries (we use MySQL v5.6.36 and InnoDB). Take this query: mysql> SELECT count(*) FROM `invento...
(2) odpowiedzi
2017-08-03 11:08 Mysql - Taking too much time to execute queries »
So first my mysql table are defined like this : Orders(333000+ records) orders_id(PK), customerName, CompanyName, Status, shipping_no, shipping...
(1) odpowiedzi
2017-08-03 10:08 How to replace every other instance of a particular character in a MySQL string? »
How to replace value in mysql column by query like, Column is options and its of type varchar(255) From id options 1 A|10|B|20|C|30 2 A|Posi...
(5) odpowiedzi
2017-08-02 13:08 How check in PHP if entry in db deleted? »
I delete post: $this->delete('/api/posts/1'); How check if that delete? $this->assertNull(Post::find($post->id)); It doesn't work! ...
(4) odpowiedzi
2017-08-02 13:08 Select all from a table ORDER BY another tables column, with match primary key »
I've been looking for a while but the query I am trying to accomplish seems fairly hard to find any information or documentation on how to do what I a...
(3) odpowiedzi
2017-08-02 11:08 Sqoop incremental load lastmodified not working on updated records »
I'm working on a sqoop incremental job to load data from mysql to hdfs. Below is the following scenarios. Scenario 1: Below are the records inserted...
(2) odpowiedzi
2017-08-01 19:08 Maximize database performance for very long digit »
I have digitalized image hash, the hash is like 2k integers long. What's is the best solution to store it in database and search? Row count will be at...
(1) odpowiedzi
2017-08-01 15:08 MYSQL Join weeks table with Sales and Group by Salesman and Weeks »
I currently have a database that tracks sales for a team of salesman. I have a query that will pull the each salesman and their associated totals but...
(2) odpowiedzi
2017-08-01 14:08 Select all where [first letter starts with number or special characters] »
I want to search in database the title start by a letter, number or special characters. For letter is good I use this: SELECT author FROM lyrics WHE...
(2) odpowiedzi
2017-08-01 05:08 DB update query in Laravel? »
I'm trying to update the hours_worked column in daiy_attendance table using in_time and out_time in same table. in_time and out_time already stored in...
(1) odpowiedzi
2017-07-31 21:07 MySQL Double many-to-many on an Entity »
I have a project where I have Products and SKU's. Each Product has one or many SKU's. I also have Shops that can have many to many Products, So a Pro...
(2) odpowiedzi
2017-07-31 11:07 How to select distinct records with where conditions without using sub queries »
I have a table with the following schema (Id(int PK),EmployeeId(int),DepartmentId(int),IsSelfAccessToDepartment(bit)) this table can contain the f...
(3) odpowiedzi
2017-07-31 07:07 Laravel 5.4: How to order by count(column) in eloquent? »
I am trying to display the names of assignee arranged by the most tickets assigned_to. $accesses = Access::where('state','=','Assigned'); $all = Rep...
(4) odpowiedzi
2017-07-30 17:07 Optimizing ORDER BY »
I am trying to optimize this query that sorts posts by reputation field (1st) and then id field (2nd). Without 1st field query takes ~0.250sec, but wi...
(4) odpowiedzi
2017-07-30 14:07 clean up table in MySQL which uses auto increment »
My table looks like this: table_id | letters -------- | ------- 4 | a 10 | b 24 | c 78 | d 110 | e 23...
(3) odpowiedzi
2017-07-30 14:07 How to handle too many database connection in PHP without an increase to max connections? »
There is a file called function.php and I am calling it into all my website's pages with require_once. This file contains more than hundred functions....
(6) odpowiedzi
2017-07-30 12:07 Foreign key is incorrectly formed »
When I changed my primary key from increments to string (user_id) i now got an error in my migrations. I dont seem to see where I went wrong. my migra...
(2) odpowiedzi
2017-07-29 20:07 What is the optimal way of setting up a database for a messaging/email application? »
I am currently trying to create an email style web app to allow users of my site to contact one another. I have created an SQL table for this, which h...
(2) odpowiedzi
2017-07-29 14:07 A RESTful Web Service using MySQL Community Server and jQuery AJAX »
I am trying to create a RESTful Web Service using MySQL Community Server and jQuery AJAX My jQuery AJAX does not work properly, so if i want add, del...
(1) odpowiedzi
2017-07-29 11:07 crontab shows the mysql error »
I am creating the rails app with 'whenever' gem. And I defined the function in the User model and I want to execute the function every 7am. But my fu...
(1) odpowiedzi
2017-07-29 11:07 Django 1.11 not recognising Foreign Key model assignments »
I am having an issue with 2 Foreign Key assignments in my django model. See models.py below: from django.db import models from django.contrib.auth.mo...
(1) odpowiedzi