python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - mysql-5.6

Find overlapping date-range records with Mysql 5.6?

I have a list of events with date-range and venue id. I need to find the max count of distinct active venues at the same time. create table if not exists events ( eventstart datetime, eventend...
test-img

Tobia

mysql

date-range

mysql-5.6

Votes: 0

Answers: 0

MySQL ORDER BY performs better with a SUBQUERY than a PLAIN simple query

For some reason I don't understand this plain regular MySQL query runs SLOWER than expected. From what I understood, MySQL would first slice the queryset using WHERE then sort the subset of results. T...
test-img

enapupe

mysql

amazon-aurora

mysql-5.6

Votes: 0

Answers: 1

Latest Answer

This may allow even the first version to run faster yet: Replace KEY(streamer_id) with INDEX(streamer_id, platform_id)
test-img

Rick James

Hierarchical data handling based on ID php mysql

I have a sample MySQL table with the columns ID, NAME AND ID_PARENT. ID NAME ID_PARENT 1 NODE 1 NULL 2 NODE 2 1 3 NODE 3 2 4 NODE 4 2 5 NODE 5 1 6 NODE 6 5 7 NODE 7 6 8 NODE 8 7 ...
test-img

Jamal Abdul Nasir

mysql-5.6

Votes: 0

Answers: 0

Issue with Spring Cloud Dataflow and Mysql 5.6

I have the following problem when trying to start a SCDF server connected to Mysql 5.6. Using the following command to start a SCDF server connected to a mysql database (version 5.6): java -jar spring...
test-img

evertonschneider

spring

flyway

spring-cloud-dataflow

mysql-5.6

Votes: 0

Answers: 1

Latest Answer

Docs are pointing to schema files in GitHub Repo. You can create tables either manually or bootstrap those via server without flyway.
test-img

Janne Valkealahti

Posts

Questions

Blogs

Jobs