Category "database"

Database schema design optimized for scoring rows to sort on

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

My php code loops and doesn't explore my database [duplicate]

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

how to modify already defined composite key in liquibase

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

Rspec and SQL: Index 0 is out of range

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:

How to get sum of multiple rows in a table dynamically

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

Is there a way to backup/export & import Strapi data

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

with put request data dosent update in ui without reload page

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

Is there a way to download and import multiple .tsv files into excel or access?

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

vue: Downloading excel files using node-xlsx

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

How can I set 'id' as biginteger and autoincrement in phinx for PostgreSQL?

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',

Why does a known type produce a runtime error but an inferred type produces a null value?

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

Trying to get only cells with certain initials but giving me syntax error? SQL

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

System.Data.SQLite.SQLiteException : SQL Logic Error

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

Cannot run Cypher query

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

Do i have to put a foreign key relation to any column in a table with relation with another table? larvavel 8, Sql

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

Connect to Progress database without knowing user and password

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'

MySQL Database Manager with RabbitMQ

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

Sqlite - Return rows where some values are different

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.

how to hide results from database until the seacrh is complete in Laravel?

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

SUM UP two columns and then find the find MAX value in SQL Server

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