I'm trying to create a web app in which users can participate in some groups (every user can be part of multiple groups), and I want to be able to make both que
I opened PopSQL and the there is a red dot at my connection. If I go into it and test it, it tells me Unknown database 'giraffe'. I opened mySQL and typed 'show
I am similar problem to this Initializing an array agent attribute from a database but Im having a problem as it brings back the whole row of data and not only
i'm trying to build a question-solving module, so i want to randomly print the "correct answer" data i got from the database, i use a void to get the data, i wa
I have this table of students public void onCreate(SQLiteDatabase db) { String createTableStatement= "CREATE TABLE " + STUDENT_TABLES + " (" + ID_COL + "
I need to improve the performance of my insert in my C# application. I first go out and get data from a view. Then I go through a FOREACH loop to insert into a
I created a JSON server and this is the data that I'm using. However, when I'm trying to query the examlist and relate it to the students (i'd like to receive t
I need to have a button (by ngIf) when a field in Db has certain value, Any Idea? Do I need store procedure and.. Thanks
What is the naming ruleset for collections that should be followed, or in other words what are the inacceptable characters for a collection name? (for example,
I have a page called createEmployee.js which includes 2 functions (fetchData and createNewEmployee) ... see below: const fetchData = async() => { c
I want to set and get image from local storage, but I have no idea how to do this.
I am trying to store data about pupils at a school. I've done a few tables before, such as one for passwords and Teachers which I will later bring together in o
Suppose in the ER diagram there is an associative entity named makes call which connects the entities External entity and Internal entity. Is it possible for th
Getting this error when using Get Data with PowerBI Desktop to connect to SQL database Microsoft SQL: The ORDER BY clause is invalid in views, inline functions,
I have a project where we need to create a application for capture infomation from a 'tournament', for example a soccer knock out tournament where you have to
I want a free database having all arabic names in english spelling (like : Ahmed, Oussama ,Fatima.... ) I've looked in internet but i did found this : https://w
I made this database, but I dont understand why the id part doesnt work. As an response I get this: [(None, 'Wilhelm der Erste', 1027, '09.09.1087', '1066-1087'
1.select * from transactions where from_account_id = 51118 order by block_number, index desc limit 20; Limit (cost=295.39..4973.89 rows=20 width=605) ->
we are currently in the process of migrating latin1 databases to UTF8 in a MySQL Server. We are investigating what is the best approach and hopefully without an
Given an SQL database with index for (startpage, endpage), with a relation Articles(*ID*, title, startpage, endpage), why isn't a query SELECT title FROM Artic