ä¸ãSQLä¸æ°å¢åæè 说添å å段çè¯æ³ï¼
alter table 表å add åå æ°æ®ç±»å
äºãä¾å¦:å¨è¡¨texttableä¸æ·»å ä¸åå符åå段colnewï¼
alter table texttable add colnew char(20)ä¸ãæ·»å çæ°åï¼é»è®¤å¼ä¸ºç©ºå¼NULLãéè¦æ ¹æ®éæ±ä½¿ç¨SQLè¯å¥æ´æ¹
1ãSQLä¿®æ¹åçè¯æ³ï¼
update 表å set å段 = èµå¼ whereåå¥ï¼ç¡®å®è¦ä¿®æ¹çåï¼
2ãå®ä¾ï¼
update texttable set colnew = 'temp';--æææè¡ç colnewåçå¼æ¹ä¸º "temp"