Query the name of any student in STUDENTS who scored higher than 75 marks. Order your output by the last three characters of each name. If two or more students
I'm looking for an efficient way of storing sets of objects that have occurred together during events, in such a way that I can generate aggregate stats on them
I have a pretty small database (15 tables, ~1000 rows) that is being accessed very frequently to get data. I was wondering what other options
I'm trying to create a Postgres database for the first time. I assigned basic read-only permissions to the DB role that must access the database from my PHP scr
I have just started using Pimcore and deployed its a mysql database on another server. During its installation, it couldn't connect to the database. I created t
I'm working on qt, my database was rightly connected with qt but suddenly i have the following problem every time i debug,,,i i become not able to fetch or to a
I just created a batch job using Spring Batch framework, but I don't have Database privileges to run CREATE SQL. When I try to run the batch job I hit the error
When I install the MySql Workbench, it show this message: No compatible servers were found. You'll need to cancel this wizard and install one. But I beli
After save about 80G data, mongodb just crash. journalctl -u mongod shows the error message below mongod[4948]: {"t":{"$date":"2022-03-31T10:38:44.089+00:00"},"
I have a running Django blog with sqlite3 db at my local machine. What I want is to convert sqlite3 db to mysql db change Django settings.py file to serve MySQL
I am trying to read data from a database. I imported the database in the sqlite manually and now just want the connection made in android application and want t
I am learning MySQL and tried using a LOAD DATA clause. When I used it as below: LOAD DATA INFILE "text.txt" INTO table mytable; I got the following error:
I need to import great amount of data from excel into MS SQL Server, using the Import/ Export Wizard. Then I'll continue importing more data into the same table
I've followed the JDBC tutorial at: http://docs.oracle.com/javase/tutorial/jdbc/basics/gettingstarted.html, and managed to build and create my own JDBC database
I deployed a web app on Azure App Services. When web app tries to connect to the Azure SQL Database connection failed. I downloaded the event log from Kudu, I f
I am implementing a small CRM system. and the concept of data mining to predict and find opportunities and trends are essential for such systems. One data minin
The problem Im facing while trying to connect to database for mysql. I have also given the database settings that i have used. Traceback (most recent call las
The in-built Auto-Increment in MySQL doesn't meet my requirement so I'm thinking about making a new one. Here is my requirement: Create an increment serial num
I'm wanting to use the rust implementation of LMDB but I can't seem to find whether it would always maintain a copy of whats in memory also in the disk and vice
I was trying to solve problem in Hackerrank SQL Practice section and stuck in Problem 'Weather Observation Problem 20'. To find Median, I though of the followin