I am using Laravel 8 and I want to display list of event by joining tables that have many to many relationship. Here is how my tables look: Users Table | id |
I used this code to store attachment xlsx files from a specific address email in Outlook, but now I would like to store these files in a database in SQL Server,
I'm trying to recover a broken sqlite database using the recover feature of sqlite3.exe: sqlite3.exe borken.db ".recover" | sqlite3 fixed.db The broken databas
I try to convert the CSV file into JSON format and import it into Deta Base (database). Here is a main.py code I run from a terminal. No error shows up, but Det
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'