python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - mysql

MySQL - creating a query

I need some help, I want to create a query and is difficult for me, how can I create a query to sort table A by value and if the values are equal to check in table B by which value are higher between ...
test-img

Andrei

mysql

sql

Votes: 0

Answers: 0

PHP MySQL INNER JOIN query only returns one row when phpMyAdmin of same query returns four rows

I have two tables 'favorite' and 'image': 'favorite' - contains columns: username (varchar) unique identifier for user viewkey (varchar) unique identifier for image action (tinyint) 1 = image was fa...
test-img

Nyki-Anderson

php

mysql

sql

database

inner-join

Votes: 0

Answers: 1

Latest Answer

Answered I had previously used the variable $conditions which had a 'single' row paramater leftover. Reinitializing $conditions with $conditions = array (); cleared everything up. Thank you for the co...
test-img

Nyki-Anderson

How to get relation table data name instead of id

I have two tables Hero id name universe_id 12 Mark 1 99 Glume 1 Universe id name 1 Andromeda 2 Aurora How to return hero table data with universe name instead of universe_i...
test-img

Randall

mysql

node.js

Votes: 0

Answers: 2

Latest Answer

const sql = "SELECT h.id, h.name, u.name as universe_id FROM `hero` as h LEFT JOIN `universe` as u ON h.universe_id=u.id";
test-img

vanesicks

Kill a procedure triggered by an event automatically

There is a procedure called "daily_feed" as follows: CREATE /* DEFINER=`micro_bi`@`%` */ PROCEDURE `microservices_bi`.`DAILY_FEED`() BEGIN DROP TABLE IF EXISTS abc; CREATE TABLE abc AS SELE...
test-img

milad bahari javan

mysql

sql

amazon-web-services

mysql-5.7

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs