No products in the cart.

Update and alter use

CBSE, JEE, NEET, CUET

Question Bank, Mock Tests, Exam Papers

NCERT Solutions, Sample Papers, Notes, Videos

Install Now

Update and alter use

Posted by Shrishti Gusain 4 years, 11 months ago

CBSE > Class 12 > Informatics Practices

1 answers

Surajbhan Choudhary 4 years, 11 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

ANSWER

Related Questions

Write a program that generates the table of a input number using for loop

Posted by Siya Vishwakarma 7 months, 2 weeks ago

CBSE > Class 12 > Informatics Practices

1 answers

Founder of python

Posted by Parth Chaudhary 9 months, 1 week ago

CBSE > Class 12 > Informatics Practices

2 answers

All data types of MySQL with example

Posted by Prapti Dubey 6 months ago

CBSE > Class 12 > Informatics Practices

0 answers

This content has been hidden. One or more users have flagged this content as inappropriate. Once content is flagged, it is hidden from users and is reviewed by myCBSEguide team against our Community Guidelines. If content is found in violation, the user posting this content will be banned for 30 days from using Homework help section. Suspended users will receive error while adding question or answer. Question comments have also been disabled. Read community guidelines at https://mycbseguide.com/community-guidelines.html

Few rules to keep homework help section safe, clean and informative.

Don't post personal information, mobile numbers and other details.
Don't use this platform for chatting, social networking and making friends. This platform is meant only for asking subject specific and study related questions.
Be nice and polite and avoid rude and abusive language. Avoid inappropriate language and attention, vulgar terms and anything sexually suggestive. Avoid harassment and bullying.
Ask specific question which are clear and concise.

Remember the goal of this website is to share knowledge and learn from each other. Ask questions and help others by answering questions.

Posted by Honey Hanisha 9 months, 3 weeks ago

CBSE > Class 12 > Informatics Practices