I'm working on MySQL workbench and I would like to find the top-selling products by types of buyers. First I categorized customers based on their buying activity. If a person made a purchase only on 1/1, it's a first-time buyer.…
I am trying to get last row with query to MySQL WordPress, The query is How much Post-Title with the title Germany each month, How can I reverse the result? Query: SELECT COUNT( p.id ) post_count, DATE_FORMAT( post_date, '%Y-%m' )…
I'm try to get the output of How many times each location is used for clus meetings, trainings, and competitions for my database. I figured out how to do each separately but am having trouble combining them into one output…
I have a large table called uk that includes fields called CurrTime and EvName. Using the following query (extract below) I create a new field called StartTime that extracts the time from EvName (which is a MEDIUMTEXT field). I want…
I am creating a search field where user can search any data from any field from the list of displayed records. I have set the condition where the displayed records should only be the ones with the percentage of 50.…
We have a table where we want to divide the data in train, test and split. It should split like per type top 20% data in validation, next 20% data in test and remaining 60% in train. For example, we…
I've noticed that full text searches in MySQL do not seem to speed up when reducing the search pool with additional where clauses or joins. For example: SELECT * FROM `blog_posts` WHERE `id` = 1 AND MATCH (post_body) AGAINST ('+mango…
So I'm making a function to blacklist an used token when user logout and save it to my database table, When I trying to insert the data to the table it always says Unknown column 'token' in 'field list' although…
I'm trying to modify the dump file generated by MySQL (InnoDB engine) where I want to check if a table is present If it is already there then don't overwrite the data If it is not found then create a…
This question has been asked several times, i looked at the answers, but none of them helped me. So i am asking what is wrong in my case and i hope that someone will figure it out. The java version,…