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
I am trying to connect Snowflake to Matillion ETL using key-pair authentication. I'm facing the error 'Default Database must not be empty'. We have given a defa
I frequently swap between different apps which use Docker, some of which are microservices that need to both be operational so I can't simply kill all of my con
For AWS RDS there are 2 way to create a "clone" of your DB : 1/ Read replica : Create a read replica, data is asynchronous, meaning there's a little delay 2/ Mu
I'm on Laravel project that I didn't start, my problem is when I try to do an insert on laravel. I need to insert a datetime, on Y-m-d h:i:s.v format but when i
I created a form with 3 textboxes & a search button. Also a query that is setup to take the criteria in the textboxes & filter the results of a table wi
In MySQL, I only want to add thousand separator in the number like 1234.23234, 242343.345345464, 232423.22 and format to "1,234.23234", "242,343.345345464", "23
I'm trying to create a procedure that add a value that doesn't exist but I'm currently getting a syntax error. I don't know how to correct the error. Any help w