MCQs Test!! VB Basic Test !! Essentials of VB !! Creating User Services !! function !! Anatomy !! GK March-2019 !! DATA TYPES IN JAVA !! Classes ,Constructor ,Methods,Inheritance !! Ecology-I !! Biology 2019 !! Gk april 2019 !! Biology (living world) !! Plant anatomy !! CELL STRUCTURES AND FUNCTION !! General biology !! Human physiology !! Data structure !! Ecology-II !! GK TEST !! Reproduction in plants !! Human reproduction !! The ABC of C !! Operating system set1 !! Operating system set2 !! Gk and current affairs !! Animal kingdom !! Number system !! Animal kingdom-II !! Gk TEST-III !! Number series !! Microorganisms !! Interview question in c !! Time and Work !! Percentage !! General history !! Average !! Cells !! Locomotion and Movement !! paging !! Bacteriology !! Page replacement policy !! Secondary memory and Disk scheduling !! Introduction of Nervous System and neurons !! Plant harmones !! Transport and Mineral Nutrition in Plants !! Neurotransmitters !! Modern Indian History !! Photosynthesis in Plants !! Modern Indian History-II !! Plant respiration !! Environment & Biodiversity !! Environment & Biodiversity - II !! Algae, Bryophytes, Pteridophytes !! Area !! Cricket !! Days of the Year (India and the World) !! Plant Pathology - I !! Indian Transport System !! Plant Pathology - II !! Aptitude !! Biology !! Botany !! C language !! Computer Science !! Core Java !! Gate !! GK !! Mysql !! Operating system !! Physics !! VB-Visual Basic !! Zoology

MySQL

Update in MySQL
Previous Home Next

The update command is use to modify the stored data or existing records in the table. the are some clause which use in this command like:

  1. The update can be done in one or more field.
  2. In this we can also use the WHERE condition.

Note: The updation can be done single table at a time.

Syntax

UPDATE tablename  
SET field1 = new-value1, field2=new-value2	
[WHERE Clause]

 

Previous view of table is shown below

Example

UPDATE studinfo 				//Update command
SET mname='SINGH' 				//insert value
WHERE sid=103;					//Where conditions

Update one or more values in a same table

Example

UPDATE STUDINFO					//update command
SET mname=NULL ,mname='SINGH'			//More than one condition
WHERE SID=108 and 105;				//where condition
Previous Home Next