mysqlÖÐcolumnº¯ÊýÊÇʲôÒâ˼
mysql ÖÐµÄ column() º¯Êý·µ»ØÖ¸¶¨±íÖÐÖ¸¶¨ÁеÄÃû³Æ£¬ÓÃÓÚ¶¯Ì¬ÌìÉúÅÌÎÊ×Ö·û´®»ò´¦ÀíÔªÊý¾Ý¡£
ʲôÊÇ MySQL ÖÐµÄ COLUMN º¯Êý£¿
COLUMN() º¯ÊýÊÇÒ»¸öϵͳº¯Êý£¬ÓÃÓÚ·µ»ØÖ¸¶¨±íÖÐÖ¸¶¨ÁеÄÃû³Æ¡£
º¯ÊýÓï·¨£º
COLUMN(column_name)
µÇ¼ºó¸´ÖÆ
ÆäÖУº
column_name ÊÇÒª·µ»ØÆäÃû³ÆµÄÁÐÃû³Æ¡£
Ó÷¨£º
COLUMN() º¯Êý×î³£ÓÃÓÚ¶¯Ì¬ÌìÉú SQL ÅÌÎÊ×Ö·û´®»ò´¦ÀíÔªÊý¾Ý¡£¾ÙÀýÀ´Ëµ£º
SELECT COLUMN() FROM table_name;
µÇ¼ºó¸´ÖÆ
ÒÔÉÏÅÌÎʽ«·µ»Ø±í table_name ÖÐËùÓÐÁеÄÃû³Æ¡£
ALTER TABLE table_name CHANGE COLUMN OLD_NAME NEW_NAME INT;
µÇ¼ºó¸´ÖÆ
ÒÔÉÏÅÌÎÊʹÓà COLUMN() º¯ÊýÀ´¸ü¸Ä±í table_name ÖÐÁÐ OLD_NAME µÄÃû³ÆΪ NEW_NAME¡£
×¢ÖØ£º
COLUMN() º¯Êý·µ»ØµÄÃû³Æ¶Ô¾ÞϸдÃô¸Ð¡£
COLUMN() º¯ÊýÖ»ÄÜÓÃÓÚµ¥¸öÁС£
ÒÔÉϾÍÊÇmysqlÖÐcolumnº¯ÊýÊÇʲôÒâ˼µÄÏêϸÄÚÈÝ£¬¸ü¶àÇë¹Ø×¢±¾ÍøÄÚÆäËüÏà¹ØÎÄÕ£¡
ÃâÔð˵Ã÷£ºÒÔÉÏչʾÄÚÈÝȪԴÓÚÏàÖúýÌå¡¢ÆóÒµ»ú¹¹¡¢ÍøÓÑÌṩ»òÍøÂçÍøÂçÕûÀí£¬°æȨÕùÒéÓë±¾Õ¾Î޹أ¬ÎÄÕÂÉæ¼°¿´·¨Óë¿´·¨²»´ú±í尊龙凯时人生就是博ÂËÓÍ»úÍø¹Ù·½Ì¬¶È£¬Çë¶ÁÕß½ö×ö²Î¿¼¡£±¾ÎĽӴýתÔØ£¬×ªÔØÇë˵Ã÷À´ÓÉ¡£ÈôÄúÒÔΪ±¾ÎÄÇÖÕ¼ÁËÄúµÄ°æȨÐÅÏ¢£¬»òÄú·¢Ã÷¸ÃÄÚÈÝÓÐÈκÎÉæ¼°ÓÐÎ¥¹«µÂ¡¢Ã°·¸Ö´·¨µÈÎ¥·¨ÐÅÏ¢£¬ÇëÄúÁ¬Ã¦ÁªÏµ尊龙凯时人生就是博ʵʱÐÞÕý»òɾ³ý¡£