sqlÖÐfromÓÃÀ´ÊµÏÖʲôÔËËã
ÔÚ sql ÖУ¬from ÔËËã·ûÓÃÓÚÖ¸¶¨Ãü¾ÝÔ´£¬Ò²¾ÍÊÇÒª´ÓÖмìË÷Êý¾ÝµÄ±í»òÊÓͼ¡£ËüÊÇÒ»¸ö±ØÐè×Ӿ䣬ºóÃæ½ô¸ú±í»òÊÓͼµÄÃû³Æ£¬¿ÉʹÓÃÓÖÃû¾ÙÐÐÒýÓá£where ×Ó¾äÔòÓÃÓÚ½øÒ»²½¹ýÂËÊý¾Ý£¬½ö¼ìË÷Öª×ãÌض¨Ìõ¼þµÄÐС£from ÔËËã·û¹ØÓÚ sql ÅÌÎÊÖÁ¹ØÖ÷Òª£¬ÓÉÓÚËü½ç˵ÁËÊý¾Ý¼¯¡¢ÔÊÐíÅþÁ¬Êý¾ÝÒÔ¼°Ìṩ¹ýÂËÊý¾ÝµÄ¿ÉÄÜÐÔ¡£
SQL ÖÐ FROM ÔËËã·û
ÔÚ SQL ÖУ¬FROM ÔËËã·ûÓÃÓÚÖ¸¶¨Òª´ÓÆä¼ìË÷Êý¾ÝµÄ±í»òÊÓͼ¡£ËüÊÇÒ»¸ö±ØÐèµÄ×Ӿ䣬ÓÃÓÚ½ç˵Êý¾ÝÔ´£¬²¢Óɴ˽¨ÉèЧ¹û¼¯¡£
Ó÷¨£º
SELECT column_list FROM table_name [AS alias_name] [WHERE condition];
µÇ¼ºó¸´ÖÆ
ÔõÑùʹÓà FROM ÔËËã·û£¿
Ö¸¶¨Ãü¾ÝÔ´£ºFROM ºóÃæ½ô¸úÒª´ÓÖмìË÷Êý¾ÝµÄ±í»òÊÓͼµÄÃû³Æ¡£
ʹÓÃÓÖÃû£¨¿ÉÑ¡£©£º¿ÉÒÔʹÓà AS Òªº¦×ÖΪ±í»òÊÓͼָ¶¨Ò»¸öÌåÃû£¬ÒÔ±ãÔÚÅÌÎÊÖиüÇáËɵØÒýÓÃËü¡£
WHERE ×Ӿ䣨¿ÉÑ¡£©£ºWHERE ×Ó¾äÓÃÓÚ½øÒ»²½¹ýÂËÊý¾Ý£¬½ö¼ìË÷Öª×ãÌض¨Ìõ¼þµÄÐС£
ʾÀý£º
SELECT name, age FROM customers WHERE age > 30;
µÇ¼ºó¸´ÖÆ
´ËÅÌÎÊ´ÓÃûΪ “customers” µÄ±íÖмìË÷ËùÓÐÄêËê´óÓÚ 30 µÄ¿Í»§µÄÐÕÃûºÍÄêËê¡£
FROM ÔËËã·ûµÄÖ÷ÒªÐÔ£º
FROM ÔËËã·û¹ØÓÚ SQL ÅÌÎÊÖÁ¹ØÖ÷Òª£¬ÓÉÓÚËü£º
½ç˵ÁËÒª´¦ÀíµÄÊý¾Ý¼¯¡£
ÔÊÐí´Ó¶à¸ö±í»òÊÓͼÖÐÅþÁ¬ºÍ×éºÏÊý¾Ý¡£
Äܹ»Í¨¹ý WHERE ×Ó¾ä¹ýÂËÊý¾Ý¡£
ÒÔÉϾÍÊÇsqlÖÐfromÓÃÀ´ÊµÏÖʲôÔËËãµÄÏêϸÄÚÈÝ£¬¸ü¶àÇë¹Ø×¢±¾ÍøÄÚÆäËüÏà¹ØÎÄÕ£¡