MySQL

I have a table like this :

I am getting users and their points, I order them by points and paginateNow I want to add a number row to result, so first placed user would have num

I have created a database that has many scripts and many sprocs, in this db we have not paid attention to worrying about case sensitivity as it was off for my local development machine

I am trying to insert paragraphs of text in mysql using knex and hapi api that will correctly output as paragraphs of text in a React app

I need to rewrite insert operation in my sql, to write another value if some condition is trueFor example:

I am working on a restaurant website using WoocommerceTrying to display the linked products in a modal

I built this stored procedureIt's supposed to select all the 'non-started' rows from a table we're using as a queue

I have a query written in mysql that is taking, what feels like, a ridiculous amount of time to completeI really need to speed this query up, it is taking in excess of 7 hours to complete

I have a MySQL table storing a binary tree in a nested set model with some extra propertiesThe binary tree is neither full nor complete

I have MySQL datetime in my table in the MySQL standard format like

I'm using this query to return all profile info of a player and also all of the times associated with that player from the EVENT_DATA tableHowever, I'm only being returned one event time per player even though each player has more than one time in the database

I've tried to find the problemBut unfortunately I can't

I recieved this warning when I execute my app:

I have a problem with this php code:

My goal is to delete/remove any rows from the ma_images table which contains a duplicate of the same piece of data in anther row, but to retain the original/first instance of that data which has been duplicatedTo put it another way, if row #1 mentions 'image_1

I am trying to get total hours and total overtime for a given period of time, for all usersI have managed to build a query that will give the desired result, but for a specific user decided by id only

I have this query that works very fast (around 02862seconds):

How to get position in order, i have make query to back me result and sorted correctly but need to get position because i will make cron and position row will be updated from time to time

I am working with Larvel 56 and I have table name as projects with following columns

I am having trouble writing a database trigger for mysqlFor simplicity sake, I will layout a fake schema and then tell you what the trigger should do:

I am working on a Spring MVC Project with Spring Data JPA running MySql DB, where I have four Entity Objects: Travel, Expense, Currency and Fund

Ive just installed MariaDB 103

friends, I create the mapping between the register and the user profile but I am getting this error Caused by commysql

I have two user named as USER1 and USER2 in mysqlI want to provide previliges to each user in such a way that they can not see and access of each-others databases but they should have full access of their own databases