Database Administrators Questions, Problems & Solutions : TransWikia.com ~ Page 40

How can I create a unique and random alphanumeric string using MySQL's Default Value? (v 5.6)

I am building a MySQL database and think using implicit DEFAULTS seems very promising. I am successfully using DEFAULT CURRENT_TIMESTAMP and DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP for on insert timestamps...

Asked on 11/07/2020 by CuriousChad

1 answer

Using virtual columns to implement an exclusive arc relationship

At the risk of bringing up an often discussed question, I wanted to get some feedback on using virtual columns (specifically Oracle 12c+) to implement an exclusive arc relationship. ...

Asked on 10/31/2020 by Jim D

0 answer

Calculating percentage over sub query SQL

I have a table that records events regarding email campaigns. I want to figure out the percentage of campaigns where there was more than one event happening for the campaign....

Asked on 10/29/2020 by Patrick Kusebauch

1 answer

How to select the rows affected by an update

When performing an update query (the following is just an example; any update query could be used) such as:update t1 inner join t2 on t1.id=t2.idset t1.name="foo" where t2.name="bar";Query OK,...

Asked on 10/27/2020 by enharmonic

2 answer

Corruption in mariadb binlog

I have an installation with mariadb version 10.0.21. I need to backup the binlog file every 5 minutes to TSM, but as the binlog is being written every second, i...

Asked on 10/18/2020 by ctutte

2 answer

Should I run SQL Server services on multiple servers under different AD accounts?

I am looking at changing all of our SQL Server instances to use AD accounts for the running services. I plan to use a different AD account for each...

Asked on 10/12/2020 by Chris Di Carlo

1 answer

How to create a trigger that updates a table that may be joined to the table being queried

I am having trouble crafting a trigger. I have a database that has contacts in it, and the contacts table joins to a second table, contact_addresses. They are big tables,...

Asked on 10/10/2020 by Jonathan Hurdman

0 answer

Can i use a custom function with UpdateOne or UpdateMany in MongoDB Shell?

I wish to perform update on my database using Update command.the data structure is as following:{ "_id" : ObjectId("5d06285570de7d11606275f8"), ......

Asked on 10/03/2020 by deadManN

1 answer

"SQL command not properly ended" with trigger

Problem No matter what I do, I can not get my trigger to work. It seems to always complain about SQL command not properly ended, ignoring SQL statement and so...

Asked on 09/28/2020 by ExileVoid

1 answer

Create a Postgresql trigger that updates column with PK of other table

Hello and thanks for taking the time in advance to look at my question. This is my first try at using triggers and functions in PostgreSQL (using DBeaver) and I...

Asked on 09/25/2020 by PGerrits

0 answer

Ask a Question

Get help from others!

Database Administrators : Recent Questions and Answers (Page 40)

Ask a Question