SQL²åÈë´íÎó: ÁÐÃû»òËùÌṩֵµÄÊýÄ¿Óë±í¶¨Ò岻ƥÅä¡£

ʱ¼ä£º2013.06.16 ·¢²¼ÈË£ºfanglei_li

SQL²åÈë´íÎó: ÁÐÃû»òËùÌṩֵµÄÊýÄ¿Óë±í¶¨Ò岻ƥÅä¡£

Òѽâ¾öÎÊÌâ

¹È¸èfanglei_liÓû§ÔÚ2013.06.16Ìá½»Á˹ØÓÚ¡°´óÒ½ÁèÈ»SQL²åÈë´íÎó: ÁÐÃû»òËùÌṩֵµÄÊýÄ¿Óë±í¶¨Ò岻ƥÅä¡£¡±µÄÌáÎÊ£¬»¶Ó­´ó¼ÒÓ¿Ô¾·¢±í×Ô¼ºµÄ¹Ûµã¡£Ä¿Ç°¹²ÓÐ1¸ö»Ø´ð£¬×îºó¸üÐÂÓÚ2024-09-13T22:16:13¡£bookidÊéºÅint4Ö÷¼ü
booknameÊéÃûchar40
publish³ö°æÉçchar40
pubdate³ö°æÈÕÆÚdatetime8ĬÈÏÖµ£ºÏµÍ³ÈÕÆÚ
priceµ¥¼Ûdecimal¾«¶È7,СÊýλÊý2λÔ¼Êø£ºµ¥¼Û>0£»Ä¬ÈÏÖµ£º0
author±àÖøvarchar60
remarks±¸×¢text16
´´½¨Õâ¸ö±íºó£¬È»ºó×öÕâÒ»²½
IN**RTINTObookVALUES('tp00000120','Èí¼þ×Ô¶¯»¯²âÊÔ£ºÒýÈë¡¢¹ÜÀíÓëʵʩ','µç×Ó¹¤Ò**ö°æÉç');
Ϊʲô»á³öÏÖ
·þÎñÆ÷:ÏûÏ¢213£¬¼¶±ð16£¬×´Ì¬4£¬ÐÐ1
²åÈë´íÎó:ÁÐÃû»òËùÌṩֵµÄÊýÄ¿Óë±í¶¨Ò岻ƥÅä¡£
¸ßÊÖ°ïæ½â´ðÏ£Íû´ó¼ÒÄܹ»°ïÖúËý¡£

ÏêϸÎÊÌâÃèÊö¼°ÒÉÎÊ£ºbookidÊéºÅint4Ö÷¼ü
booknameÊéÃûchar40
publish³ö°æÉçchar40
pubdate³ö°æÈÕÆÚdatetime8ĬÈÏÖµ£ºÏµÍ³ÈÕÆÚ
priceµ¥¼Ûdecimal¾«¶È7,СÊýλÊý2λÔ¼Êø£ºµ¥¼Û>0£»Ä¬ÈÏÖµ£º0
author±àÖøvarchar60
remarks±¸×¢text16
´´½¨Õâ¸ö±íºó£¬È»ºó×öÕâÒ»²½
IN**RTINTObookVALUES('tp00000120','Èí¼þ×Ô¶¯»¯²âÊÔ£ºÒýÈë¡¢¹ÜÀíÓëʵʩ','µç×Ó¹¤Ò**ö°æÉç');
Ϊʲô»á³öÏÖ
·þÎñÆ÷:ÏûÏ¢213£¬¼¶±ð16£¬×´Ì¬4£¬ÐÐ1
²åÈë´íÎó:ÁÐÃû»òËùÌṩֵµÄÊýÄ¿Óë±í¶¨Ò岻ƥÅä¡£
¸ßÊÖ°ïæ½â´ðÆÚ´ýÄúµÄ´ð°¸£¬Ï£ÍûÄãÄܸÐÊܵ½,ÎÒ×îÕæ³ÏµÄлÒâ £¡

Ï£ÍûÒÔϵĻشð£¬Äܹ»°ïÖúÄã¡£

µÚ1¸ö»Ø´ð

Óû§Ãû£ºy°åÖ¸ÏÒÔÙ»µÐÐËØÐøº¬Ãæyffdt  

SQLÓï¾ä´íÎó£ºÁÐÃû»òËùÌṩֵµÄÊýÄ¿Óë±í¶¨Ò岻ƥÅä¡£ÊÇʹÓÃinsertintoÐÂÔö**ÊÇ£¬Çﻳ×ø¾Å²Îϣȷָ¶¨ÒªÐÂÔöµÄ×Ö¶ÎÊýÁ¿£¬ºÍÐÂÔöÖµµÄÊýÁ¿²»Í¬¡£

½«¼ä˾ÒøÇ×¹ÙÐÞµØÖ÷Èý¶¯Ò»¡¢IN**RTINTOÓï¾äÓÃÓÚÏò±í¸ñÖвåÈëеÄÐС£

1¡¢Óï·¨£ºIN**RTINTO±íÃû³ÆVALUES(Öµ1,Öµ2,.)

Ò²¿ÉÒÔÖ¸¶¨ËùÒª²åÈë**µÄÁУº

IN**RTINTOtable_name(ÁÐ1,ÁÐ2,)VALUES(Öµ1,Öµ2,.)

¶þ¡¢ÀýÈç±í¸ñaaaµÄ±í¸ñ½á¹¹ÈçÏÂ

1¡¢Óï¾ä£ºinsertintoaaavalues(1)£¬ÒòΪÓï¾äûÓÐÖ¸¶¨ÒªÐÂÔöµÄ×ֶΣ¬¼´13¸ö×ֶζ¼ÒªÐÂÔö**£¬¶øvaluesÖ»ÌṩÁËÒ»¸öÖµ£¬ËùÒÔϵͳ±¨´í

ÄÇôÎÒÃÇ¿ÉÒÔ£¬°ÑvaluesµÄÖµ²¹È«£¬¼´¿ÉÕýÈ·Ö´ÐÐÕâÌõSQLÓï¾ä

insertintoaaavalues(1,**ll,**l´«È´»áÏûËÕl,**ll,**ll,**ll,**ll,**ll,**ll,**ll,**ll,**ll,**ll)