what type of clause must you always use with DEKETE or UPDATE to avoid inadvertently changing data elsewhere in the database

1 answer:

5 0

While you’re using the DELETE or UPDATE to change the data in any database like MySQL or ORACLE, the WHERE clause can be used to avoid inadvertently changing data everywhere.

<u>Explanation:</u>

The WHERE clause checks the condition and the changes mentioned by the DELETE or UPDATE command will be done if the condition is true. There are also other clauses like HAVING, IN which will have range either inclusive or exclusive.

It is also noted that in MySQL, there is a method called WorkBench which enables safe mode and doesn’t execute statements without the WHERE clause.

You might be interested in

What is the best way to improve an online search

Slav-nsk [51]

Best way is to put your exact question! And do "advanced search"

Hope I helped and if you need more info or another question, then feel free to ask me!
Have a nice day!

6 0

2 years ago

Read 2 more answers

You have to display or connect to network shares on remote computers. Which command-line utility will you use to accomplish the

Xelga [282]

Answer:

net use X: \\SERVER\Share

Explanation:

1. Connect securely to the remote computer or ensure you have access to it on the network

2. then follow the step below:

Where X: is the drive letter you wish to map the share to, and \\SERVER\Share is the UNC path to the share. This should make the share visible in My Computer and the command line as well like all other shares mapped through the GUI.

In order to later disconnect the share, you would use

net use X: /delete

8 0

3 years ago

Suppose that a machine with a 5-stage pipeline uses branch prediction. 15% of the instructions for a given test program are bran

zhenek [66]

Answer:

solution attached below

Explanation:

3 0

2 years ago

Password procedures, information encryption software, and firewalls are examples of measures taken to address:

Gnoma [55]

<span>Password procedures, information encryption software, and firewalls are examples of measures taken to address are all measures taken to safeguard information security and protect users data from being tampered or manipulated by invaders.

In web, if we leave our information without encryption or if we leave our system without firewall, different types of security threats might arise: such as, information being hacked, manipulated or sent to wrong places. To avoid this information encryption is done. We might also need to firewall our system so that we can avoid unwanted access and invading of our privacy using malwares and other tools. </span>

5 0

3 years ago

Why is it important to think about the programming language to use?

Sloan [31]

In think is C or B in my opinion

6 0

2 years ago

what type of clause must you always use with DEKETE or UPDATE to avoid inadvertently changing data elsewhere in the database​

what type of clause must you always use with DEKETE or UPDATE to avoid inadvertently changing data elsewhere in the database