I want a table like this which has scores column, and whenever basket1 or basket2 are added to table I want to update scores of the columns in basket.So say bas
Hello I'm currently trying to create a page based on a database under mysql that would update itself for a client. However what I'm trying to
I need to alter a table to modify the order of the indexes created from the composite key for the below mentioned changeset. <changeSet author="demo (generat
I am trying to run my code and I get the following error: Failure/Error: Bookmark.new(id: res[0]['id'], title: res[0]['title'], url: res[0]['url']) IndexError:
I am trying to get the total sum from columns of a specific data type(money) for multiple tables in a database. Currently I am able to get the list of columns f
So I am at the place where I lost all of my Strapi data after moving from local to remote host and deploying my Strapi through herokuapp.com I am using Strapi i
i have an issue .i am doing a project where want to update quantity of product.i am able to sending updated data to database with put request but my ui desent
I am trying to create a database from SEC filings. The filings come in .tsv files and are structured in folders by year and quarter. Ever folder contains about
I am very new to programming and working on a web project. I used node-xlsx make a button that export excel data. But I got an error "Cannot read properties of
I tried to set as only biginter but it lost its autoincrement properties. So I tried adding auto-increment as well. $table->changeColumn('id', 'biginteger',
Let's take the following example from BigQuery, but it's the same across all other databases I've seen: with tbl as ( select [1,2,3] as arr, '{"IDS": [1
So my assignment question is to "Get a list of all books withdrawn by people with the initials 'B.W.'. Show a column for the first name, last name, initials, an
A Sqlite Database was created that consists on a persons FirstName and LastName.When the code is executed, System.Data.SQLite.SQLiteException: 'SQL logic error
I have to do that:Find the students who are over 22 years old and are studying Databases. Expected result: MATCH (p:Student)-[:Study]->(s:Subject) WHERE p.ag
I have multiple tables, and some do have columns which are related but I am not certain if I have to put the foreign key relations to all columns which are rela
Setup: Progress 11.5 databases sitting on Linux (CentOS) server, with proenv available. I'm trying to connect to Progress database through proenv and sqlexp. I'
I'm new to message brokers like RabbitMQ and I have to develop an application with RabbitMQ that interfaces with MySQL, so the final task is to create a MySQL D
I have a large table a SQLite database of student exam results. Students often resit failed exams and subsequently pass them as shown with student 10001 below.
i am making a search for the website so the user can search for results from database everything is working fine but how can i hide results until the user compl
I am working with Microsoft SQL Server and want to find E_ID and E_Name where T1+T2 has the MAX value. I have two steps to reach the necessary result: Find the