ºë³qMySQL 8¡]µøÀW±Ð¾Çª©¡^ ( ²Åé ¦r) |
§@ªÌ¡G¼BµØs | Ãþ§O¡G1. -> ¸ê®Æ®w -> MySQL |
ĶªÌ¡G |
¥Xª©ªÀ¡G²MµØ¤j¾Ç¥Xª©ªÀ | 3dWoo®Ñ¸¹¡G 51238 ¸ß°Ý®ÑÄy½Ð»¡¥X¦¹®Ñ¸¹¡I¡i¯Ê®Ñ¡j NT°â»ù¡G 395 ¤¸ |
¥Xª©¤é¡G6/1/2019 |
¶¼Æ¡G375 |
¥úºÐ¼Æ¡G0 |
|
¯¸ªø±ÀÂË¡G |
¦L¨ê¡G¶Â¥Õ¦L¨ê | »y¨t¡G ( ²Åé ª© ) |
|
¥[¤JÁʪ«¨® ¢x¥[¨ì§Úªº³Ì·R (½Ð¥ýµn¤J·|û) |
ISBN¡G9787302528746 |
§@ªÌ§Ç¡@|¡@ĶªÌ§Ç¡@|¡@«e¨¥¡@|¡@¤º®e²¤¶¡@|¡@¥Ø¿ý¡@|¡@§Ç |
(²Åé®Ñ¤W©Òz¤§¤U¸ü³sµ²¯Ó®É¶O¥\, ®¤¤£¾A¥Î¦b¥xÆW, YŪªÌ»Ýn½Ð¦Û¦æ¹Á¸Õ, ®¤¤£«OÃÒ) |
§@ªÌ§Ç¡G |
ĶªÌ§Ç¡G |
«e¨¥¡GMySQL§@¬°¤@ÓÆF¬¡»´«Kªº¼Æ¾Ú®wºÞ²z¨t²Î¡A¶V¨Ó¶V¨ü¶}µo¤Hûªº«C·ý¡C¥Ñ¤_¥¦¬O¶}·½³n¥ó¡AºûÅ@¦¨¥»¬Û¹ï¸û§C¡A¶V¨Ó¶V¦hªº¥ø·~¶}©l¿ï¾ÜMySQL§@¬°¼Æ¾Ú¦sÀx³n¥ó¡C¤£½×§@¬°¶}µo¤HûÁÙ¬O¼Æ¾Ú®wºûÅ@¤Hû¡B¶µ¥Øt³d¤H¡A¤F¸ÑMySQLªº¨Ï¥Î¤èªk©M¥\¯à¯SÂI³£±N¦³¯q¤_¤u§@¶}®i¡C¯S§O¬O»Ýn²`¤J¬ã¨sMySQLªº¶}µo¤Hû©MºûÅ@¤Hû¡A¥þ±¾Ç²ß¹B¥ÎMySQLÀ³§@¬°¥²³Æ§Þ¯à¡C MySQL 8ªº¥X²{¬O¤@Ó·sªº¨½µ{¸O¡A¥¦±a¨Ó¤F¤@¨Ç«e©Ò¥¼¦³ªº¯SÂI©M¥\¯à¡A¨ÏMySQL§óÁͤ_¤H©Ê¤Æ¡B§ó«K§Q¡C¥Ø«e¥«±¤WÂA¦³MySQL 8ªº¤Jªù®ÑÄy¡A¥»®Ñ¥HMySQL 8ªº«eªu§Þ³N¬°«e´£¡A³q¹L200¦hÓ¹ê¨Òºt¥Ü¼Æ¾Ú®wªº³]p»P¹ê²{¡A¨ÏŪªÌ¥þ±¡B²`¤J¡B³z¹ý¦a²z¸ÑMySQLªº¥\¯à¯SÂI©M¨Ï¥Î¤èªk¡A´£°ªMySQL²z¸Ñ©M¹B¥Î¯à¤O¡C ¥»®Ñ¯S¦â 1. ªþ±a¦h´CÅé»yµ±Ð¾ÇµøÀW¡A´£°ª¾Ç²ß®Ä²v ¬°¤F«K¤_ŪªÌ²z¸Ñ¥»®Ñ¤º®e¡A´£°ª¾Ç²ß®Ä²v¡A±Mªù¬°¨C¤@³¹¤º®e³£¿ý¨î¤F¤j¶qªº¦h´CÅé»yµ±Ð¾ÇµøÀW¡C³o¨ÇµøÀW©M¥»®Ñ¯A¤Îªº·½¥N½X¤@°_¦¬¿ý¤_ºô½L¤¤¡C 2. ¥þ±²[»\MySQL§Þ³N ¥»®Ñ²[»\MySQL±`¥Î¼Æ¾Ú®w¾Þ§@¡B¯Á¤Þ¡Bµø¹Ï¡B¦sÀx¹Lµ{©M¨ç¼Æ¡BIJµo¾¹¡B¨Æ°È©MÂê¡B¦w¥þºÞ²z¡B³Æ¥÷¡B«ì´_©M´_¨î¡BMySQLªA°ÈºÞ²z¡B¤é§ÓºÞ²z¡B¼Æ¾Ú¦r¨å¡BInnoDB¤ÎNoSQL¡C 3. åªRMySQL 8·s¯S©Ê ¥»®Ñ°£¤F²[»\¥H©¹ªºMySQL§Þ³N¤§¥~¡A¦b¯A¤ÎMySQL 8·s¯S©Êªº³¹¸`³£°µ¤F¸Ô²ÓÁ¿¸Ñ¡A¥]¬AMySQL 8ªº¦w¸Ë¡B¤É¯Å¡B¼Æ¾Ú¦r¨å·s¯S©Ê¡BInnoDB·s¯S©Ê©MNoSQL·s¯S©Ê¡C 4. ª¾ÃÑÂI¥þ±¡A´`§Çº¥¶i ¥»®Ñª¾ÃÑÂI±q©ö¨ìÃø³v¨B¶i¶¥¡A«ä¸ô²M´·¡A±ø²z²M·¡¡A¥]§t¤F¦hÓ¾Þ§@¨t²Î¤Uªº¾Þ§@¡CŪªÌ¿í´`¥»®Ñ¤@¨B¨B¾Ç²ß¡A³Ì²×±N·|¦¬Àò»á¦h¡C 5. ¶µ¥Ø®×¨Ò¨å«¬¡A¶K¦X¹ê»Ú ¥»®Ñ³Ì¦Z´£¨ÑJava¾Þ§@¼Æ¾Ú®wªº¤èªk¥H¤Î¨âӼƾڮw³]p®×¨Ò¡]ºô¤W½Ò°ó¼Æ¾Ú®w©M½×¾Â¼Æ¾Ú®w¡^¡C¦b³]p»P¹ê²{ªº¹Lµ{¤¤¡Aºt¥Ü¤F¹ê»Ú¨Ï¥Î¼Æ¾Ú®w®Éªº¾Þ§@¡A¦}³]p¤F¯Á¤Þ¡Bµø¹Ï©MIJµo¾¹¡A¬Û«HŪªÌ²`¤J¾Ç²ß¦Z¡A¹ï¼Æ¾Ú®wªº¹B¥Î¯à¤O·|±o¨ì«Ü¤j´£¤É¡C ¥»®Ñª¾ÃÑÅé¨t ²Ä1³¹ MySQL 8ªº¦w¸Ë¡B¤É¯Å©M·s¯S©Ê ¥»³¹¤¶²ÐMySQL 8¦b¦h¾Þ§@¨t²Î¤Uªº¦w¸Ë©M¤É¯Å¡A²n´£¤ÎMySQL 8ªº·s¯S©Ê¡A§ó¸Ô²Óªº¤º®e¦b¦ZÄò³¹¸`¡C ²Ä2¡ã5³¹ ¼Æ¾Ú®w¾Þ§@ ²Ä2~5³¹Á¿¸Ñ¤F¦p¦ó¾Þ§@¼Æ¾Ú®w¡A¥]¬A¼Æ¾Úªº¬d¸ß¡Bקï©M§R°£¡C¨ä¤¤¡A²Ä2³¹ÁÙ·|¤¶²ÐMySQLªº¦sÀx¤ÞÀº¡A²Ä3³¹·|¤¶²Ð¼Æ¾ÚÃþ«¬¤ÎMySQL 8¦b¦r²Å¶°©M±Æ§Ç³W«h¤è±ªº·s¯S©Ê¡C ²Ä6³¹ ¯Á¤Þ ¥»³¹¤¶²Ð¯Á¤Þªº§t¸q©M¤ÀÃþ¡A¦p¦ó³]p©M³Ð«Ø¯Á¤Þ¡A¥H¤ÎMySQL 8¤¤¯Á¤Þªº·s¯S©Ê¡C ²Ä7³¹ µø¹Ï ¥»³¹¤¶²Ðµø¹Ïªº§t¸q¡A¥H¤Î¦p¦ó³Ð«Ø¡B¬d¬Ý¡B§ó·s©M§R°£µø¹Ï¡C ²Ä8¡ã9³¹ ¦sÀx¹Lµ{¡B¨ç¼Æ¡BIJµo¾¹ ²Ä8~9³¹¤¶²Ð¦sÀx¹Lµ{¡B¨ç¼Æ©MIJµo¾¹ªº©w¸q¡B³Ð«Ø©M§R°£¡C ²Ä10³¹ ¨Æ°È©MÂê ¥»³¹¤¶²Ð¨Æ°È·§z¡B¨Æ°Èªº¹jÂ÷¯Å§O¥H¤ÎInnoDBªºÂê¾÷¨î¡C ²Ä11³¹ ¦w¥þºÞ²z ¥»³¹¤¶²ÐMySQLªºÅvªí¡B½ã¤áºÞ²z¡B³X°Ý±±¨î¡A¥]¬A¨¤¦â¡B²Õ¥ó©M´¡¥ó¡BFIPS¡C ²Ä12³¹ ¼Æ¾Ú³Æ¥÷¡B«ì´_»P´_¨î ¥»³¹¤¶²Ð¼Æ¾Ú³Æ¥÷©M«ì´_ªº¦hºØ¤èªk¡A¦p¦ó¾E²¾¼Æ¾Ú¡B¾É¤J¾É¥Xªí¡A¦p¦ó¶i¦æ¼Æ¾Ú´_¨î©M²Õ´_¨î¡C ²Ä13³¹ MySQLªA°ÈºÞ²z ¥»³¹¤¶²ÐMySQLªA°È¡A¥]¬AMySQLªA°Èªº°t¸m¡B¼Æ¾Ú¥Ø¿ý¡BMySQL¨t²Î¼Æ¾Ú®w¡BªA°È²Õ¥ó©M´¡¥ó¡BªA°È¤é§Ó¡C ²Ä14³¹ ¤é§ÓºÞ²z ¥»³¹¤¶²ÐMySQL¤é§Óªº©w¸q©M¤ÀÃþ¥H¤Î¦UºØ¤é§Óªº¾Þ§@¤èªk¡A¥]¬A¤G¶i¨î¤é§Ó¡B¿ù»~¤é§Ó¡B³q¥Î¬d¸ß¤é§Ó©MºC¬d¸ß¤é§Ó¡A¦P®É¹ïMySQL 8·s¼Wªº¤¤Ä~¤é§Ó©M¼Æ¾Ú©w¸q»y¥y¤é§Ó¶i¦æ¤¶²Ð¡C ²Ä15³¹ MySQL 8·s¯S©Ê¡G¼Æ¾Ú¦r¨å ¥»³¹¤¶²ÐMySQL 8¼Æ¾Ú¦r¨åªº·s¯S©Ê¡A¥]¬A¼Æ¾Ú¦r¨åªº¼Ò¦¡¡B¦sÀx¤è¦¡¡B¥Îªk®t²§©M¨î¡C ²Ä16³¹ MySQL 8·s¯S©Ê¡GInnoDB ¥»³¹¤¶²ÐMySQL 8¤¤InnoDBªº·s¯S©Ê¡AÁ¿¸ÑInnoDBªº¬[ºc¡BÀu¶Õ¡BªíªÅ¶¡¡Bªí©M¯Á¤Þ¡B³Æ¥÷©M«ì´_¡BInnoDB»PMySQL´_¨î¥H¤Îmemecached´¡¥ó¡C ²Ä17³¹ MySQL 8·s¯S©Ê¡GNoSQL ¥»³¹¤¶²Ð¦p¦ó±NMySQL³]¸m¬°NoSQL¦sÀx¥H¤Î¦p¦ó¦w¸Ë¦}¨Ï¥ÎMySQL Shell©MX´¡¥ó¡C ²Ä18³¹ Java³s±µMySQL ¥»³¹¤¶²Ð¦UÓ¾Þ§@¨t²Î¤UJDBCªº¥[¸ü¡B¨Ï¥ÎStatement¡BPreparedStatement±µ¤f¾Þ§@SQL¤Î¨Ï¥ÎJava¶i¦æ¼Æ¾Ú®w³Æ¥÷»P«ì´_¡C ²Ä19¡ã20³¹ ¼Æ¾Ú®w³]p¹ê¨Ò ³o¨â³¹ºt¥Ü¤F¨âӨ㦳¥Nªí©ÊªººÞ²z¨t²Îªº¼Æ¾Ú®w³]p»P¹ê²{¡Gºô¤W½Ò°ó¨t²Î©M½×¾Â¨t²Î¡A¨ä¤¤¥]¬A»Ý¨Dªº¤ÀªR¡Bªí©M¦r¬qªº³]p¡Bªí»Pªí¤§¶¡ªºÃö¨t¡AÁÙ¥]¬A¯Á¤Þ¡Bµø¹Ï©MIJµo¾¹ªº³]p»P¹ê²{¡C ¥N½X¡B±Ð¾ÇµøÀW¤U¸ü ¥»®Ñ°t®M¥N½X¤U¸ü¦a§}½Ð±½´y¥k°¼¤Gºû½XÀò¨ú¡C¦pªG¤U¸ü¦³°ÝÃD¡A¶l¥ó¥DÃD¬°¡§ºë³qMySQL 8¡¨¡C ¥»®ÑŪªÌ»P§@ªÌ ? »ÝnMySQL§@¬°¦sÀxªº¦UÓ»y¨¥ªº¶}µo¤Hû¡F ? MySQL¼Æ¾Ú®wºÞ²zû¡F ? ³n¥ó¶}µo¶µ¥Ø¸g²z¡C ¥»®Ñ¥Ñ¼BµØs³Ð§@¡C¦pªGŪªÌ¹ï¥»®Ñ¦³ºÃ°Ý©M«Øij¡C
µÛ ªÌ 2019¦~4¤ë |
¤º®e²¤¶¡G¥»®Ñ¥HMySQL 8ª©¥»¬°°ò¦¡A³q¹L¥þ±ªº°ò¦ª¾ÃÑ´`§Çº¥¶i¡A°ò¥»Âл\¼Æ¾Ú®w¨Ï¥Î§Þ³N©M³õ´º¡Aµ²¦X·í¤U¬y¦æªºJava¶}µo¡A°t®M¹ê¨Òºt¥ÜMySQLªº¾ãÅé¨Ï¥Î¡A´£¨Ñ¥þµ{¦h´CÅé»yµ±Ð¾ÇµøÀW¥H¤Î©Ò¯A¤ÎªºSQL·½½X¡C ¥»®Ñ¦@20³¹¡A²[»\ªº¥Dn¤º®e¦³¡GMySQL 8ªº¦w¸Ë¡A¤É¯Å©M·s¯S©Ê¡A¼Æ¾Ú®w¾Þ§@¡A¼Æ¾Úªí¾Þ§@¡A¼Æ¾Ú¾Þ§@¡A¼Æ¾Ú¬d¸ß¡A¯Á¤Þ¡Aµø¹Ï¡A¦sÀx¹Lµ{©M¨ç¼Æ¡AIJµo¾¹¡A¨Æ°È©MÂê¡A¦w¥þºÞ²z¡A¼Æ¾Ú®w³Æ¥÷¡A«ì´_»P´_¨î¡AMySQLªA°ÈºÞ²z¡A¤é§ÓºÞ²z¡AMySQL 8¼Æ¾Ú¦r¨å·s¯S©Ê¡AMySQL 8 InnoDB·s¯S©Ê¡AMySQL 8 NoSQL·s¯S©Ê¡AJava³s±µ¼Æ¾Ú®w¡Aºô¤W½Ò°ó¼Æ¾Ú®w³]p»P¹ê²{¡A½×¾Â¨t²Î¼Æ¾Ú®w³]p»P¹ê²{¡C ¥»®Ñ¤º®e·s¿o¡Aª¾ÃÑ¥þ±¡A¾A¦X¦UÓ¼h¦¸ªº¶}µo¤Hû©Î¼Æ¾Ú®wºÞ²z¤Hû¾\Ū¡A¯S§O¾A¦X·Q¤F¸ÑMySQL³Ì·s«eªu§Þ³Nªº¤Hû°Ñ¦Ò¡C |
¥Ø¿ý¡G²Ä1³¹MySQL8ªº¦w¸Ë¡B¤É¯Å©M·s¯S©Ê 1 1.1»{ÃÑMySQL¼Æ¾Ú®w 1 1.1.1MySQL»P¶}·½¤å¤Æ 1 1.1.2MySQLµo®i¾ú¥v 2 1.1.3¨Ï¥ÎMySQLªºÀu¶Õ 3 1.2MySQL8ªº·s¯S©Ê 4 1.2.1§ó²«KªºNoSQL¤ä«ù 4 1.2.2§ó¦nªº¯Á¤Þ 4 1.2.3§ó§¹µ½ªºJSON¤ä«ù 4 1.2.4¦w¥þ©M½ã¤áºÞ²z 4 1.2.5InnoDBªºÅÜ¤Æ 4 1.2.6¼Æ¾Ú¦r¨å 5 1.2.7ì¤l¼Æ¾Ú©w¸q»y¥y 5 1.2.8¸ê·½ºÞ²z 5 1.2.9¦r²Å¶°¤ä«ù 6 1.2.10Àu¤Æ¾¹¼W±j 6 1.2.11³q¥Îªíªí¹F¦¡ 6 1.2.12µ¡¤f¨ç¼Æ 6 1.2.13¥¿«hªí¹F¦¡¤ä«ù 7 1.2.14¤º³¡Á{®Éªí 7 1.2.15¤é§Ó°O¿ý 7 1.2.16³Æ¥÷Âê 7 1.2.17¼W±jªºMySQL´_¨î 7 1.3MySQL8²¾°£ªºÂ¯S©Ê 7 1.3.1¬d¸ß½w¦s 8 1.3.2¥[±K¬ÛÃö 8 1.3.3ªÅ¶¡¨ç¼Æ¬ÛÃö 8 1.3.4\N©MNULL 8 1.3.5mysql_install_db 8 1.3.6³q¥Î¤À°Ï³B²zµ{§Ç 9 1.3.7¨t²Î©Mª¬ºAÅܶq«H®§ 9 1.3.8mysql_plugin¤u¨ã 9 1.4Windows¥»O¤U¦w¸Ë»P°t¸mMySQL 9 1.4.1¦w¸ËMySQL8 9 1.4.2°t¸mMySQL8 13 1.4.3±Ò°ÊMySQLªA°È 18 1.4.4Ãö³¬MySQLªA°È 20 1.4.5°t¸mPathÅܶq 21 1.4.6µn¿ýMySQL¼Æ¾Ú®w 22 1.5Linux¥»O¤U¦w¸Ë»P°t¸mMySQL 22 1.5.1¦w¸Ë©M°t¸mMySQL8 23 1.5.2±Ò°ÊMySQLªA°È 27 1.5.3µn¿ýMySQL¼Æ¾Ú®w 28 1.6MacOSX¥»O¤U¦w¸Ë»P°t¸mMySQL 29 1.6.1¦w¸ËMySQL8 29 1.6.2±Ò°ÊMySQL8 32 1.6.3°t¸m©Mµn¿ýMySQL8 32 1.7MySQLªº¤É¯Å©M°¯Å 33 1.7.1¤É¯ÅMySQL 34 1.7.2°¯ÅMySQL 37 1.7.3««Ø©Î×´_ªí©Î¯Á¤Þ 37 1.7.4±NMySQL¼Æ¾Ú®w´_¨î¨ì¥t¤@»O¾÷¾¹ 38 1.8MySQL±`¥Î¹Ï§ÎºÞ²z¤u¨ã 39 1.8.1MySQL©x¤è«È¤áºÝMySQL-Workbench 39 1.8.2SQLyog¹Ï§ÎºÞ²z¤u¨ã 43 1.8.3Navicat¹Ï§ÎºÞ²z¤u¨ã 55 ²Ä2³¹¼Æ¾Ú®w¾Þ§@ 60 2.1¾Þ§@¼Æ¾Ú®w 60 2.1.1³Ð«Ø¼Æ¾Ú®w 60 2.1.2¬d¬Ý¼Æ¾Ú®w 61 2.1.3¿ï¾Ü¼Æ¾Ú®w 61 2.1.4§R°£¼Æ¾Ú®w 61 2.2¤°¤\¬O¦sÀx¤ÞÀº 62 2.2.1MySQL¤ä«ùªº¦sÀx¤ÞÀº 62 2.2.2InnoDB¦sÀx¤ÞÀº 64 2.2.3MyISAM¦sÀx¤ÞÀº 65 2.2.4MEMORY¦sÀx¤ÞÀº 65 2.2.5¿ï¾Ü¦sÀx¤ÞÀº 66 ²Ä3³¹¼Æ¾Úªí¾Þ§@ 68 3.1¼Æ¾Úªíªº³]p²z©À 68 3.2¼Æ¾Ú®w¤¤ªº¼Æ¾ÚÃþ«¬ 70 3.2.1¾ã¼ÆÃþ«¬ 70 3.2.2¯BÂI¼ÆÃþ«¬©M©wÂI¼ÆÃþ«¬ 72 3.2.3¤é´Á»P®É¶¡Ãþ«¬ 73 3.2.4¦r²Å¦êÃþ«¬ 74 3.2.5¤G¶i¨îÃþ«¬ 76 3.2.6JSONÃþ«¬¤ÎMySQL8JSON¼W±j 77 3.2.7Spatial¼Æ¾ÚÃþ«¬ 82 3.3MySQL8·s¯S©Ê¡G¦r²Å¶°»P±Æ§Ç³W«h 82 3.3.1¤@¯ë¦r²Å¶°©M±Æ§Ç³W«h 82 3.3.2MySQL¤¤ªº¦r²Å¶°©M±Æ§Ç³W«h 83 3.3.3«ü©w¦r²Å¶°©M±Æ§Ç³W«h 85 3.3.4³s±µ¦r²Å¶°©M±Æ§Ç³W«h 89 3.3.5°t¸mÀ³¥Îµ{§Ç¦r²Å¶°©M±Æ§Ç 90 3.3.6¿ù»~®ø®§¦r²Å¶° 91 3.3.7¦C¦r²Å¶°Âà´« 91 3.3.8±Æ§Ç°ÝÃD 91 3.3.9Unicode¤ä«ù 93 3.3.10¤ä«ùªº¦r²Å¶°©M±Æ§Ç³W«h 94 3.3.11³]¸m¿ù»~®ø®§»y¨¥ 95 3.3.12²K¥[¦r²Å¶° 96 3.3.13±N±Æ§Ç³W«h²K¥[¨ì¦r²Å¶° 97 3.3.14¦r²Å¶°°t¸m 98 3.3.15MySQLªA°È¾¹°Ï°ì³]¸m¤ä«ù 98 3.4³Ð«Øªí 99 3.4.1³Ð«Øªíªº»yªk§Î¦¡ 99 3.4.2³Ð«Ø±aJSONÃþ«¬ªºªí 100 3.5¬d¬Ýªíµ²ºc 100 3.5.1DESCRIBE»y¥y¬d¬Ýªí©w¸q 100 3.5.2SHOWCREATETABLE»y¥y¬d¬Ýªí¸Ô²Ó©w¸q 101 3.6§R°£ªí 102 3.7קïªí 103 3.7.1קïªí¦W 103 3.7.2¼W¥[¦r¬q 104 3.7.3§R°£¦r¬q 107 3.7.4קï¦r¬q 107 3.8¾Þ§@ªíªº¬ù§ô 109 3.8.1³]¸mªí¦r¬qªº«DªÅ¬ù§ô¡]NOTNULL¡ANK¡^ 110 3.8.2³]¸mªí¦r¬qªºÀq»{È¡]DEFAULT¡^ 111 3.8.3³]¸mªí¦r¬q°ß¤@¬ù§ô¡]UNIQUE¡AUK¡^ 112 3.8.4³]¸mªí¦r¬qªº¥DÁä¬ù§ô¡]PRIMARY¡APK¡^ 113 3.8.5³]¸mªí¦r¬qȦ۰ʼW¥[¡]AUTO_INCREMENT¡^ 116 3.8.6³]¸mªí¦r¬qªº¥~Áä¬ù§ô¡]FOREIGNKEY¡AFK¡^ 116 ²Ä4³¹¼Æ¾Ú¾Þ§@ 119 4.1´¡¤J¼Æ¾Ú°O¿ý 119 4.1.1´¡¤J§¹¾ã¼Æ¾Ú°O¿ý 119 4.1.2´¡¤J³¡¤À¼Æ¾Ú°O¿ý 120 4.1.3´¡¤J¦h±ø§¹¾ã¼Æ¾Ú°O¿ý 121 4.1.4´¡¤J¦h±ø³¡¤À¼Æ¾Ú°O¿ý 122 4.1.5´¡¤JJSONµ²ºcªº¼Æ¾Ú°O¿ý 122 4.2§ó·s¼Æ¾Ú°O¿ý 123 4.2.1§ó·s¯S©w¼Æ¾Ú°O¿ý 123 4.2.2§ó·s©Ò¦³¼Æ¾Ú°O¿ý 124 4.2.3§ó·sJSONµ²ºcªº¼Æ¾Ú°O¿ý 124 4.3§R°£¼Æ¾Ú°O¿ý 125 4.3.1§R°£¯S©w¼Æ¾Ú°O¿ý 125 4.3.2§R°£©Ò¦³¼Æ¾Ú°O¿ý 125 ²Ä5³¹¼Æ¾Ú¬d¸ß 126 5.1²³æ¬d¸ß 126 5.1.1¬d¸ß©Ò¦³¦r¬q¼Æ¾Ú 127 5.1.2¬d¸ß«ü©w¦r¬q¼Æ¾Ú 127 5.1.3DISTINCT¬d¸ß 127 5.1.4IN¬d¸ß 128 5.1.5BETWEENAND¬d¸ß 130 5.1.6LIKE¼Ò½k¬d¸ß 130 5.1.7¹ï¬d¸ßµ²ªG±Æ§Ç 131 5.1.8²³æ¤À²Õ¬d¸ß 132 5.1.9²Îp¤À²Õ¬d¸ß 133 5.2Áp¦X¬d¸ß 134 5.2.1¤º³s±µ¬d¸ß 134 5.2.2¥~³s±µ¬d¸ß 136 5.2.3¦X¦}¬d¸ß¼Æ¾Ú°O¿ý 137 5.2.4¤l¬d¸ß 138 ²Ä6³¹¯Á¤Þ 140 6.1¤°¤\¬O¯Á¤Þ 140 6.1.1¯Á¤Þªº§t¸q©M¯SÂI 140 6.1.2¯Á¤Þªº¤ÀÃþ 141 6.1.3¯Á¤Þªº³]pì«h 142 6.2³Ð«Ø©M¬d¬Ý¯Á¤Þ 143 6.2.1´¶³q¯Á¤Þ 143 6.2.2°ß¤@¯Á¤Þ 146 6.2.3¥þ¤å¯Á¤Þ 147 6.2.4¦h¦C¯Á¤Þ 149 6.3MySQL8¤¤¯Á¤Þ·s¯S©Ê 151 6.3.1ÁôÂïÁ¤Þ 151 6.3.2°§Ç¯Á¤Þ 153 6.4§R°£¯Á¤Þ 154 ²Ä7³¹µø¹Ï 156 7.1¤°¤\®ÉԨϥεø¹Ï 156 7.2³Ð«Øµø¹Ï 157 7.2.1³Ð«Øµø¹Ïªº»yªk§Î¦¡ 157 7.2.2¦b³æªí¤W³Ð«Øµø¹Ï 158 7.2.3¦b¦hªí¤W³Ð«Øµø¹Ï 159 7.3¬d¬Ýµø¹Ï 160 7.3.1¨Ï¥ÎDESCRIBE|DESC»y¥y¬d¬Ýµø¹Ï°ò¥»«H®§ 161 7.3.2¨Ï¥ÎSHOWTABLES»y¥y¬d¬Ýµø¹Ï°ò¥»«H®§ 161 7.3.3¦bviewsªí¤¤¬d¬Ýµø¹Ï¸Ô²Ó«H®§ 161 7.4קïµø¹Ï 162 7.4.1¨Ï¥ÎCREATEORREPLACEVIEW»y¥yקïµø¹Ï 162 7.4.2¨Ï¥ÎALTER»y¥yקïµø¹Ï 163 7.5§ó·sµø¹Ï 164 7.5.1¨Ï¥ÎSQL»y¥y§ó·sµø¹Ï 164 7.5.2§ó·s°ò¥»ªí¦Zµø¹Ï¦Û°Ê§ó·s 165 7.5.3§R°£µø¹Ï¤¤ªº¼Æ¾Ú 166 7.5.4¤£¯à§ó·sªºµø¹Ï 167 7.6§R°£µø¹Ï 169 ²Ä8³¹¦sÀx¹Lµ{©M¨ç¼Æ 171 8.1³Ð«Ø¦sÀx¹Lµ{©M¨ç¼Æ 171 8.1.1³Ð«Ø¦sÀx¹Lµ{ 172 8.1.2³Ð«Ø¦sÀx¨ç¼Æ 174 8.1.3Åܶqªº¨Ï¥Î 175 8.1.4©w¸q±ø¥ó©M³B²zµ{§Ç 176 8.1.5¥ú¼Ðªº¨Ï¥Î 178 8.1.6¬yµ{±±¨îªº¨Ï¥Î 179 8.2½Õ¥Î¦sÀx¹Lµ{©M¨ç¼Æ 183 8.2.1½Õ¥Î¦sÀx¹Lµ{ 183 8.2.2½Õ¥Î¦sÀx¨ç¼Æ 184 8.3¬d¬Ý¦sÀx¹Lµ{©M¨ç¼Æ 184 8.3.1¨Ï¥ÎSHOWSTATUS»y¥y¬d¬Ý¦sÀx¹Lµ{©M¨ç¼Æªºª¬ºA 185 8.3.2¨Ï¥ÎSHOWCREATE»y¥y¬d¬Ý¦sÀx¹Lµ{©M¨ç¼Æªº©w¸q 186 8.3.3±qinformation_schema.Routineªí¤¤¬d¬Ý¦sÀx¹Lµ{©M¨ç¼Æªº«H®§ 187 8.4קï¦sÀx¹Lµ{©M¨ç¼Æ 189 8.5§R°£¦sÀx¹Lµ{©M¨ç¼Æ 190 ²Ä9³¹Ä²µo¾¹ 193 9.1¤°¤\®ÉԨϥÎIJµo¾¹ 193 9.2³Ð«ØIJµo¾¹ 194 9.2.1³Ð«Ø¦³¤@±ø°õ¦æ»y¥yªºÄ²µo¾¹ 194 9.2.2³Ð«Ø¥]§t¦h±ø°õ¦æ»y¥yªºÄ²µo¾¹ 195 9.3¬d¬ÝIJµo¾¹ 197 9.3.1³q¹LSHOWTRIGGERS»y¥y¬d¬ÝIJµo¾¹ 197 9.3.2³q¹L¬d¬Ý¨t²Îªítriggers¹ê²{¬d¬ÝIJµo¾¹ 198 9.4§R°£Ä²µo¾¹ 200 ²Ä10³¹¨Æ°È©MÂê 201 10.1¨Æ°È·§z 201 10.2MySQL¨Æ°È±±¨î»y¥y 203 10.3MySQL¨Æ°È¹jÂ÷¯Å§O 205 10.3.1READ-UNCOMMITED¡]Ū¨ú¥¼´£¥æ¤º®e¡^ 206 10.3.2READ-COMMITED¡]Ū¨ú´£¥æ¤º®e¡^ 207 10.3.3REPEATABLE-READ¡]¥i«Åª¡^ 207 10.3.4SERIALIZABLE¡]¥i¦ê¦æ¤Æ¡^ 209 10.4InnoDBÂê¾÷¨î 209 10.4.1ÂꪺÃþ«¬ 210 10.4.2Âê²É«× 211 ²Ä11³¹¦w¥þºÞ²z 213 11.1Åvªí 213 11.1.1userªí 214 11.1.2dbªí 215 11.1.3tables_privªí©Mcolumns_privªí 217 11.1.4procs_privªí 218 11.2½ã¤áºÞ²z 218 11.2.1µn¿ý©M°h¥XMySQLªA°È¾¹ 218 11.2.2·s«Ø´¶³q¥Î¤á 220 11.2.3§R°£´¶³q¥Î¤á 221 11.2.4root¥Î¤áקï¦Û¤vªº±K½X 222 11.2.5root¥Î¤áקﴶ³q¥Î¤áªº±K½X 223 11.2.6´¶³q¥Î¤áקï±K½X 225 11.2.7root¥Î¤á±K½X¥á¥¢ªº¸Ñ¨M¿ìªk 225 11.2.8MySQL8±K½XºÞ²z 229 11.3MySQL8·s¯S©Ê¡G¨¤¦â 232 11.3.1³Ð«Ø¨¤¦â¦}µ¹¨¤¦â±ÂÅv 232 11.3.2µ¹¥Î¤á²K¥[¨¤¦â 233 11.3.3½s¿è¨¤¦â©ÎÅv 235 11.3.4§R°£¨¤¦â 236 11.4³X°Ý±±¨î 236 11.4.1³s±µ®Ö¹ê¶¥¬q 236 11.4.2½Ð¨D®Ö¹ê¶¥¬q 237 11.5MySQL8·s¯S©Ê¡G¦w¥þ²Õ¥ó©M´¡¥ó 237 11.5.1¨¥÷ÅçÃÒ´¡¥ó 238 11.5.2³s±µ±±¨î´¡¥ó 239 11.5.3±K½XÅçÃÒ²Õ¥ó 240 11.5.4MySQLKeyring 241 11.5.5MySQL¥ø·~¼fp 242 11.5.6MySQL¥ø·~¨¾¤õùÙ 242 11.6MySQL8·s¯S©Ê¡GFIPS 246 11.6.1FIPS·§z 246 11.6.2MySQL¤¤FIPS¼Ò¦¡ªº¨t²În¨D 246 11.6.3¦bMySQL¤¤°t¸mFIPS¼Ò¦¡ 246 ²Ä12³¹¼Æ¾Ú®w³Æ¥÷¡B«ì´_»P´_¨î 247 12.1¼Æ¾Ú³Æ¥÷ 247 12.1.1¨Ï¥Îmysqldump©R¥O³Æ¥÷¤@Ӽƾڮw 248 12.1.2¨Ï¥Îmysqldump©R¥O³Æ¥÷¤@Ӽƾڮwªº¬Y´X±iªí 250 12.1.3¨Ï¥Îmysqldump©R¥O³Æ¥÷¦hӼƾڮw 252 12.1.4ª½±µ´_¨î¾ãӼƾڮw¥Ø¿ý 255 12.1.5³Æ¥÷Âê 255 12.2¼Æ¾Ú«ì´_ 255 12.2.1¨Ï¥Îmysql©R¥O«ì´_ 255 12.2.2ª½±µ´_¨î¨ì¼Æ¾Ú®w¥Ø¿ý 256 12.3¼Æ¾Ú®w¾E²¾ 257 12.3.1¬Û¦Pª©¥»ªºMySQL¼Æ¾Ú®w¤§¶¡ªº¾E²¾ 257 12.3.2¤£¦Pª©¥»ªºMySQL¼Æ¾Ú®w¤§¶¡ªº¾E²¾ 258 12.3.3¤£¦P¼Æ¾Ú®w¤§¶¡ªº¾E²¾ 258 12.4ªíªº¾É¥X©M¾É¤J 259 12.4.1¨Ï¥ÎSELECT¡KINTOOUTFILE¾É¥X¤å¥»¤å¥ó 259 12.4.2¨Ï¥Îmysqldump©R¥O¾É¥X¤å¥»¤å¥ó 261 12.4.3¨Ï¥Îmysql©R¥O¾É¥X¤å¥»¤å¥ó 265 12.4.4¨Ï¥ÎLOADDATAINFILE¤è¦¡¾É¤J¤å¥»¤å¥ó 268 12.4.5¨Ï¥Îmysqlimport¤è¦¡¾É¤J¤å¥»¤å¥ó 270 12.5¼Æ¾Ú´_¨î 273 12.5.1°t¸m´_¨î 273 12.5.2´_¨î¹ê²{ 275 12.5.3´_¨î¸Ñ¨M¤è®× 276 12.5.4´_¨îª`ÄÀ©M´£¥Ü 279 12.6²Õ´_¨î 280 12.6.1²Õ´_¨îI´º 280 12.6.2ºÊµø²Õ´_¨î 282 12.6.3²Õ´_¨î¾Þ§@ 284 12.6.4²Õ´_¨î¦w¥þ©Ê 286 12.6.5²Õ´_¨î¨t²ÎÅܶq 286 12.6.6n¨D©M¨î 287 ²Ä13³¹MySQLªA°ÈºÞ²z 289 13.1MySQLªA°È 289 13.1.1°t¸mMySQLªA°È 289 13.1.2ªA°È¨t²ÎÅܶq 291 13.1.3ªA°ÈªºSQL¼Ò¦¡ 292 13.2MySQL¼Æ¾Ú¥Ø¿ý 292 13.3¨t²Î¼Æ¾Ú®wmysql 293 13.3.1¼Æ¾Ú¦r¨åªí 293 13.3.2±ÂÅv¨t²Îªí 294 13.3.3¹ï¶H«H®§¨t²Îªí 295 13.3.4¤é§Ó¨t²Îªí 295 13.3.5ªA°ÈºÝÀ°§U¨t²Îªí 295 13.3.6®É°Ï¨t²Îªí 296 13.3.7´_¨î¨t²Îªí 296 13.3.8Àu¤Æ¾¹¨t²Îªí 296 13.3.9¨ä¥L¨t²Îªí 297 13.4MySQLªA°È¤é§Ó 297 13.5MySQLªA°È²Õ¥ó 297 13.6MySQLªA°È´¡¥ó 298 13.7¦b¤@»O¾÷¾¹¤W¹B¦æ¦hÓMySQL¹ê¨Ò 298 ²Ä14³¹¤é§ÓºÞ²z 300 14.1MySQL³n¥ó©Ò¤ä«ùªº¤é§Ó 300 14.2¾Þ§@¤G¶i¨î¤é§Ó 301 14.2.1±Ò°Ê¤G¶i¨î¤é§Ó 302 14.2.2¬d¬Ý¤G¶i¨î¤é§Ó 303 14.2.3¨Ï¥Î¤G¶i¨î¤é§Ó«ì´_¼Æ¾Ú®w 304 14.2.4¼È°±¤G¶i¨î¤é§Ó 305 14.2.5§R°£¤G¶i¨î¤é§Ó 305 14.3¾Þ§@¿ù»~¤é§Ó 308 14.3.1±Ò°Ê¿ù»~¤é§Ó 308 14.3.2¬d¬Ý¿ù»~¤é§Ó 309 14.3.3§R°£¿ù»~¤é§Ó 310 14.4³q¥Î¬d¸ß¤é§Ó 310 14.4.1±Ò°Ê³q¥Î¬d¸ß¤é§Ó 311 14.4.2¬d¬Ý³q¥Î¬d¸ß¤é§Ó 312 14.4.3°±¤î³q¥Î¬d¸ß¤é§Ó 312 14.4.4§R°£³q¥Î¬d¸ß¤é§Ó 313 14.5ºC¬d¸ß¤é§Ó 314 14.5.1±Ò°ÊºC¬d¸ß¤é§Ó 314 14.5.2¬d¬Ý©M¤ÀªRºC¬d¸ß¤é§Ó 317 14.5.3°±¤îºC¬d¸ß¤é§Ó 318 14.5.4§R°£ºC¬d¸ß¤é§Ó 319 ²Ä15³¹MySQL8·s¯S©Ê¡G¼Æ¾Ú¦r¨å 321 15.1¼Æ¾Ú¦r¨å¼Ò¦¡ 321 15.2§R°£°ò¤_¤å¥óªº¤¸¼Æ¾Ú¦sÀx 322 15.3¦r¨å¼Æ¾Úªº¨Æ°È¦sÀx 322 15.4¦r¨å¹ï¶H½w¦s 322 15.5INFORMATION_SCHEMA©M¼Æ¾Ú¦r¨å¶°¦¨ 323 15.6§Ç¦C¤Æ¦r¨å«H®§¡]SDI¡^ 323 15.7¼Æ¾Ú¦r¨å¥Îªk®t²§ 324 15.8¼Æ¾Ú¦r¨å¨î 324 ²Ä16³¹MySQL8·s¯S©Ê¡GInnoDB 325 16.1InnoDBªíªºÀu¶Õ 325 16.2InnoDB©MACID¼Ò«¬ 326 16.3InnoDB¬[ºc 327 16.4ªíªÅ¶¡ 329 16.5ªí©M¯Á¤Þ 330 16.5.1InnoDBªí 330 16.5.2InnoDB¯Á¤Þ 331 16.6³Æ¥÷©M«ì´_ 332 16.7InnoDB©MMySQL´_¨î 333 16.8memcached´¡¥ó 334 ²Ä17³¹MySQL8·s¯S©Ê¡GNoSQL 337 17.1NoSQLªº·§©À 337 17.2±NMySQL³]¸m¬°NoSQL¦sÀx 337 17.3MySQLShell 339 17.4X´¡¥ó 345 ²Ä18³¹Java¾Þ§@MySQL¼Æ¾Ú®w 347 18.1Java³s±µMySQL¼Æ¾Ú®w 347 18.1.1JDBC²¤¶ 347 18.1.2¤U¸üJDBCÅX°ÊMySQLConnector/J 349 18.1.3Windows¤U¦w¸ËMySQLConnector/JÅX°Ê 350 18.1.4Linux©MMacOSX¤U¦w¸ËMySQLConnector/JÅX°Ê 350 18.1.5IntelliJIDEAÀô¹Ò¤U¦w¸ËMySQLConnector/JÅX°Ê 350 18.1.6Java³s±µMySQL¼Æ¾Ú®w 352 18.2¨Ï¥ÎStatement°õ¦æSQL»y¥y 353 18.2.1executeQuery()¬d¸ß 353 18.2.2execute()¬d¸ß 355 18.2.3executeUpdate()´¡¤J¼Æ¾Ú 356 18.2.4executeUpdate()קï¼Æ¾Ú 357 18.2.5executeUpdate()§R°£¼Æ¾Ú 358 18.3¨Ï¥ÎPreparedStatement°õ¦æSQL»y¥y 359 18.3.1executeQuery()¬d¸ß 359 18.3.2execute()¬d¸ß 361 18.3.3executeUpdate()´¡¤J¼Æ¾Ú 362 18.3.4executeUpdate()קï¼Æ¾Ú 363 18.3.5executeUpdate()§R°£¼Æ¾Ú 364 18.4Java³Æ¥÷©M«ì´_MySQL¼Æ¾Ú®w 365 18.4.1¨Ï¥ÎJava³Æ¥÷MySQL¼Æ¾Ú®w 365 18.4.2¨Ï¥ÎJava«ì´_MySQL¼Æ¾Ú®w 366 ²Ä19³¹ºô¤W½Ò°ó¨t²Î¼Æ¾Ú®w³]p 368 19.1¨t²Î·§z 368 19.2¨t²Î¥\¯à 369 19.3¼Æ¾Ú®w³]p©M¹ê²{ 369 19.3.1³]pªí 369 19.3.2³]p¯Á¤Þ 374 19.3.3³]pµø¹Ï 375 19.3.4³]pIJµo¾¹ 375 19.4¶µ¥Ø¤pµ² 376 ²Ä20³¹½×¾ÂºÞ²z¨t²Î¼Æ¾Ú®w³]p 377 20.1¨t²Î·§z 377 20.2¨t²Î¥\¯à 378 20.3¼Æ¾Ú®w³]p©M¹ê²{ 378 20.3.1³]pªí 378 20.3.2³]p¯Á¤Þ 382 20.3.3³]pµø¹Ï 383 20.3.4³]pIJµo¾¹ 383 20.4¶µ¥Ø¤pµ² 384 |
§Ç¡G |