2¡¢Ìá¸ß²Ù×÷ʵÑé
ÔÚ²éѯ±à¼Æ÷ÖÐÊäÈëÒÔÏ´úÂ룬ʵÏÖÏàÓ¦µÄ¹¦ÄÜ¡£
£¨1£©½«£¨Ñ§ºÅ:2008004£»ÐÕÃû:ÀîËÄ£»ÐÔ±ð;ÄУ»ËùÔÚϵ:IS£»ÄêÁä:20£©µÄѧÉúÐÅÏ¢²åÈëµ½student±íÖУ¬ÊµÏֵĴúÂëÈçÏ£º INSERT INTO student(Sno,Sname,Ssex,Sdept,Sage) VALUES('2008004','ÀîËÄ','ÄÐ','IS',20);
£¨2£©½«student±íÖÐѧºÅΪ2008001µÄѧÉúµÄËùÔÚϵ¸ÄΪMA£¬ÊµÏÖ´úÂëÈçÏ£º UPDATE student SET Sdept='MA' WHERE Sno='2008001'
£¨3£©É¾³ýÐÕÃûΪ¡°ÕÅÁ¢¡±µÄѧÉú¼Ç¼£¬ÊµÏÖ´úÂëÈçÏ£º DELETE FROM student WHERE Sname='ÕÅÁ¢';
Îå¡¢µ÷ÊÔ¹ý³Ì
ÔÚ×ö½«student±íÖÐѧºÅΪ2008001µÄѧÉúµÄËùÔÚϵ¸ÄΪMA£¬²»Ð¡ÐĽ«¡°;¡±ÓÃÖÐÎÄÊäÈë·¨µÄ¡°£»¡±´úÌæ£¬Ôò³öÏÖÁË´íÎó£¬ÈçÏÂͼ£º