Update and alter use
CBSE, JEE, NEET, CUET
Question Bank, Mock Tests, Exam Papers
NCERT Solutions, Sample Papers, Notes, Videos
Posted by Shrishti Gusain 5 years, 10 months ago
- 1 answers
Related Questions
Posted by Parth Chaudhary 1 year, 8 months ago
- 2 answers
Posted by Arifa Meharun 1 year, 3 months ago
- 0 answers
Posted by Martina Sangchoju 1 year, 8 months ago
- 2 answers
Posted by Simran Batra 1 year, 4 months ago
- 0 answers
Posted by Prapti Dubey 1 year, 5 months ago
- 0 answers
Posted by Akib Chowdhury 1 year, 5 months ago
- 1 answers
Posted by Yashika Kakkar 1 year, 5 months ago
- 1 answers
Posted by Siya Vishwakarma 1 year, 6 months ago
- 1 answers
myCBSEguide
Trusted by 1 Crore+ Students
Test Generator
Create papers online. It's FREE.
CUET Mock Tests
75,000+ questions to practice only on myCBSEguide app
Surajbhan Choudhary 5 years, 10 months ago
These are two different SQL Statements.
UPDATE command is used to update the data lying in the tables. e.g.
UPDATE students SET marks = marks + 10 WHERE subject = "Hindi";
the above statement will increase the marks column values by 10 where the subject value is Hindi.
where as ALTER command is used to change the Structure of a table. e.g. to add a new column in students table the SQL command will be -
ALTER TABLE students ADD remarks varchar(10);
the above command will add a new column with name remarks in students table.
0Thank You