尊龙凯时人生就是博

mysqlÖÐdescÊÇʲô

desc ÊÇ mysql ÖÐÉó²é±í½á¹¹µÄÏÂÁî £¬Ê¹ÓÃÓï·¨£ºdesc table_name¡£ËüÊä³ö×Ö¶ÎÐÅÏ¢ £¬°üÀ¨Ãû³Æ¡¢ÀàÐÍ¡¢¿ÕÖµÔÊÐí¡¢Ë÷Òý״̬¡¢Ä¬ÈÏÖµºÍ¸½¼ÓÐÅÏ¢¡£ÀýÈ磺desc customers ·µ»Ø id£¨int £¬Ö÷¼ü £¬×Ô¶¯µÝÔö£©¡¢name£¨varchar(255) £¬ÔÊÐí¿ÕÖµ £¬ÓÐË÷Òý£©¡¢email£¨varchar(255) £¬²»ÔÊÐí¿ÕÖµ £¬Î¨Ò»Ë÷Òý£©¡¢phone£¨varchar(255) £¬ÔÊÐí¿ÕÖµ £¬ÓÐË÷Òý£©¡¢address£¨text £¬ÔÊÐí¿ÕÖµ £¬ÓÐË÷Òý£©µÈ×Ö¶ÎÐÅÏ¢¡£

ʲôÊÇ MySQL ÖÐµÄ DESC£¿

DESC ÊÇ MySQL ÖÐÓÃÓÚÏÔʾ±í½á¹¹µÄÒ»ÌõÏÂÁî¡£ËüÒԿɶÁµÄÐÎʽÁгöÁ˱íÖеÄËùÓÐ×ֶμ°ÆäÊôÐÔ¡£

ÔõÑùʹÓà DESC£¿

ҪʹÓà DESC ÏÂÁî £¬Ö»ÐèÔÚ MySQL ÌáÐÑ·ûÏÂÊäÈëÒÔÏÂÓï·¨£º

DESC table_name;

µÇ¼ºó¸´ÖÆ

ÆäÖÐ table_name ÊÇÒªÅÌÎÊÆä½á¹¹µÄ±íÃû¡£

DESC ÏÂÁîÊä³ö

DESC ÏÂÁ·µ»ØÒÔÏÂÐÅÏ¢£º

Field: ×Ö¶ÎÃû³Æ

Type: ×Ö¶ÎÊý¾ÝÀàÐÍ

Null: ָʾ¸Ã×Ö¶ÎÊÇ·ñÔÊÐí¿ÕÖµ£¨YES »ò NO£©

Key: ָʾ¸Ã×Ö¶ÎÊÇ·ñΪË÷ÒýµÄÒ»²¿·Ö£¨Ö÷¼ü¡¢Î¨Ò»Ë÷ÒýµÈ£©

Default: ×ֶεÄĬÈÏÖµ£¨ÈôÓУ©

Extra: ÓйØ×ֶεĸ½¼ÓÐÅÏ¢£¨ÀýÈç £¬×Ô¶¯µÝÔö£©

ʾÀý

ÀýÈç £¬ÒªÉó²é customers ±íµÄ½á¹¹ £¬¿ÉÒÔʹÓÃÒÔÏÂÏÂÁ

DESC customers;

µÇ¼ºó¸´ÖÆ

Êä³ö¿ÉÄÜÈçÏÂËùʾ£º

Field           Type        Null    Key     Default  Extra
---------------- -------- -------- -------- -------- --------
id              int          NO      PRI     NULL     auto_increment
name            varchar(255) NO      MUL     NULL     
email           varchar(255) NO      UNI     NULL     
phone           varchar(255) YES     MUL     NULL     
address         text         YES     MUL     NULL     

µÇ¼ºó¸´ÖÆ

ÒÔÉϾÍÊÇmysqlÖÐdescÊÇʲôµÄÏêϸÄÚÈÝ £¬¸ü¶àÇë¹Ø×¢±¾ÍøÄÚÆäËüÏà¹ØÎÄÕ£¡

ÃâÔð˵Ã÷£ºÒÔÉÏչʾÄÚÈÝȪԴÓÚÏàÖúýÌå¡¢ÆóÒµ»ú¹¹¡¢ÍøÓÑÌṩ»òÍøÂçÍøÂçÕûÀí £¬°æȨÕùÒéÓë±¾Õ¾ÎÞ¹Ø £¬ÎÄÕÂÉæ¼°¿´·¨Óë¿´·¨²»´ú±í尊龙凯时人生就是博ÂËÓÍ»úÍø¹Ù·½Ì¬¶È £¬Çë¶ÁÕß½ö×ö²Î¿¼¡£±¾ÎĽӴýתÔØ £¬×ªÔØÇë˵Ã÷À´ÓÉ¡£ÈôÄúÒÔΪ±¾ÎÄÇÖÕ¼ÁËÄúµÄ°æȨÐÅÏ¢ £¬»òÄú·¢Ã÷¸ÃÄÚÈÝÓÐÈκÎÉæ¼°ÓÐÎ¥¹«µÂ¡¢Ã°·¸Ö´·¨µÈÎ¥·¨ÐÅÏ¢ £¬ÇëÄúÁ¬Ã¦ÁªÏµ尊龙凯时人生就是博ʵʱÐÞÕý»òɾ³ý¡£

Ïà¹ØÐÂÎÅ

ÁªÏµ尊龙凯时人生就是博

18523999891

¿É΢ÐÅÔÚÏß×Éѯ

ÊÂÇéʱ¼ä£ºÖÜÒ»ÖÁÖÜÎå £¬9:30-18:30 £¬½ÚãåÈÕÐÝÏ¢

QR code
sitemap¡¢ÍøÕ¾µØͼ