Questions tagged [dml]

Data Manipulation Language

6 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
0answers
232 views

PostgreSQL DML statements

I am trying to trick an application into executing a DML statement AFTER starting a SELECT statement without using stacked queries so I cannot use the ; character anywhere in my query. I have resorted ...
0
votes
1answer
18 views

DML queries with different performance on similar servers

I am measuring the performance between two servers that serve a database via MySQL 5.6. The DB1 server is a dedicated database server and the DB2 server shares resources with other services such as ...
0
votes
2answers
74 views

Update data from one table to another in sql server

I have a log table where accidentally one date column got updated with current date for 9 Million records. Luckily I had a backup table, so now I want to populate data from backup table to current ...
0
votes
1answer
45 views

Need a better way to insert non-existent values in referenced table during insert/update in referencing one

I'm looking for the best way to insert data into MariaDB with JDBC. Please take a look at the following schema CREATE TABLE color ( id SMALLINT UNSIGNED PRIMARY KEY AUTO_INCREMENT, name VARCHAR(...
0
votes
1answer
103 views

What is dml unplanned request?

Can someone please explain me what an unplanned DML request is? According to the book I read, an unplanned request is an ad hoc query, a request for which the need was not seen in advance. Can you ...
0
votes
1answer
340 views

Why we can FLASHBACK DROP table where it is DDL command and hence autocommited?

DROP and TRUNCATE both are DDL commands and both are autocommited.Then why we can recover DROP table by using FLASHBACK(unless it is purge) and why we can not recover TRUNCATED data(don't consider ...