Data dodania Pytanie
2017-01-11 20:01 Why does MySQL treat Japanese alphabets hiragana and katakana the same, and how can you make it compatible with Django? »
This question was partially addressed here, but I wanted to ask more specifically: MySQL difficulties - Hiragana and Katakana are treated as the sam...
(0) odpowiedzi
2017-01-11 12:01 How to implode these conditions to achieve this query structure? »
Below is my working query that gets into action after a form submit. My query works only if all textboxes are filled, so currently everything is requi...
(5) odpowiedzi
2017-01-11 07:01 How do large scale databases handle locks? »
I have a question about databases and updating rows. I am currently running a flask application, and the endpoint runs a command like this (Please ac...
(3) odpowiedzi
2017-01-10 20:01 Better approach for updating multiple data »
I have this MySQL table, where row contact_id is unique for each user_id. history: - hist_id: int(11) auto_increment primary key - user_id: int(11) -...
(1) odpowiedzi
2017-01-10 18:01 Complex Database Queries in yii2 with Active Record »
TL;DR I have a query that works in RAW SQL but i have had little success recreating it with query builder or active record. I am working on a web ...
(2) odpowiedzi
2017-01-10 14:01 How can I remove characters that are not supported by MySQL's utf8 character set? »
How can I remove characters from a string that are not supported by MySQL's utf8 character set? In other words, characters with four bytes, such as "
(1) odpowiedzi
2017-01-10 14:01 Laravel many to many relationships - retrieving models »
If we have something like this: user id name role id name shop id name role_user role_id user_id shop_user shop_id user_id Quick...
(2) odpowiedzi
2017-01-09 16:01 How can I inject "variables" WHERE clauses into a query? »
I have a query: SELECT * FROM table_name WHERE name=? surname=? gender=?; and I have to inject the strings into the query (I use the prepared statem...
(2) odpowiedzi
2017-01-09 14:01 Why mysql select count(distinct user_id) return wrong number? »
I have a big table in mysql.It has 13 million rows. Mysql version is 5.7.10. Table structure as below: create table table_name ( user_id varc...
(0) odpowiedzi
2017-01-09 12:01 How to get data from 2 tables based on search keyword rails »
I have 2 tables schools and private_schools and they are not related to each other. What I need to do is to search the data from both tables to popula...
(3) odpowiedzi
2017-01-09 11:01 Selecting records on condition - Joomla »
I followed Joomla doc about how to select data from a single table. I need 3 OR conditions. $db = JFactory::getDbo(); $query = $db->getQuery(true)...
(2) odpowiedzi
2017-01-09 11:01 rails mysql regex input not getting sanitized properly »
I am doing the following on a rails 3 app def test(str) User.where("name REGEXP ?",str).last end Using the format above, rails generally handle...
(1) odpowiedzi
2017-01-09 06:01 node js (with ejs view engine) and datatables »
I am using node js with ejs view engine and mySql database. I want to use datatable in my application with Server-side processing in node js so how sh...
(0) odpowiedzi
2017-01-08 21:01 Is it more efficient to use AWS s3 versioning to store gzipped mysql dumps? »
With my database, we are taking a mysql dump for backup every hour. We then upload that backup to AWS s3 for safety and redundancy. We are using ver...
(1) odpowiedzi
2017-01-08 10:01 How to return rows in table1 not present in table2 in laravel »
I have tried using join table in laravel role_user table has the roles_id and the user_id column roles table has the id and the name of the role user...
(2) odpowiedzi
2017-01-08 03:01 How do I Select from all Tables a certain column to a string array in C# »
I need to get from each individual table but from the same column name the value to a string array. Although I don't what I table names I've got. I on...
(2) odpowiedzi
2017-01-07 15:01 How can i do Laravel pagination for multiple table results? »
In Laravel, I have multiple table results from controller to view. I need to do pagination for this set of results. How can I do that? I have these m...
(1) odpowiedzi
2017-01-07 12:01 MySQL Gem Install Error on Ruby 2.4 »
I have a problem with an install of mysql gem. This is my error : gem install mysql -v '2.9.1' Building native extensions. This could take a while.....
(1) odpowiedzi
2017-01-07 07:01 Two dimensional array in Twig »
I have satellite images stored in a mysql database. The table has attributes latitude,longitude. I want to send them to the twig and display as a map,...
(1) odpowiedzi
2017-01-06 20:01 mysqli_multi_query doesn't work reliable with mysql conditional comment queries »
I am having an issue with mysql conditional comment queries where errors are reported with no syntax error. It works in the case that at least one of ...
(3) odpowiedzi
2017-01-06 10:01 Mysql query unknown behavior »
I have the following query that I'm working on for a wordpress website: Select posts_tender.ID AS tender_ID, tender_meta_user_ministry_tbl.me...
(0) odpowiedzi
2017-01-06 10:01 SQL multiple OR chain query »
I have a single table where I am attempting to access rows via a simple SQL query I think, however, I am misunderstanding the way the OR modifier tech...
(2) odpowiedzi
2017-01-05 22:01 Facebook Graph API to Post to Page not working on new server »
So I have been using the below code on my shared hosting server and it has been working fine but now we have moved to a dedicated server but this scri...
(1) odpowiedzi
2017-01-05 20:01 Delete/detach first pivot table records »
Case Laravel 5.3 Having a pivot table between Cart & Product with an additional column: id - cart_id - product_id - item_id (additional colum...
(1) odpowiedzi
2017-01-05 18:01 SQL Consecutive records with count »
Table Name Calls Field 1 - Phone_number Field 2 - System_outcome Phone_number System_outcome DateTime ----------------------------------------...
(3) odpowiedzi
2017-01-05 12:01 Laravel Carbon Group by Month »
Can anyone see what I'm doing wrong? I'm trying to output all the months but group them so they are unique. $months = NewsItem::select(DB::raw('MON...
(3) odpowiedzi
2017-01-05 11:01 PHP mysql - Display comma separated value from the database in tabular form »
I am complete beginner I want to display comma separated values from database in tabular form From the below image link we can see how the data is ...
(2) odpowiedzi
2017-01-05 04:01 MySQL - Efficiently delete all records except last N »
I started learning SQL recently and now was asked to perform a simple deletion on a table, keeping the last 100 records for each user. I was researchi...
(2) odpowiedzi
2017-01-04 20:01 How to put a CASE statement in the GROUP BY clause »
I've got a table with one column that is a comma separated list of possible values. I'd like to query, grouped by each individual possible value. As...
(2) odpowiedzi
2017-01-04 16:01 How can I retrieve the properties of a data object in EJS/node.js? »
I am passing a data object, as a parameter, to the render method, and assigning to it the variable name "values". app.get('/', function(req, res) { ...
(2) odpowiedzi
2017-01-04 14:01 MySQL sum each X rows »
I need little MySQL help. I have a table with hourly values like that: ID | VALUE | HOUR 1 | 1.0 | 01.00 2 | 1.0 | 02.00 ... 24 | 1.0 | 24.00...
(2) odpowiedzi
2017-01-04 11:01 Doctrine query builder gives wrong result »
I have two entities Person and Nursery and I have a ManyToMany relation between them with a JoinTable. I want to make this 2 sql queries : 1) Find a...
(2) odpowiedzi
2017-01-04 02:01 Object of class Carbon\Carbon could not be converted to int »
I have already search for this, and i did find some topics discussing this problem, however none of which I felt like was the way I want to go, so the...
(1) odpowiedzi
2017-01-03 22:01 Laravel Relationships -Trying to get property of non-object »
I am coding an RP cms and I am trying to do the following. So in my MySQL database I have two tables that are important to this question. srp_user_s...
(2) odpowiedzi
2017-01-03 13:01 MySQL vs PostgreSQL JSON search features »
I have been searching for a blog post or a feature matrix which compares MySQL and PostgreSQL by their JSON capabilities. I found a good feature matri...
(1) odpowiedzi