Top new questions this week:
|
MySql Json Replace An array Value at Specific index if the value matches some condition Example: { “deploy”: [ “Infrastructure”, “API Security” ], “…
|
I have a Postgres 14 database and want to implement the following scenario: I recently added a column, is_hidden to the table foo. I have a couple of queries (around 15 read operations) in my …
|
I am using DBCC CLONEDATABASE to create database copies without data. There are a number of databases that will not clone. The error message is: Cannot insert duplicate key row in object ‘sys….
|
Is there a way to identify what type/name of resource that is being waited on?
|
I have a query which is designed to loop and search addresses for duplicates, the query uses REGEX_REPLACE. Am trying to index on the regex as on doing an explain and its doing a sequential scan on …
|
First time posting here, I need to create a table in MariaBD which will to the following: Add dates for the next 10 years for Mon – Sat with 30 minute time slots between 9am and 9pm Does anyone have …
|
There is a difference in behavior between these two variants to create a view with a null number column and a table while there is no visible difference in the data dictionary (tested in Oracle 19 but …
|
Greatest hits from previous weeks:
|
I am trying to restore a .BAK in SQL server but get the following error: Msg 3241, Level 16, State 7, Line 1 The media family on device ‘c:\glyn\JA.bak’ is incorrectly formed. SQL Server cannot …
|
I’m sure this has been asked before but I can’t seem to find the relevant details for the following. Is there some sort of pre-built table that can do the following (I have used dba_tab_privs but it …
|
I installed PostgreSQL because I need to restore a large .backup file I received for upload to another platform (it’s 38 million rows which was apparently too large for the person to export any other …
|
I can’t connect using TCP/IP over SSH connection in MySQL Workbench from a PC. What’s going on? I created a MySQL 5.1 database on an Ubuntu server mysql.myhost.com. I can access it locally. MySQL …
|
I am running Ubuntu 16. I have installed Postgresql. Postgresql used to work, but then I rebooted. nmap commands show port 5432 is open. Postgres seems to be working correctly: service …
|
I have moved my database from an SQL 2005 to a server with SQL 2008. I am now trying to create an ODBC Data Source. I am using “With SQL Server authentication using a login ID and password …
|
Here are two tables. SCHOOL_STAFF SCHOOL_CODE + STAFF_TYPE_NAME + LAST_UPDATE_DATE_TIME + PERSON_ID ================================================================= ABE Principal …
|
Can you answer these questions?
|
I ran the following commands from the cli in MacOS Monterey V 12.4: brew update brew upgrade Upon doing so, MySQL was upgraded from 8.0.30 to 8.0.31. MySQL was running in the background during the …
|
I have table in SQL public.employee name age abc 20 xyz 30 I want a query which would return the column values along with schema name and table name Input : select * from public.employee Output …
|
I have a pretty straightforward sql query that I’m running on DB2 I-series 4 which is just performing some simple joins. The issue is that my materials table has it so that multiple material/color …
|