• MySQL

September 24, 2018, at 12:20 PM

I have a table like this :

19
September 24, 2018, at 12:00 PM

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

13
September 24, 2018, at 00:40 AM

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

12
September 24, 2018, at 00:30 AM

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

37
September 24, 2018, at 00:10 AM

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

28
September 24, 2018, at 00:00 AM

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

31
September 23, 2018, at 11:50 PM

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

20
September 23, 2018, at 11:30 PM

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

31
September 23, 2018, at 11:20 PM

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

10
September 23, 2018, at 10:50 PM

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

40
September 23, 2018, at 10:40 PM

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

17
September 23, 2018, at 10:30 PM

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

23
September 23, 2018, at 10:20 PM

I recieved this warning when I execute my app:

35
September 23, 2018, at 10:10 PM

I have a problem with this php code:

42
September 23, 2018, at 10:00 PM

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

43
September 23, 2018, at 9:30 PM

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

29
September 23, 2018, at 9:20 PM

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

15
September 23, 2018, at 9:10 PM

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

12
September 23, 2018, at 8:50 PM

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

14
September 23, 2018, at 8:40 PM

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:

22
September 23, 2018, at 8:30 PM

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

31
September 23, 2018, at 8:20 PM

Ive just installed MariaDB 103

32
September 23, 2018, at 8:10 PM

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

20
September 23, 2018, at 8:00 PM

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

6
Show more
READ ALSO
How to use $.when in node.js? [duplicate]

How to use $.when in node.js? [duplicate]

This question already has an answer here:.

535
Add node to Tree

Add node to Tree

I decided to use nested sets model. [nnn]My table has columns: id, name, lft, rgt, parent_id.

587
javascript/jquery: on click copy relevant array items to new array

javascript/jquery: on click copy relevant array items to new array

I think I'm missing an obvious answer. I have an array of arrays, like this.

571