Find answers to your questions about Database Administrators or help others by answering their Database Administrators questions.
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 answerAt 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 answerI 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 answerWhen 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 answerI 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 answerI 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 answerI 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 answerI 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 answerProblem 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 answerHello 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 answerGet help from others!
Recent Answers
Recent Questions
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP