Data dodania Pytanie
2017-04-13 21:04 MySQL User with Roles, Role specific fields? »
I have an application where a User can be a Supplier or a Shop. Now these 2 roles have very different role-specific fields.. Basically, a Shop ...
(3) odpowiedzi
2017-04-13 09:04 MySQL datetime to echo on PHP »
I want to show in my page that the database they were looking at was last modified on a certain date & time. I have the following code for that: ...
(2) odpowiedzi
2017-04-13 07:04 Getting no of products in all categories and parent categories contains a keyword »
I am trying to fetch all the categories and their count (no of products in that category) of those products where keyword matches. The query I tried d...
(1) odpowiedzi
2017-04-12 23:04 Error on Like Operator »
Select * From menu WHERE menu_item_desc LIKE ‘kids%’; On this statement I am getting an error saying to check the syntax to use near '%' LIMIT ...
(1) odpowiedzi
2017-04-12 18:04 Replace string with wildcard »
I am moving a site that I manage from a custom CMS to Wordpress and am finding that some of the attributes on image tags to be problematic on display ...
(3) odpowiedzi
2017-04-12 14:04 How come this character sequence comparison returns true? »
How come the following SQL sentence returns true in MySQL? SELECT 'SeP' = 'sęp'; mysql> select 'SeP' = 'sęp'; +----------------+ | 'SeP' = 'sę...
(2) odpowiedzi
2017-04-11 22:04 Determine the closest free set of X/Y coordinates within an ever expanding 2D grid stored in MySQL »
I have a very basic MySQL table in which X and Y coordinates are stored for tiles within a grid. The center of the grid is 0,0 and tiles can be create...
(3) odpowiedzi
2017-04-11 19:04 Laravel 5.4 - Query relationship with search termn »
i'm working in laravel 5.4, i have this tables: PROJECT | id | tags | title | PRODUCT | id | project_id | category_id | CATEGORY | id | name | Th...
(1) odpowiedzi
2017-04-11 13:04 Select value that doesn't exists in two tables »
table1 table2 table3 Expected Result ------------- -------------- ------------- ------ | id | col1 | | i...
(3) odpowiedzi
2017-04-11 08:04 CI MySQL query join tables and where statement does not return all row »
I have 3 tables that I want to join, however when I use where statement on the third table, and the third table doesn't have it, it does not return th...
(1) odpowiedzi
2017-04-11 07:04 Multiple WordPress sites with one shared DB using Docker »
I want to run multiple WordPress websites with one shared database using docker. Is it possible to specify a database and set an appropriate volume t...
(0) odpowiedzi
2017-04-11 00:04 Rails how to Render a form instead of redirect on submit? »
I have a form that the results just show if render instead of redirect. so the form must not be redirected. someone know if this is possible with rai...
(1) odpowiedzi
2017-04-10 14:04 TYPO3 Reconnect to database »
I have a quite long running command controller/scheduler job, accessing the database at the very end. With standard MySQL timeout settings it runs in...
(1) odpowiedzi
2017-04-10 09:04 AWS RDS Aurora Reader Replication to External MySql Instance »
I want to use AWS aurora replica as a master for external MySQL instance. I have created an aurora instance and a read replica with BinLog enabled DB...
(0) odpowiedzi
2017-04-10 06:04 MySQL: Group ids and display different values on a separate column »
How to display employee with different phone numbers in one row only wherein phone numbers are displayed by column? Create Table Employees( Employe...
(1) odpowiedzi
2017-04-09 21:04 How to use select Case in the following SQL query »
I have two tables users and userdetail. I am trying to create a view in which if status of userdetail column is 1 it should show Active in view and bl...
(2) odpowiedzi
2017-04-09 19:04 Show names from two values »
I am trying to get a SQL code but can't really figure out how to do it so I will explain what I want. I have 4 tables called Person, Customer, Adres ...
(1) odpowiedzi
2017-04-09 09:04 laravel - if else loop not working proper »
I'm trying to write an if-else loop: if there is an embed saved in the database it should display a calendar, if not it should display a button saying...
(4) odpowiedzi
2017-04-08 19:04 Why is MySQL result OK when called from browser, but empty or NULL when called from C#? »
I'm trying to do a webrequest from my C# Windows application to my website, but the desired result is empty or null when called only from C# but not f...
(1) odpowiedzi
2017-04-08 18:04 laravel database query max(date) getting all posts »
I am using Laravel 5.4, where i try to get the latest post, but for some reason if I want to select the title, I end up getting them all, can someone ...
(1) odpowiedzi
2017-04-08 15:04 How can I separate wordpress in backend & frontend with docker container? »
I've created two containers for this using the following commands: docker run --detach --name=test-mysql --env="MYSQL_ROOT_PASSWORD=mypassword" mysql...
(1) odpowiedzi
2017-04-08 12:04 PHP: Running if and else if inside a while loop? »
I'm trying to run if and else if inside a while loop in my PHP code. The code looks like this: <?php $sql = "SELECT * FROM table ORDER BY id"; $...
(2) odpowiedzi
2017-04-07 21:04 I need some help to find an error »
I created a file with some useful PHP functions to operate with SQL databases but I have a problem with the code that inserts a record in a SQL table....
(2) odpowiedzi
2017-04-07 16:04 Restoring database to new cluster »
we are using Percona 5.7.16-10 server. I would like to expand current solution with XtraDB cluster. So meanwhile I created other machines and started ...
(1) odpowiedzi
2017-04-07 13:04 Duplicating SQL Row in Ruby »
A basic function that I just can't get my head around. I need to copy the values from one MySQL row to a new row - sounds easy. I've tried the below...
(2) odpowiedzi
2017-04-07 12:04 Laravel migration works in strange way »
I've dropped my test database then I want to create new database using saved migrations: 2017_03_01_000000_create_api_table.php 2017_03_06_000000_cre...
(1) odpowiedzi
2017-04-07 08:04 group by follow by order by in mysql »
I want to find out query in which group by is followed by order by. My table is resource_monitor id | server_ip | rdp_connection 1 | 192....
(3) odpowiedzi
2017-04-06 20:04 Complicated JOIN using multiple tables »
For example I have several profile tables, such as music_profile sports_profile art_profile All of these tables have matching names, and they all...
(0) odpowiedzi
2017-04-06 19:04 Mysql query, more specifically with Laravel eloquent »
I think I've hit my peak on mysql query knowledge. I can't seem to generate, what I suspect, is a complex query. Here's a little background on my setu...
(3) odpowiedzi
2017-04-06 17:04 Is it a good practice to return HTML from Php/Mysql function? »
For example have a look at the below code, It return links based on status it get from database. function favourite_store_link ($store_id, $user_id)...
(1) odpowiedzi
2017-04-06 14:04 Postgresql's json_each()/jsonb_each() equivalent in MySQL 5.7.*? »
Is there any json_each()/jsonb_each() equivalent in MySQL 5.7.*? According to the article I found: "Not supported, cannot be implemented using UDFs o...
(0) odpowiedzi
2017-04-06 10:04 Deadlock between Update and Insert queries »
I have faced a deadlock in my application between an Update and an Insert query and I am unable to understand why locks are given in a way which cause...
(1) odpowiedzi
2017-04-06 05:04 How to make a a query of similarity percentage in SQL Server? »
I have a process that before I submit the data to database I have to check whether the data is already exist in the database or not. And if its found ...
(1) odpowiedzi
2017-04-05 22:04 Mysql: Order rows by value frequency »
Let's say I have this table: +----+------+---------+ | Id | Item | Country | +----+------+---------+ | 1 | b123 | Austria | | 2 | a123 | Italy | ...
(2) odpowiedzi
2017-04-05 20:04 SQL: how to filter results beyond GROUP BY »
Original question The following relations keep track of airline flight information: Aircraft (aircraft_number, aircraft_make, cruisingrange) ...
(1) odpowiedzi