Data dodania Pytanie
2017-02-07 17:02 Use multi-dimensional PHP array in to create friendly URLS for each menu item in MySQL database »
The MySQL navigation table uses id, parent_id, name to have an unlimited navigation depth. I am using a recursive function to create the multidimensio...
(1) odpowiedzi
2017-02-07 16:02 How to optimize MySQL query with large data on left join? »
The query below returns a set of User and for each row a number of relations from the user perpective who is searching (id = 4) SELECT `users`.`first...
(1) odpowiedzi
2017-02-07 09:02 Architecture change to handle huge records in single table of MySQL with 5K DB connections support »
70 java client make around 1500 simultaneous connection every 10 minutes on single table to insert records. Table contains 300M records. Number of rec...
(0) odpowiedzi
2017-02-06 23:02 Getting "incompatible character encodings: UTF-8 and ASCII-8BIT" error when displaying user entered ASCII-8BIT character »
A user saves text in a form with the word "café," (note the "é"). When loading the #show page displaying this text, I get an Encoding::Compatibility...
(1) odpowiedzi
2017-02-06 21:02 Insert query error: Column count doesn't match value count at row 1 »
I have a cfquery that I'm looping over the values to insert multiple rows into the database. I have to do it this way, instead of generating multiple ...
(1) odpowiedzi
2017-02-06 20:02 Coldfusion loop over insert query values »
I am trying to loop over an insert query. I'm looping over the values to the return results are within a list. <cfquery datasource="#OLMSdatasourc...
(1) odpowiedzi
2017-02-06 20:02 Two Laravel applications on the same server conflicting with one another »
I have 2 Laravel applications running on the same server. The server is Apache 2.4 and I have vhosts set up to serve each application on a different d...
(2) odpowiedzi
2017-02-06 17:02 Unknown column '..' in 'field list' join »
I made a simple query with join but get always this annoying error. The query: SELECT `verk.id`, `verk.date`, `verk.quant`, `verk.verid`, `verk...
(2) odpowiedzi
2017-02-06 15:02 How to get the item id inside a foreach loop? »
I have a this problem for a long time and always solved it on a really bad way. When I have a loop that goes through the selected items (in this case...
(0) odpowiedzi
2017-02-06 09:02 Stuck in error 2 with mysql using XAMPP »
I'm trying to make a webpage using XAMPP with apache and MySQL after that I will use WordPress for creating the web page. I have a problem creating th...
(1) odpowiedzi
2017-02-06 08:02 how to auto generate a number in mysql? »
page id 1 a1 1 a2 1 a3 2 a4 2 a5 2 a6 3 a7 3 a8 3 a9 ` what i need to know is how to auto ...
(2) odpowiedzi
2017-02-06 07:02 How to do group by and take count of unique and count of some value as aggregate on same column in python pandas? »
My question is related to my previous Question but it's different. So I am asking the new question. In above question see the answer of @jezrael. df...
(2) odpowiedzi
2017-02-05 21:02 Error establishing a database connection on localhost xampp os x »
i am very beginner in wordpress and want to learn it and the first step was fail :( i tried to install it on localhost (xampp) and this error "Error e...
(1) odpowiedzi
2017-02-05 16:02 Eloquent - multiple WHERE LIKE conditions »
I'm currently trying to implement a search in my db for keywords. Therefore I split a string seperated by a comma, so I get an array containing a vari...
(3) odpowiedzi
2017-02-05 00:02 turn rows values to columns , and count repetitions for all possible values mysql »
I have a table(from log file) with emails and three other columns that contains states of that user's interaction with a system, an email(user) may ha...
(4) odpowiedzi
2017-02-04 22:02 Is value on the list of values? (Oracle SQL) »
Below works for SQL Server and MySQL, but how to modify it to work as proper Oracle query: SELECT city FROM station WHERE LEFT(city, 1) IN ('a', 'e',...
(2) odpowiedzi
2017-02-04 22:02 Why does MySQL return 1175 code after calling UPDATE procedure WITH where clause which uses primary key? »
I know that I can unchecked the 'safe update' mode but I want to understand why MySQL server returns this error even when all things look like correct...
(0) odpowiedzi
2017-02-04 19:02 Database design choice : Order Belongs To Invoice Or Invoice Belongs To a Order »
there is a website which used to sale physical products ... now they want to sale some king of service which is completely different .... like credit ...
(3) odpowiedzi
2017-02-04 17:02 PHP Laravel Database: Get all entries from one table + more »
My problem is a bit abstract, so I can't really explain. I have a few tables: table 1 is called videos and the other tables are categories like Dell,...
(1) odpowiedzi
2017-02-04 15:02 What's the difference between these two left join sql queries? »
There are two tables: customers and orders. Customer can have one or more orders. I would like to understand the difference in terms of execution spee...
(2) odpowiedzi
2017-02-04 11:02 Set password after google authentication in laravel 5.3 »
I am trying to implement google login using socialite plugin in laravel in which I want to set password filed (is user should set a new password befor...
(0) odpowiedzi
2017-02-04 11:02 Date now + 1 month in nodejs »
this is my code in ejs file : <select class="form-control track-change input-lg" data-track="deadline" name="Deadline" id="Deadline" placeholder="...
(1) odpowiedzi
2017-02-04 09:02 mysql query order by case when and field »
does anybody have an idea how to speed up this query. i am looking for keywords "bar" and "cafe" in several fields on just 1 table as seen below, the...
(0) odpowiedzi
2017-02-03 14:02 How to optimize MySQL query when field values are not distinct »
Suppose I have a MySQL table, with a indexed field called balance. However, the table contains 95% of rows with balance = 0. So if I was to go: Selec...
(2) odpowiedzi
2017-02-03 08:02 MySQL Inner Join with null columns »
Assuming I have 2 tables Table a brand Fruit edible color size farmers banana yes yellow null fresh banana ye...
(2) odpowiedzi
2017-02-03 03:02 Select * matches where current date bigger than now and current time bigger than now »
Working with dates and times has always been a challenge for me, I have done plenty of research on SE regarding mysql date queries but have not found ...
(2) odpowiedzi
2017-02-02 21:02 How to assign a dynamic property in a model via a SQL query in Laravel 5 »
I'm using Laravel 5.3 to build an API and I have an model for products. Whenever I retrieve a product, I want to retrieve the product's rating and it'...
(2) odpowiedzi
2017-02-02 18:02 Display database info into html table Wordpress »
I have the table called: persona, in my database. I just need to retrieved the data in this table into a html table inside a page in wordpress. SO fa...
(2) odpowiedzi
2017-02-02 12:02 Anchor tags with same class not returning value on button click in jquery »
I have the following HTML: <a class="sortorder" data-order="asc" >sort ascending</a> <a class="sortorder" data-order="desc">sort d...
(3) odpowiedzi
2017-02-02 07:02 Getting an incorrect AVG() value for column in sql »
I'm writing a sql query that would groupby a column and return it's min, max and average values. Here's what I'm doing: CREATE TABLE Nums ( patient_i...
(4) odpowiedzi
2017-02-02 01:02 MAMP MySQL Server wont start »
Apologies if this is a repeat, I have had a look at the other questions and cant find a solution. I'm not really very knowledgable about this stuff so...
(1) odpowiedzi
2017-02-01 22:02 Eloquent returns POINT data as UTF8 »
I'm using Eloquent to get some data from the database. My database has a column that uses the POINT data type. The columns have values such as POINT(5...
(1) odpowiedzi
2017-02-01 22:02 Check PostgreSQL table column for value and return boolean »
I am just learning SQL and apologize if this is repetitive, but I have searched and not found an answer. Writing in python with a PostgreSQL DB. I wa...
(2) odpowiedzi
2017-02-01 18:02 Fetch returns only one item in collection »
Table info: The Image table contain a foreign key mediaid for its the parent table Media ---------- id | mediaid | url ======================== 104...
(1) odpowiedzi
2017-02-01 09:02 How can I order selected rows alternatively »
Here is my query: SELECT pr1.id AS user_id, pr1.title AS user_name, pr2.id AS liker_id, pr2.title AS liker_name, x.which AS which_table, ...
(3) odpowiedzi