QueensQueens
22.08.2019 •
Computers and Technology
Briefly describe an sql dml statement for changing existing data in a table.
Solved
Show answers
More tips
- F Food and Cooking How to Cook Spaghetti Right – Secrets and Tips...
- P Philosophy Personal attitude towards Confession: how to prepare and undergo the procedure correctly?...
- H Health and Medicine Flu: How to Recognize It by the First Symptoms?...
- F Food and Cooking How to Sober Up Quickly? Important Facts and Tips...
- H Health and Medicine How to Properly Take a Blood Sugar Test?...
- H Health and Medicine Simple and Effective: How to Get Rid of Cracked Heels...
- O Other How to Choose the Best Answer to Your Question on The Grand Question ?...
- L Leisure and Entertainment History of International Women s Day: When Did the Celebration of March 8th Begin?...
- S Style and Beauty Intimate Haircut: The Reasons, Popularity, and Risks...
- A Art and Culture When Will Eurovision 2011 Take Place?...
Answers on questions: Computers and Technology
- C Computers and Technology Which option identifies the type of engineering technician most likely to be involved in the following scenario? A technician checks that the highway cloverleaf design meets...
- C Computers and Technology boi get your facts right and you...
- C Computers and Technology Amalicious program that can replicate and spread from computer to computer?...
- C Computers and Technology You are the network administrator for westsim.com. The network consists of a single domain. All the servers run Windows Server 2016. All the clients run Windows 10. There...
- C Computers and Technology Complete the function to return the result of the conversiondef convert_distance(miles):km = miles * 1.6 # approximately 1.6 km in 1 milemy_trip_miles = 55# 2) Convert my_trip_miles...
- M Mathematics Last week, Laura volunteered at the community clean-up event and earned 2 patches for her scout uniform. She spent 4 minutes sewing the patches onto her uniform. This week,...
- E English 1. Compare Describe how the video presents the March on Washington. How does it differ from the history text s account? Cite specific examples from the video and the text....
- H History Why was the United States v. Nixon case important?...
- A Arts Uhh so anyone wanna do rp (first one to answer get to pick subject) -CC...
- A Arts Someone wanna play amount us with me??...
Ответ:
The Update statement in the DML is used for changing existing data in a table.
Explanation:
Their are following Sql statement in the DML.
Insert
This SQL statement is used for inserting data into the table.
select
This SQL statement is used for retrieving data from database
update
This SQL statement is used for updating data in a table.
delete
This SQL statement is used for delete data from database .
The "UPDATE" SQL statement in DML is used for Modify the data in the existing table .
Following are the syntax of Update SQL query
Update tablename
set column1=value1,column2=value2column N=valueN
Where condition;
Example :Suppose we have student table and (rollno,name,age and add) are the field for that table we have to change the address of rollno 105
Then we use update query like that
UPDATE STUDENT
SET add='kalam nagar'
where rollno=105;
Ответ:
Like I said, 999 don’t play