Data dodania Pytanie
2017-08-11 10:08 Mysql How to join 2 tables and 1 table itself »
I have a table name tbl_user this table contain db_uid db_fname db_lname db_responsibleid db_email 1 xxx yyy 0 ...
(2) odpowiedzi
2017-08-11 09:08 cant connect mysql db from remote machine even after creating a user »
i have written a java code to connect my mysql db. its absolutely working fine. but now i want to run this code from different machine. to access thi...
(1) odpowiedzi
2017-08-11 08:08 Recover original data saved as "???????" from mysql database »
While saving the information to the database field the settings were as follows: character set: latin1 collation: latin1_swedish_ci Once the users ...
(3) odpowiedzi
2017-08-11 08:08 Get commentable class attributes using Baum in Laravel »
I am using Laravel Commentable that uses Baum Post Model class Post extends Model { use Commentable; .... My user model name is User Comment ...
(1) odpowiedzi
2017-08-10 17:08 Laravel Eloquent increment a column based on a relation »
I currently have a table of image links associate with another model as follows +----+-------------+----------------+ | id | property_id | url ...
(1) odpowiedzi
2017-08-10 14:08 Two different post types in one query »
I have two table in the database: posts table id|name|message|time notification table id|name|initiator|type|message|time What I want is two ou...
(2) odpowiedzi
2017-08-10 07:08 Django - performance difference between join/no join existence filter »
currently I have a Tinder-like application that functions off the following models class User(models.Model): id = models.BigAutoField(primar...
(0) odpowiedzi
2017-08-10 00:08 SQL GROUP BY two different group »
Is it possible to list the city name which only contains unique Coast and Region? (i.e. there are multiple cities in the same coast and region, thus t...
(1) odpowiedzi
2017-08-09 17:08 Left outer join and OR clause is slow. Is it possible to join after filtering? »
I have 2 tables like below. (1 million records in each table) When I join the two table and execute a query with OR clause, it is very slow. Is it pos...
(2) odpowiedzi
2017-08-09 09:08 MySql recovering deleted table »
Unfortunately I cleanUp one of the tables on my database and i'm trying to recover it with the mysqlbinlog command on mysql cli, as i just learned tha...
(0) odpowiedzi
2017-08-09 00:08 Issue when having Symfony form/entity field name 'from' »
I have a entity with following fields: /** * @ORM\Column(name="from", type="string", length=255, nullable=true) */ protected $from; /** * @ORM\Co...
(2) odpowiedzi
2017-08-08 21:08 Why does SQL query with GROUP BY produce more rows? »
I have the following table: +------+-------+--------------------------------------+ | id | rev | content | +------+-...
(3) odpowiedzi
2017-08-08 18:08 CFQUERY update inner join two tables from separate servers »
I have this update statement - <cfquery name="updateqry" datasource="thisone"> update dbOne.tableA a inner join dbTwo.tableB b on a.do...
(0) odpowiedzi
2017-08-08 08:08 How to repeat the table column header in each page »
I'm using FPDF to create a PDF file which the data is getting pulled from a MySQL database. And the table is getting created with two main column head...
(1) odpowiedzi
2017-08-08 05:08 Set every username can choose the items in spinner one time »
My case now is every username can select the items in spinner one time only. Mean if the spinner has 5 item, the user can choose all of them but all o...
(3) odpowiedzi
2017-08-07 15:08 How to get latest comments from each post in Rails? »
I have a standard blog models, user, posts and comments. How can I query for 1 latest comment of each post of custom user? I know we can connect user...
(2) odpowiedzi
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