Çë½Ì¸÷λ:Ò»¸öMySQLÊý¾Ý¿â±í¸´ÖƺóÎÞ·¨¶ÁÈ¡µÄÎÊÌâ?
¸÷λºÃ£¬ÎÒ½«Áíһ̨µçÄÔÉϵÄMySQLÊý¾Ý¿âµÄÒ»¸ö±í¸´Öƺ󵽱¾µØ»úÉÏMySQLÊý¾Ý¿âÏàӦĿ¼(\dataĿ¼Ï£©£¬µ«ÊÇÔÚmysqlÃüÁîÌáʾ·ûÏÂÓÃshow tablesÃüÁî¿ÉÒÔÏÖʾ´æÔÚµ±Ç°±í£¬µ«ÊÇÓÃdescibe »òselect ÃüÁîʱȴ³öÏÖÎÞ·¨¶ÁÈ¡µÄÎÊÌâ,ϵͳÌáʾ¡°²»´æÔÚÕâ¸ö±í¡±µÄ´íÎó£»²»ÖªµÀÊDz»ÊDZ¾µØ»úÉÏÏàÓ¦Êý¾Ý¿âÉÏdb.optµÄÔÒò£¬ÏëÇë¸÷λ¸ßÊÖ½â¾öһϣ¬²»Ê¤¸Ðл£¡{{--
Ïà¹ØÎÊ´ð£º
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......
CREATE DATABASE ADDRESSLIST;
USE ADDRESSLIST;
DROP TABLE IF EXISTS FRIEND;
CREATE TABLE FRIEND
(FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY ,
FRIEND_NAME VARCHAR(20) NOT N ......
±í
CREATE TABLE `ch1` (
`id` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT,
`no` int(10) unsigned DEFAULT NULL,
`dtime` datetime DEFAULT NULL,
PRIMARY KEY (`id ......