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
What I have: Azure SQL Database on private virtual network Jump host - Whitelisted Azure VM that can connect to the Azure SQL Database Local machine --PuTTY--&g
I do a simple text editor. With the javascript select option I add font-family to innline-style and change the font-family style. After that I need to ajax-save
There are 163 tables, and I want to add two columns in all. And columns should be added from the front. Please tell me how to do it on postgreSQL This is a tabl
I'm using Visual FoxPro on my Classic ASP website, and I want to achieve the SQL syntax below to FoxPro version 6. INSERT into users (id, name) VALUES (1, 'jo
I am a beginner to web development, and I am trying to do a notification system with AJAX and jQuery. In my web application, I have a comment system where you c
Imagine I have the following code: qs = Users.objects.all() list = [] for i in range(10): list.append(qs.filter(age=i)) here the filter is called 10 times
The tables should be linked mainly towards the employee table. Is this fine? I need to make connection to employee using foreign keys. Is it good practice to h