Top new questions this week:
|
|
I am using MySQL 8 and have a Regex that needs to return a Regex group from a table column of string data. DB-Fiddle Table: CREATE TABLE `table_name`( id_column VARCHAR(300) ); INSERT INTO `…
|
|
What tools or best practices exist to demonstrate a new server instance is “as capable” as an older one? We’re moving from an EC2 hosted instance of MS SQL Server to an RDS instance, and …
|
|
I am getting an error in MariaDB when trying to create a function. It gives me the following error and I leave the script below. The script: CREATE PROCEDURE `total_hh`(fechainicio datetime, …
|
|
I have forwarded a port to Cassandra pod and trying to back up the keyspace to CSV file. It’s connecting successfully and backing up some records. However, it’s trying to connect other nodes on the …
|
|
I feel like this should be an easy problem. All I want to do is return the timestamp of the entry that was just inserted, but in the same call. All I can find in my searching is about returning the …
|
|
Problem We have an everyday process of restoring a DB from backups to kind of replicate it on another server (yes, I know it’s not the way to do that) and encountered a rather strange problem. Process …
|
|
I installed SSMS 19 Preview 4 and it doesn’t have a Debug Menu or Debugging option. I also learnt that SSMS V17 was the last version with that capability. Then I decided to try Azure Data Studio, but …
|
Greatest hits from previous weeks:
|
|
There are similar questions asked and answered in this network related to the error message given in the question, however this problem is a little different from each. I have installed oracle 12c in …
|
|
I used pg_restore to load my postgres db with a dump file. I connected to my db with my user : sudo -u arajguru psql dump select current_user; current_user ————– arajguru Now I was able …
|
|
In Postgres 9.x, for a column of type UUID, how do I specify a UUID to be generated automatically as a default value for any row insert?
|
|
Let’s say I have a Oracle database. I have a username = x, password = y, database = z. Also I know the port = a, SID = b, Hostname = c. So how do I need to connect correctly? I used many options like:…
|
|
Currently in our SQL Server 2012 database, we’re using varchar, and we’d like to change that nvarchar. I’ve generated a script to do that. My question is are there any differences in how SQL Server …
|
|
I’m new to MySQL and I would like to know: How can I create a database with charset utf-8 like I did in navicat? create mydatabase; …seems to be using some kind of default charset.
|
|
I have a column data of type json that holds JSON documents like this: { “name”: “foo”, “tags”: [“foo”, “bar”] } I would like to turn the nested tags array into a concatenated string (‘foo, …
|
Can you answer these questions?
|
|
I’m running a cluster of MySql, 1 master, 1 slave (manage by an external app) on Linux and I would like to upgrade to the latest version in the same release without downtime. 8.0.17 to 8.0.25 …
|
|
I upgraded all servers from 10.3.x to 10.4.x. mysql1 and mysql2 were upgraded successfully however, mysql3 was accidentally upgraded to a much more recent build. All mysql servers are lxc hosted. …
|
|
When trying to deliver a snapshot for the transactional replication from SQL Server database to an old Azure SQL database (the database created long before Microsoft introduced Full Text support in …
|
