I am trying to create a view and would like to display the firstName and lastName columns from a table as one column (User) in a view.
The view is using a left join. What I would like to do is join ...

I am building a database on phpMyAdmin. However, it doesn't include the latest version of MySQL:
I downloaded the latest version of MySQL from this link: MySQL Community Server 8.0.16
However, even ...

Using trigger I convert DateTime into a timestamp and then store into another table. But somehow convert date into timestamp always affected by timezone so that's why I had use convert_tz of date and ...

I have three tables, locations(Has zipcode, location name), professionals(has name) and locatin_professional. I want to select only those rows from locations table where professional_id is 4. Whats ...

Database: Relational Database - MySQL
I am making a database with multiple tables. In order to see his data from tables, User will need to log in. I only need to display those information(through web-...

I have a table with 15 million records and 15 columns.
I want to copy some of the data (2 columns) from this table to another table.
My current query:
INSERT INTO new_table (col1, col2, col3) SELECT ...

Can anyone point me to the correct documentation or additional permissions I need besides SA to do the following?
When I run it, I receive the following error:
Cannot find the object "#test" because ...

now I am trying FULL TEXT SEARCH mechanism in MS. I load txt files to table ( one file - one record). Column is type nvarchar(MAX). I tested that i can store only about 42,6kB of data in one record, ...

i have two tables one is called defaulters and users .defaulters has mypin and debt_amount and users has mypin and debtor .i want a trigger that update debtor in users table if mypin exist in users ...

While attempting to dump and restore a WordPress database in MySQL, I noticed that mysqldump seems to be changing the PRIMARY KEY on several tables to a UNIQUE KEY instead. For example, this tables:
...

I had implemented successfully SQL Server Routing List Feature many times... but I have a very special scenario where our Reporting Services Node is located in a different Domain than SQL Server Nodes....

One database design question, if one table (call it "table_1") has an alternative unique combination key "field1" and "version", is it considered denormalized data, since "field1" is repeating itself ...

I have two tables call it - table_1 and table_2
I have an After insert trigger on table_1 and in the trigger I insert on table_2 which has some fk constraints on another table_3.
When the insert on ...

I am trying to setup an alert where the application team can get the notification on their event viewer for any queries which are running longer than 2 minutes. This is what I have so far. For some ...

I'm working on a .NET library that is used with a third-party product I support. My library may be used with many different versions of the product. I don't control the schema of that product, but I ...

I'm DB newb doing a software upgrade, and my predecessor's original migration plan may not have been as well thought out as I thought...
The Plan was to use our backup, created via
pg_dump -U derp -...

I have tons of BPR in .xel file (XE) and I want to be able to view them in a graph form and dump them all in SQL Server table, is there any way to do so?
Instead of the 5 sec threshold is there any ...

This is a descriptive question regarding MySQL SQL flow architecture. I need a flow chart on the complete steps regarding MySQL SQL flow using the following components.
eg the sequence an UPDATE query ...

I want to configure emails for alerts(when backups fail) in SAP HANA Database. From Cockpit -> Configure Alerts, I've set up SMTP information and also created default recipients. Now alerts run but ...

I'm using the below database-level trigger for schema-change-auditing.
It works fine, but if I do (drop view - create view), it only stores the sql that created the view, not the one that is dropped. ...

We have a requirement of creating a query by joining more than 50+ tables and display the results. However it is taking more than 30 seconds to get the results. All data to be mandatorily retrieved. ...

I'm having some trouble getting the correct data out of a tree structure, where I only want the first nodes in a branch matching criteria to be the result of the query.
I have this table of domains:
...

I'm working on my fact table and I want to create history table for each dimension without using slowly changing dimension because my data flows are bulky and it will take too much time to finish the ...

I'm working on my classwork and had a problem with connecting to the enterprise manager. After running the DBCA the address given to me was https://10.0.2.15:5500/em, pulling it up on IE I get cannot ...

I've created a master - slave (replication) in Google Cloud SQL.
I've also created a master - slave (replication) in Amazon RDS.
I want to sync two master MysQL from Google Cloud SQL and Amazon RDS....

I got a table with multiple columns that contain DateTime namely gendate1 up to gendate8. In my stored procedure, the user will have to input a date (@date_start). Now I have to compare the inputted ...

I have a cursor. Within my loop I select a single column and assign the result to a variable. When the select returns an empty rowset, nothing is assigned to the variable. In particular, the variable ...

Is there an easy way to get the sum of all decimal values in a string column.
Example:
"ABC $3.25, DEF $2.50, HIJ2 $0.25"
"ABC1 $3.25, DEF $2.50, HIJ $0.25, KLM $4.50"
I want to add only the values ...