Data dodania Pytanie
2017-03-03 07:03 when implementing Spring Security configuration getting java.lang.StackOverFlow »
I'm trying to configure my WebSecurityConfig class for my mySQL database. What i m trying to achieve here is once user is created , automatically toke...
(0) odpowiedzi
2017-03-02 20:03 Can query be optimized: Get a records max date then join the max date's values »
I've created a query that returns the results I want but I feel there must be a better way to do this. Any guidance would be appreciated. I am trying...
(3) odpowiedzi
2017-03-02 16:03 Loop through different tables with variable names »
I know what you'll say "that is one terrible design". I know, I have been coping with it for the last couple of months (again, it was not my design), ...
(4) odpowiedzi
2017-03-02 13:03 mysql - how to display error instead of throw err in nodejs »
I have put some constraints in my mysql table and thus when a duplicate value is entered, it throws an error and the server shuts down. What I want in...
(1) odpowiedzi
2017-03-02 06:03 Insert row if not exists without deadlock »
I have a simple table CREATE TABLE test ( col INT, data TEXT, KEY (col) ); and a simple transaction START TRANSACTION; SELECT * FROM test W...
(2) odpowiedzi
2017-03-02 02:03 Struggling to add has_many through relationship »
I am trying to make a has_many through relationship like this: #user.rb class User < ApplicationRecord # Include default devise modules. Others ...
(3) odpowiedzi
2017-03-01 21:03 Populate data from mysql to ejs »
Link to github https://github.com/AEkman/Quiz I'm trying to get data from mysql database and print to a html table using EJS. This is my function ca...
(2) odpowiedzi
2017-03-01 18:03 Google Maps documentation uses deprecated PHP - how can I update it? »
https://developers.google.com/maps/documentation/javascript/mysql-to-maps Features deprecated PHP for connecting to a MySQL database, i.e. using mysq...
(1) odpowiedzi
2017-03-01 13:03 How to merge these two DataFrames »
import pandas as pd left = pd.DataFrame({'key': ['K0', 'K1', 'K2', 'K3'], 'A': [1, 2, 3, 4], 'B': [1, 2,...
(2) odpowiedzi
2017-03-01 05:03 Mysql 5.6: how to limit the number of update or delete operation »
I want this... When the update or delete operation affects the number of rows greater than 1000, is prohibited. How can I accomplish this? ...
(1) odpowiedzi
2017-02-28 22:02 JQuery Datatable - Split single cell into multiple columns for readability? »
With JQuery Data tables, is it possible to split a single column up into parts purely for readability? For example, I have a databases of URLs split i...
(1) odpowiedzi
2017-02-28 16:02 Link to another table to get name with inner join »
The following code shows the max date for an item and all works well. SELECT pricing_id, pricing.field, pricing.region, price, max_date FROM...
(3) odpowiedzi
2017-02-28 07:02 PHP - MySql : How to store and retrieve checkbox value with other option »
I using checkbox to get and store interest of user. Store these data in database mysql with comma separated My php code for retrive these data...
(1) odpowiedzi
2017-02-28 05:02 Use unique validation for only specific record in database table in Laravel 5 »
I'm trying to validate unique question for specific book_id it means is should be unique only specific record. table: questions $title = this is que...
(3) odpowiedzi
2017-02-27 19:02 Create a object from another object in rails »
I want to create some records in my mysql database using some existing records. I am using rails 4.2 This is the relevat code in my controller: link...
(2) odpowiedzi
2017-02-27 16:02 mysql partitioning does not work »
I have a table with field which is action_time primary key and type is datetime I try to break it on partitions ALTER TABLE foo PARTITION BY RANGE ...
(1) odpowiedzi
2017-02-27 10:02 MySql sorting working abnormally »
I have written a stored procedure which returns sorted(ascending or descending) data based on the column which user has selected. To achieve that I us...
(6) odpowiedzi
2017-02-26 22:02 Cast as Float returns ActiveRecord::StatementInvalid: Mysql2::Error »
So I am doing the following in Rails 4.2.7 @product.reviews.select('CAST(answer_1 AS FLOAT) AS answer_1') Unfortunately this returns ActiveRecord::...
(1) odpowiedzi
2017-02-26 21:02 What is the meaning of the letter 't' in mysql query »
SELECT * FROM (SELECT * FROM my_table ORDER by row_id DESC LIMIT 8) t ORDER BY RAND() I saw this in an answer, What does the 't' mean before ORDER B...
(1) odpowiedzi
2017-02-26 21:02 Laravel - view not defined - (closed) »
im learning laravel, and im trying to create a form that list the cars in a cars table and if clicked, sends into another form which is based on a DB ...
(1) odpowiedzi
2017-02-26 20:02 Bots are killing mysql with "too many connections". It is NOT an increase max connections issue »
My website can handle 40,000 people or more simultaneously and run fast but a search engine bot will kill mysql. It's been driving me insane because o...
(1) odpowiedzi
2017-02-26 08:02 What exceptions could be returned from Pandas read_sql() »
I have a user-defined function that uses pymysql to connect to a mysql database and then it interrogates the database and reads the results into a Pan...
(1) odpowiedzi
2017-02-25 22:02 How to pull json data from data mysql as object using laravel5? »
I have a table which contain JSON in a column that I have to get as an object but when I pull data using laravel model then it obviously return as JS...
(1) odpowiedzi
2017-02-25 18:02 Keep getting Unknown or bad timezone from Carbon Laravel »
I'm trying to add 2 months to a date with Carbon, but I keep getting this error: InvalidArgumentException in Carbon.php line 252: Unknown or bad...
(1) odpowiedzi
2017-02-25 16:02 Get only rows where exists in table? »
I need to select all rows from table: Announcements where there are exist rows in table Categories_announcements for user by condition: Categories_us...
(5) odpowiedzi
2017-02-25 13:02 Having an error in sql while creating table »
I am trying to create a table on my database. this is the error #1064 - You have an error in your SQL syntax; check the manual that corresponds to y...
(1) odpowiedzi
2017-02-25 02:02 PHP PDO, excluding row with null field value »
So I am using this sample code output6.php What I would like to do is if empire_name returns null, skip the associated row Any ideas or suggestions w...
(2) odpowiedzi
2017-02-24 20:02 How to pull data from 2 table in stack »
I know many the many people think i can use "join" to pull data from two table but that's not i want. actually it is kind of question to me, is it po...
(2) odpowiedzi
2017-02-24 14:02 Laravel 5 relationship not working »
I have courses and subscription types. A subscribed user has a subscription type, i want all the courses that a users subscription type matches. My a...
(1) odpowiedzi
2017-02-24 12:02 Fetch all points from database inside a bounding box of north east and south west coordinates in MySQL »
I am currently building an application to show all geo-tagged trees in a particular city. The main columns I am using to fetch data from the table are...
(2) odpowiedzi
2017-02-24 11:02 Update row with values of other column's row of same Table in mysql »
I have a table:- +----------+--------------+-------------------+-----------+ | IsActive | IsFirstChunk | TotalResponseTime | StallTime | +--------...
(3) odpowiedzi
2017-02-24 01:02 How do I update a row of data in mysql using PHP? »
I'm attempting to create a form where the user can update their profile details but it just doesn't seem to work. I'm quite the beginner in server si...
(2) odpowiedzi
2017-02-23 22:02 Edit duplicate if exists mysqli php »
I have some troubles with my mysqli INSERT code. I don't really know how to deal with duplicates but I have read many posts there and I tryied to get ...
(1) odpowiedzi
2017-02-23 20:02 How to access CFQUERY SUM value »
I am trying to get a single numeric value from a <cfquery> that is performing a SUMPRODUCT calc. I know that the the following code works to pr...
(1) odpowiedzi
2017-02-23 14:02 Doctrine: Relations between two entities in two databases »
I'm using MySQL and Doctrine 2 (with Symfony 3). I want to set up a ManyToMany relationship between two entities wich are in two separate databases. ...
(2) odpowiedzi