mysql Ææ¹ÖµÄ´íÎó
½ñÌì¸ã PHP ¿ª·¢µÄʱºò£¬¸ã³öÁËÕâ¸ö´íÎó£º
ÎÒÖ´ÐеÄÓï¾äÊÇ£º
INSERT INTO `tb_Replies`(`W_ID`,`R_Name`,`R_Contact`,`R_Content`) VALUES (98,'test','test','test');
½á¹û¾¹È»·µ»Ø´íÎó£º
1146:Table 'mysite.writings' doesn't exist
´ó¼Ò¿´Çå³þÁË£¬ÎÒ²åÈëµÄÊÇ tb_Replies ±í£¬½á¹û¾¹È»·µ»Ø writings ±í²»´æÔÚ£¨ÊÂʵÉÏÎÒÊý¾Ý¿âÀï¸ù±¾Ã» writings Õâ±í£©¡£
¶øÇÒ£¬ËäÈ»·µ»ØÁË´íÎó£¬Êý¾ÝÈ´ÊDzåÈë³É¹¦¡£
´ó¼ÒÓÐûÓÐÓöµ½¹ýÀàËÆµÄÎÊÌâ £¿¸ÃÈçºÎ½â¾ö£¿
ÊÔÁËһϣ¬Ã²ËÆÃ»Ê²Ã´Ìرð¡£
ÄÜ´ÓÖп´³öµÄÊÇ£¿
²»ÖªµÀ£¬Äõ½ÄãµÄcreate table Óï¾ä£¬ÕâÑù²ÅÄÜ×öʵÑé¡£
ÁíÍâÓÐûÓÐʲô´¥·¢Æ÷ÔÚÕâ¸ö±íÉÏ¡£
ûÓд¥·¢Æ÷£¬¶øÇÒÕâ¸öÊý¾Ý¿âÖÐÖ»ÓÐÕâ¸ö±íÓòåÈëÓï¾äÊdzö´íµÄ¡£
| tb_Replies | CREATE TABLE `tb_Replies` (
`R_ID` int(10) unsigned NOT NULL auto_increment,
`R_Name` varchar(15) NOT NULL,
`R_Contact` varchar(30) NOT NULL,
`R_Content` varchar(400) NOT NULL,
`R_Time` timestamp NOT NULL default CURRENT_TIMESTAMP,
`W_ID` int(10) unsigned NOT NULL,
`F_R_ID` int(10) unsigned NOT NULL default '0',
PRIMARY KEY USING BTREE (`R_ID`),
KEY `W_ID` USING BTREE (`W_ID`),
Ïà¹ØÎÊ´ð£º
ÓÃjsp×ö¶«Î÷¸øÍêÈ«²»¶®mysqlµÄÈËÓ㬿ÉÊDZ¸·ÝʱֻÓпÕÎļþ£¬ÕâÊÇʲôÇé¿ö£¬
×îºÃÓÐÔ´´úÂ룬лл
Æäʵ±¸·ÝµÄ¹ý³ÌÎÒÏë´ó¸ÅÊÇÕâÑùµÄ£º
½«±íAÖеÄÊý¾Ý·Åµ½ArrayListÖУ¬È»ºó½«Õâ¸öArrayListÖеÄÊý¾ÝÔÙ´æµ½±íBÖС£ ......
ÎÒ֮ǰµ¼ÈëµÄÊý¾Ý¿â£¬ÏÖÔÚɾ³ý²»ÁË£¬ÓÃÁËÃüÁîÐк͹¤¾ß¶¼²»ÐУ¬ÖØÆôÒ²²»ÐУ¬ÕâÊÇÎªÊ²Ã´ÄØ£¿
ÄãÊÇÈçºÎɾ³ýµÄ£¿
ÓÐʲôÌáʾ£¿
ÎÊÌâ˵Ã÷Ô½Ïêϸ£¬»Ø´ðÒ²»áԽ׼ȷ£¡²Î¼ûÈçºÎÌáÎÊ¡££¨ÌáÎʵÄÖǻۣ©
......
MySQLÈëÃÅ
¿ÉÒÔÏÈ¿´Ê²Ã´Êé¼®°¡£¿
ÏȶÁÈý±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ¡·,ÕÆÎÕÊý¾Ý¿âµÄ»ù´¡ÀíÂÛ¡£
È»ºóÔÙ´Ö¿´Ò»±éMYSQLµÄ¹Ù·½Îĵµ¡£ MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html
¾ÍÕÒÒ»±¾ºÜ»ù´ ......
ÐèÒªÔÚMySQLÀïÃæÐ´¸ö´¢´æ¹ý³Ì,
·ÃÎÊoracleµÄÊý¾Ý.
Ŀǰ²»ÄÜ
oracle¿ÉÒԾͿÉÒÔÁ¬½Ómysql£¬Í¨¹ýodbc+dblinkÀ´Á¬½Ó
ûÓа취¡£Ä¿Ç°µÄMYSQLµÄ°æ±¾ÖÐÉв»Ö§³ÖÁ¬½Óµ½ÆäËüÊý¾Ý¿â£¬
ÕæÍ¦ÓÐÏë·¨µÄ ĿǰÎÒû×ö¹ý
......