7-3 ¸ê®Æ®wªº°ò¦Æ[©À(7-3-1 ¦p¦ó«Ø¥ß¸ê®Æ®w)
¡@¼ÊºÙ: ¤p»x ¡@ÀY»Î: ´¿¸g¤]¬O¤ô¹q¤u
ºÞ²zû
- ©«¤l
- 1190
- ¥DÃD
- 394
- ºëµØ
- 113
- ¿n¤À
- 1747
- ÂI¦W
- 1
- §@·~¨t²Î
- Vista
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 200
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2024-11-25
|
7-3 ¸ê®Æ®wªº°ò¦Æ[©À(7-3-1 ¦p¦ó«Ø¥ß¸ê®Æ®w)
7-3 ¸ê®Æ®wªº°ò¦Æ[©À
¸ê®Æ®w¤D¬O¤@¸s®æ¦¡¤Æ¸ê®ÆªºÀx¦s³õ©Ò¡A²³æªº¨Ì·Ó¼h¯Å¤º®e¨Ó·§¤À¡G¸ê®Æ®w¡]Database¡^->¸ê®Æªí¡]Table¡^->Äæ¦ì¡]Column¡^->Äæ¦ì¸ê®Æ¡A±z¤£§«±N¸ê®Æ®w·Q¹³¦¨¤@¶¡Ü®w¡A«h¸ê®Æªí´N¬OÜ®w¤¤ªº®w©Ð¡AÄæ¦ì«h¬O®w©Ð¤¤Àxª«¬[ªºÀxª«®æ¡A¨º¸ê®Æ©O¡H¸ê®Æ´Nµ¥¦P©ñ¸m©óÀxª«¬[ªºª««~¡C
7-3-1 ¦p¦ó«Ø¥ß¸ê®Æ®w
¦bMySQL Server¤¤«Ø¥ß¸ê®Æ®w¦³¬Û·í¦hªº¤èªk¡A¥i¥H¥Î©R¥O¦C«ü¥O¡BphpMyAdmin¹Ï«¬¤ÆºÞ²z¤¶±¡BPHP¨ç¦¡µ¥¡Aµ§ªÌ¬O¤ñ¸û³ßÅw¥Î¹Ï§Î¤ÆªºphpMyAdmin¨Ó«Ø¥ß¸ê®Æ®w¡C
¨Ï¥Î©R¥O¦C«ü¥O«Ø¥ß¸ê®Æ®w
n¨Ï¥Î«ü¥O¦bMySQL Server¤¤«Ø¥ß¸ê®Æ®w¡A²Ä¤@¨B´N¬On¸òMySQL Server«Ø¥ß³s½u¡A«Ø¥ß³s½uªº«ü¥O¦p¤U¡G- mysql [-u username] [-h hostname] [-p[password]] dbname
½Æ»s¥N½X
- -u¡GMySQL Server¨Ï¥ÎªÌ±b¸¹¡C
- -h¡GMySQL Server¥D¾÷¦WºÙ¡C
- -p¡G¨Ï¥ÎªÌ±b¸¹ªº±K½X(°Ñ¼Æ»P±K½X¤§¶¡¨S¦³ªÅ¥Õ)¡C
- dbname¡G³s½u«á±ý¨Ï¥Îªº¸ê®Æ®w¡]¥i¬Ù²¤¡^¡C
|
|
¤ß¦w¡A¥¦w
µoªí¥ô¦óµL·N¸qªº·PÁ©ÎÄé¤ô¤å³¹¤@«ß¬å,¬Ã±¤±b¸¹,½Ð¸Ô¾\ª©³W!!
|
|
|
|
|
¡@¼ÊºÙ: ¤p»x ¡@ÀY»Î: ´¿¸g¤]¬O¤ô¹q¤u
ºÞ²zû
- ©«¤l
- 1190
- ¥DÃD
- 394
- ºëµØ
- 113
- ¿n¤À
- 1747
- ÂI¦W
- 1
- §@·~¨t²Î
- Vista
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 200
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2024-11-25
|
7.¥Ñ©ó§Ú̪º¸ê®Æ®w±N¦s©ñªº¸ê®Æ¬°¤¤¤åÁcÅé¡A¦]¦¹¡A¥i§Q¥Î¡uALTER DATABASE¡v«ü¥OÅܧó¸ê®Æ®wªº°ò¦µ²ºc¡A¨Ò¦p¦r²Åªº¹ï·Ó¡]®Õ¹ï¡^¡AÁקK§Ú̱N¤¤¤å¸ê®Æ¦s¤J¸ê®Æ®w«áÅܦ¨¶Ã½X¡A³oÂI«Ü«n¡A¬G¡A½Ð§Q¥Î¤U¦C«ü¥OÅܧó¸ê®Æ®wªº¦r²Å¹ï·Ó¡G- ALTER DATABASE ¡¥¸ê®Æ®w¦W¡¦ DEFAULT
- CHARACTER SET big5 COLLATE big5_chinese_ci;
½Æ»s¥N½X «Ø¥ß¸ê®Æ®w»P¸ê®Æ®w¦r²Åªº¹ï·Ó¡]®Õ¹ï¡^¥i¦P®É¶i¦æ¡A¥H¥»¨Ò¨Ó»¡¡A¨BÆJ6»P7ªº±Ôz§Y¥i¦X¨Ö¦p¤U¡G- CREATE DATABASE `orderbase` DEFAULT CHARACTER SET big5 COLLATE big5_chinese_ci;
½Æ»s¥N½X
¹Ï7-14 Åܧó¸ê®Æ®wªº¦r²Å¹ï·Ó¡C
¦Ü¦¹¡A§ÚÌ´N§¹¦¨¨Ï¥Î«ü¥O¤è¦¡«Ø¥ß¸ê®Æ®wªº¨BÆJ¤F¡A³Ì«á¡A¦b¡u>mysql¡vªº´£¥Ü²Å¸¹«á¿é¤J¡yexit;¡zµ²§ô»PMySQL Serverªº³s½u¡C |
|
¤ß¦w¡A¥¦w
µoªí¥ô¦óµL·N¸qªº·PÁ©ÎÄé¤ô¤å³¹¤@«ß¬å,¬Ã±¤±b¸¹,½Ð¸Ô¾\ª©³W!!
|
|
|
|
|