I have a table with column that contain comma separated ids like : ids ---- 1,2,3,4 1,4,5 1,5 2 2,6,9 Now I need to sort these ids based on a given string similarity (common elements). For example if the string…
I want to fetch status from database and show in listview as text but status which i store in database is number, how can i set those status as text? 0 = start 2 = pending approval 3 = Approved…
I am trying to come up with a MySQL script for averaging Price in the following data, by Price_Start_Date, but taking into consideration past prices that are still valid and taking the latest price for each Id. Better explained with…
I am making a web application using HTML, python and a MYSQL database. I currently have two tables: one that stores users and the other that stores flashcards. I want to add the feature of 'practising' flashcards by displaying a…
I have a table like this. + day + person + amount + +------+---------+--------+ + 1 + John + 4 + +------+---------+--------+ + 1 + Sam + 6 + +------+---------+--------+ + 2 + John + 3 + +------+---------+--------+ + 3…
I'm following guides in order to run a local MySQL database by using Docker, this link in particular: https://blog.christian-schou.dk/creating-and-running-a-mysql-database-with-docker-compose/ My MySQL is up since I can check state on console: Here is the code for my docker-compose.yml file in order…
Using the command line on windows. Mysqldump does not accept the "" in the path name for the --tab= option. I have tried the following: mysqldump -u root -p --tab=D:DataDump myDB mysqldump -u root -p --tab="D:DataDump" myDB mysqldump -u root…
I current use the numpy roots function as follows: y = numpy.roots([-2, 3, 0, -1 * x])[1] In the above x is a column in a table that I extract to run through the function. If possible I'd like to…
I currently have a stored procedure that accepts TEXT as input, and then tries to find the matching ids within the set. The input_ids value is an array of longs '1,2,3,...'. It works but the problem is that find_in_set is…
I have two tables joined orders (id) and order_status (id, order_id, status_id). I want to return only the orders that doesn't have a given status_id, I've tried: SELECT order_id FROM orders INNER JOIN order_status ON orders.id = order_status.order_id WHERE order_status.status_id…