The format for the UPDATE command is the word UPDATE, followed by the name of the table to be updated. The next portion of the command consists of the word <u>SET</u>, followed by the name of the column to be updated, an equals sign, and the new value.
Explanation:
- An Update Query is an action query (SQL statement) that changes a set of records according to criteria you specify.
- The SQL UPDATE Query is used to modify the existing records in a table. You can use the WHERE clause with the UPDATE query to update the selected rows, otherwise all the rows would be affected.
- Update Queries let you modify the values of a field or fields in a table.
<u>UPDATE Syntax
</u>
- UPDATE table_name
- SET column1 = value1, column2 = value2, ...
- WHERE condition;
UPDATE table_name SET column1 = value1, column2 = value2, etc WHERE condition;
- table_name: name of the table
- column1: name of first , second, third column....
- value1: new value for first, second, third column....
- condition: condition to select the rows for which the
- values of columns needs to be updated.
Explanation:
1a. i know only 4 components of computer these are users, data,hardware & software
1b.users,the person who use the computer
data,it is the collection of raw facts and figures
hardware,is the physical part of the computer that can be seen and touch
software,is a set of program that instruct the computer to perform the certain action
2a,an internet is worldwide systen of interconnected computer network
2b.if some student want to now about something he can use internet and get the answer,to commenicate with others,and to learn online
Answer:
Explanation:
The following is written in Java. It continues asking the user for inputs until they enter a -1. Then it saves all the values into an array and calculates the number of values entered, the highest, and lowest, and prints all the variables to the screen. The code was tested and the output can be seen in the attached image below.
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Scanner;
class Brainly {
public static void main(String[] args) {
Scanner in = new Scanner(System.in);
int count = 0;
int highest, lowest;
ArrayList<Integer> myArr = new ArrayList<>();
while (true) {
System.out.println("Enter a number [0-10] or -1 to exit");
int num = in.nextInt();
if (num != -1) {
if ((num >= 0) && (num <= 10)) {
count+= 1;
myArr.add(num);
} else {
System.out.println("Wrong Value");
}
} else {
break;
}
}
if (myArr.size() > 3) {
highest = myArr.get(0);
lowest = myArr.get(0);
for (int x: myArr) {
if (x > highest) {
highest = x;
}
if (x < lowest) {
lowest = x;
}
}
System.out.println("Number of Elements: " + count);
System.out.println("Highest: " + highest);
System.out.println("Lowest : " + lowest);
} else {
System.out.println("Number of Elements: " + count);
System.out.println("No Highest or Lowest Elements");
}
}
}
Answer:
A. On a highway
Explanation:
On a highway is NOT a place where you are likely to encounter a pedestrian.
Pedestrians found on highways usually get arrested or get a ticket.
Answer is the son-father-grandfather concept. Good luck
