Data dodania Pytanie
2017-03-10 22:03 HTML dropdowns populate using PHP and MySQL »
I've read a number of posts on this topic, but still can't seem to locate my problem. I would consider myself a beginner when it comes to HTML Forms ...
(2) odpowiedzi
2017-03-10 18:03 CFQuery where clause comparison to query results »
I have a query that returns 7 records: <cfquery name="equip" datasource="#datasource#"> select equipment_id from service_ticket where equipment...
(2) odpowiedzi
2017-03-10 11:03 SQL select query with multiple conditions issue »
I have a problem with a SQL select query, I can't figure out what it needs to be. This is what my items table look like: | id | i_id | last...
(3) odpowiedzi
2017-03-10 09:03 Select all records whose specific field is not NULL »
I have a MySQL table named stars and one of its fields is id_num with default value NULL. I want to select all the records where id_num is not NULL th...
(4) odpowiedzi
2017-03-10 07:03 Order and sort_by diffference in Ruby on Rails ActiveRecord »
I am tryig to sort my data according to timestamp field in my controller, note that the timestamp field may be null and may have some value. I wrote t...
(3) odpowiedzi
2017-03-09 23:03 MySQL returning multiple results for a single emoji »
I'm observing some strange MySQL behavior for VARCHAR fields that contain a single emoji. The connection, database and column are all utf8mb4 encoding...
(2) odpowiedzi
2017-03-09 22:03 Calculating position variations »
MySql newbie here. I will try my best to explain my problem. I have the following records on a table: Date | Course | Posit...
(2) odpowiedzi
2017-03-09 19:03 MySQL: Pivot-like query result »
Given the following query, which produces a list of students and the cohorts to which they are assigned: SELECT mdl_user.lastname, mdl_user.firstname...
(2) odpowiedzi
2017-03-08 20:03 Looping through ColdFusion Query and Incrimenting a Counter »
I have a scenario where I record a 'date of last completed' for a task as a column in my database as well as an interval period (in days) for the next...
(3) odpowiedzi
2017-03-08 14:03 One-to-many select in Jooq »
I am trying out JOOQ and trying to select from 3 tables (Author, Books and Articles) using a join statement. The ERD is as follows: Author ----< B...
(1) odpowiedzi
2017-03-08 09:03 Dynamically created multi select box values not inserted correctly »
<table> <tr> <td><select class="form-control selectpicker" data-live-search="true" name="reson[]" required="required"> ...
(4) odpowiedzi
2017-03-08 08:03 GROUP BY with CASE statement »
I have a table jobs with the following structure ================================================ | userID | jobDate | cityID | totalCost | ==...
(1) odpowiedzi
2017-03-07 23:03 SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'property_id' cannot be null in Laravel 5.2 »
I am trying to solve this problem, where I try to edit multiple files with the update method in laravel 5.2. When I run my process and save it return...
(2) odpowiedzi
2017-03-07 21:03 How to get and order the most relevant entries from the database with multiple keywords Laravel 5 »
I am having trouble handling multiple keywords and querying the database based on relevance. I want to search each row and if there is more than 1 key...
(1) odpowiedzi
2017-03-07 19:03 Why this sql is correct? (sql injection) »
What does it mean? SELECT * from users where password = ''*''; if I check this in mysql workbench I get only one line, although I have lot of users...
(3) odpowiedzi
2017-03-07 18:03 How can I keep a data when ON DUPLICATE KEY executes? »
Here is the scenario: I'm trying to make a mechanism on some text comments. For example I want to calculate the most used words in some comments. Here...
(2) odpowiedzi
2017-03-07 15:03 How to pull an image URL from a database and populate a Meta tag »
I am trying to figure out how to pull an image URL from a database and insert it into a <meta> tag. Say picture is the name of database column...
(1) odpowiedzi
2017-03-07 13:03 ROR application with Mysql 5.6 - transaction-isolation with Master -Slave »
We are running a ROR application with Mysql 5.6 and master/slave replication. We are facing deadlock issues. We've successfully tested changing sett...
(0) odpowiedzi
2017-03-07 10:03 Unknown column in 'having clause': »
I'm working on a project where I have many users, and a user has many posts. I'm trying to get the users that have a post count over a certain thresho...
(2) odpowiedzi
2017-03-07 06:03 Pandas column indexing for searching? »
In relational database, we can create index on columns to speed up querying and joining on those columns. I want to do them same thing on pandas dataf...
(1) odpowiedzi
2017-03-07 03:03 SQL - calculate MODE without sorting »
I would like to calculate the MODE of a single column in SQL. This is done easily enough with: SELECT v AS Mode FROM Data GROUP BY v HAVING COUNT...
(2) odpowiedzi
2017-03-06 18:03 Product with same model to related products table »
I'm getting crazy to create an insert to a table from a select of same model. I think that I should create a temp table to elaborate all model, but ho...
(1) odpowiedzi
2017-03-06 15:03 MySQL: SUM two UNIONed tables (4x SUM in one result) »
i have to SELECTs, UNIONed in one simple query... SELECT description_x, a, b, c, d from table a WHERE person_id = 1 UNION SELECT description_y, e ,f...
(2) odpowiedzi
2017-03-06 10:03 Cannot fetch some special characters from mysql table in codeigniter »
I have a issue while fetching some data from the mysql table whose data type is "text". What i have is a portal for instructor and student. Student wi...
(2) odpowiedzi
2017-03-06 09:03 Why is it a syntax error? »
Simple query like this. MyModel.where('student_id = :id AND from <= :date AND to >= :date', {:id => student.id, :date => day.to_s(:db)}) ...
(1) odpowiedzi
2017-03-05 21:03 SQL select rows which are identical in two values in a way that retains Edit features in output »
Apologies if the answer is dead obvious but in spite of a lot of research and trying out different commands, the solution escapes me (I'm more of a le...
(2) odpowiedzi
2017-03-05 16:03 Printing mysql data to EJS document with foreign keys »
Link to github project I'm trying to get answers to quiz questions from mysql and print to a form using EJS templating in node/express application. I...
(1) odpowiedzi
2017-03-05 08:03 mysql merge two or more select into one table »
I want to combine my query below into one table but result from 'union' is merging it into one column. I want it create different column instead of o...
(1) odpowiedzi
2017-03-05 08:03 Access denied for user 'root'@'localhost' (using password: NO) - working with `mysql -u root -p` »
I only access to success with command: mysql -u root -p Another command like: mysql or mysql -u root have same error like: Access denied f...
(0) odpowiedzi
2017-03-04 21:03 SQL - Calculating median without sorting »
I have an SQL table with one column of integer values and I would like to find the median of those values without any sorting. I first tried finding t...
(2) odpowiedzi
2017-03-04 18:03 Migration from PostgreSQL to Mysql - Invalid timestamp literal detected »
I am using MysqlWorkBench to migrate a PostGreSQL database, but I'm running into issues with the timestamp columns. The PostgreSQL database is using ...
(1) odpowiedzi
2017-03-04 14:03 EJS getting specific data from MySQL »
Github project link So, I am making a Quiz creation application using EJS as templating engine with jQuery, Bootstrap and MySql. I'm trying to loop ...
(1) odpowiedzi
2017-03-04 12:03 Checkbox & Check all function in Datatable Jquery PHP Mysql »
The below is the php script for fetchingd data from database table in json to Datatable; <?php /* Database connection start */ $servername =...
(1) odpowiedzi
2017-03-04 09:03 jQuery Ajax Store Data to database by multiple checkbox check »
I have multiple checkbox below Demo can be find here We can see on above image, if I check some of that checkbox and then I click Update then it w...
(1) odpowiedzi
2017-03-04 06:03 Unique IP Counter with Laravel and MySQL »
I'm trying to make a simple Unique IP counter for gallery page views. The idea I have is to keep the views records separate from the image records in...
(1) odpowiedzi