Top new questions this week:
|
|
I've following table
CREATE TABLE `books` (
`book_id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(100) DEFAULT NULL,
`author_fname` varchar(100) DEFAULT NULL,
`author_lname` varchar(100) ...
|
|
I'm using MySQL 8.0 (inside Azure Database for MySQL Server).
I've noticed some strange behavior while querying with the "json_extract" functionality. In the example below, I am querying a ...
|
|
I'm trying to migrate a database from PostgreSQL to MySQL on an Ubuntu 23.04 system (latest version of both).
So far, it looks like things are fine, except for one problem. In one of the character ...
|
|
Let says I've this query:
DECLARE @QueryString NVARCHAR(MAX) ;
SELECT @QueryString = COALESCE(@QueryString + ' UNION ALL ','')
+ 'SELECT '
+ '''' + ...
|
|
I have a question related to an incident that happened on one of our Postgres DBs.
We have a backend service that keeps track of user's activity in some kind of online event. The service uses Postgres ...
|
|
I am creating a trigger in SQL Server 2019 to secure the amount of connections users can have into my SQL server. I am having an issue getting my SYSDBAs access using the domain group. I would rather ...
|
|
We face a situation where pg_restore drops extension plpgsql and then recreates it. This is done by a CI job we have but i could not reproduce it. These are the commands we use:
pg_dump -d $...
|
Greatest hits from previous weeks:
|
|
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 ...
|
|
When I try to use \i on a file that is not in the psql.exe folder it says C:: permission denied. For example I have a file with SQL command at C:\Users\Work\Desktop\School Work\load_database.sql and ...
|
|
What is the difference (if any) between a database, a user, and a schema?
|
|
I have a table like this:
ID | Val | Kind
----------------------
1 | 1337 | 2
2 | 1337 | 1
3 | 3 | 4
4 | 3 | 4
I want to make a SELECT that will return just the ...
|
|
Is there an equivalent to MySQL SHOW DATABASES statement?
Is it possible to find databases in a cluster? i.e. databases present on the network on some other system?
Could I analyze the files present ...
|
|
Suppose I have a 'Transactions' table which has a column 'Customer ID' (Foreign Key) and a Customer Table having 'ID' (Primary key). How do I show the relation between the two tables and showing that ...
|
|
The Debug button is present on this version of SSMS:
But it is not present on version 18, preview 4:
I have tried in several ways to add the Debug button to my SSMS but not successful.
Is there a ...
|
Can you answer these questions?
|
|
Our tables are partitioned by month on the dt date column
CREATE TABLE IF NOT EXISTS ta
(
link_dir text COLLATE pg_catalog."default" NOT NULL,
dt date NOT NULL,
tod time without ...
|
|
I have been searching all day and trying every manner of solution that I come across, yet nothing has resolved this issue.
Here is my was working code:
delete RemoteTable from OPENQUERY (LIGHTSAIL, '...
|
|
I have started the first node with the bootstrap option, and it is running well and serving queries.
sudo service mysql@bootstrap start
However, when I try to add the 2nd and 3rd nodes, they both ...
|
