ÖÚËùÖÜÖª£¬j2seÖÐÿ¸öÀà¶¼ÓиöĬÈϸ¸À࣬¼´Object£¬¼ÙÉ趨Òå¸ö¶¯ÎïÀ࣬animal£¬ÆäÖбÈÈçÓиöcatÀà¼Ì³ÐanimalÀ࣬ÏÔÈ»catÀàÒ²¼Ì³ÐObjectÀ࣬ÄÇÕâ¸öcatÀ಻ÊÇÓÐÁ½¸ö¸¸ÀàÁË£¿£¿£¨ËäȻ˵£¬animalÀàÒ²¼Ì³ÐObjectÀࣩ
ÎÒÏ룬ÄãÊDz»ÊÇ×êÅ£½Ç¼âÁË¡£
Äãд¸öÀàÐèÒªÄãÈ¥ÏÔʽµÄ¼Ì³ÐObjectÁËÂð¡£
²»ÊÇ£¬Ö»ÓÐanimalÀàÊǸ¸À࣬objec ......
ÎÒ´ÓoracleÖжÁÈ¡³öÊý¾Ý£¬ÔÙ±£´æµ½mysqlÖУ¬´Óoracle¶Á³öµÄÖÐÎÄÊÇÕý³£ÏÔʾµÄ£¬µ«ÊDZ£´æµ½mysqlÖоͱä³ÉÁËÂÒÂ룬ÎÒ°ÑmysqlµÄ±àÂ뷽ʽ¸ÄΪUTF8¶¼Ã»ÓÐÓ㬷´¶øÔÚÔËÐÐjava³ÌÐòʱ³öÏÖ£ºData truncation: Data truncated for column 'TITLE' at row 1
ÓÐûÓÐÄÄλ¸ßÊÖ¿ÉÒÔ°ï°ï棬лл~~
ÔÚдÈëmysqlǰ£¬ÊÔÏÂÖ´ÐÐÕâ¸öÓ ......
ÎÒÏÖÔÚÓиöÊý¾Ý¿â£¬Àï±ßÖ÷ÒªÓÐÁ½¸ö±í£¬class,news
ÏÖÔÚnews±íÓÐ2.3G£¬35W¶àÌõ¼Ç¼£¬ÎҵIJéѯ´ó²¿·ÖÊÇÒÔÏÂÐÎʽ£¬
select a.*,b.* from news as a inner join class as b
on a.classid=b.classid
ÆÚÖÐnews ±íÀﻹÓиö nodeµÄ×ֶΣ¬Ò²Òª¼Ó½øselectÀҲ¾ÍÊÇÍêÕûµÄÊÇ
select a.*,b.* from news ......
#include <winsock2.h>
#include <iostream>
#include <mysql.h>
using namespace std;
int main(char **args){
MYSQL mysql;
mysql_init(&mysql);
if (mysql_real_connect(&mysql,"localhost","root","ok","test",3306,0,0)) ......
¹«Ë¾mysqlÊý¾Ý¿â£¬µ¼³öÌØ±ðÈ¥£¬±¾ÏëÓÅ»¯Ï£¬¸ãÁ˼¸Ììû¸ãºÃ¡£
·ÖÎöÁ˼¸¸öÔÒò£¬Ò»¿ªÊ¼ÒÔΪInnoDbûÉèÖú㬿ÉÒÔÉèÖÃÁËһϻ¹ÊDz»ÐÐ
ÓпÉÄÜÊÇÒòΪ±íÌ«¶àÁË£¬ËÓÐÕâ·½ÃæµÄ¾Ñ飬¸ß·ÖÏàËÍ
»·¾³
mysql
InnoDB
±í´ó¸ÅÓÐ5W±í
BUFFER POOL AND MEMORY
----------------------
Total memor ......
ÔÚÕÒmysql¶ÔxmlµÄÖ§³Öʱ£¬ÕÒµ½Õâ¸öÒ»¶Î£º
1¡¢Êä³öÊý¾Ý¿â°æ±¾±äÁ¿Îªxml¸ñʽ
Shell> mysql -X -uroot -proot -e "use test; show variables like '%version%';"
ÇëÎÊÕâÀïÕâ¸öshellÊÇʲô¶«Î÷£¿
unix »òlinuxϵÄϵͳÌáʾ·û£¬»òwindows cmdϵÄϵͳÌáʾ·û
µ±³öÏÖ×¼±¸ÔÚÌØ¶¨³ÌÐòÖÐÖ ......