So I have an Xampp server with phpmyadmin and I usered this command, which always worked: WITH temptable AS (SELECT *, ROW_NUMBER() OVER (ORDER BY character_ID DESC) AS t FROM characters) SELECT * FROM temptable WHERE t BETWEEN 0 AND…
I write this query ALTER TABLE com_product DROP COLUMN drug_id; and then write this query but also error ALTER TABLE com_product DROP FOREIGN KEY drug_id; but error
I've been making game replay system that saves player actions every 100ms as JSON file. Currently I'm using Java for it so I can convert json to map or text without delay. Average size of json is 8MB and maximum…
A python script I write generates IDs that I need to add to a list, while another script checks, if the ID already exists in the list. There are no other tables, relations or anything, just a huge, growing list…
My version table has 8 attributes, all are populated when inserting a Project (One to many relationship, projects - versions). Why do I get this error if I have the complete fields? Or how are values loaded to a table…
I did several tests, the view values are saved in the model, but do not pass to the database. The values entered by screen are printed perfectly by console, but at the time of being entered into the database, it…
I need help I have added filters to my code, they all are working fine but only month & year filter is creating confliction, although when I print the SQL in PHPMyAdmin I'm getting the desired results but not in…
Looking for advice on whether I can improve my database statements or if I should start caching query results to increase performance. The schema is set up as a Many-To-Many Polymorphic relationship. I have a Videos table that contains video…
I creeate an app on android ,database registers user correctly but no email is send out and app displays my error message "cant register user at the moment" don't know what i am doing wrong This is part of the…
I'm trying my level best to reduce server space by deleting the unnecessary file and I come across with this file with huge space after running this command [root$]# du -a / 2>/dev/null | sort -n -r | head -n…