mysql ÃüÁîʹÓÃ
mysql ÃüÁîѧϰ£º
1. mysql -uroot ;
2.mysql -h ip -ubusiusr -pbusiusr newdrmdb;
3.show databases ; //ÏÔʾËùÓеÄÊý¾Ý¿â ;
4.show tables ; //ÏÔʾËùÓеıí ;
5.set names gbk ; //ÉèÖÃ×Ö·û¼¯ ;
6.desc tmonthfees201004 ; //ÏÔʾ±í½á¹¹ ;
7.alter table tcontents change cVersion cVersion varchar(128) null ; //ÐÞ¸Ämysql±íÖÐ×ֶεÄÊôÐÔ ;
8. show index from tcontents from newdrmdb;
show index from newdrmdb.tcontents ;
show keys from tcontents ;
show indexes from tcontents ; //²é¿´±íµÄË÷Òý ;
Ïà¹ØÎĵµ£º
Ms sql 2000
drivername=com.microsoft.jdbc.sqlserver.SQLServerDriver
url=jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=books
username=sa
password=sa
MySQL
drivername=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost/books
username=root
password=root
Oracle
drivername=orac ......
ÄãʹÓùý±ðÈ˵ı¸·Ý·½°¸À´±¸·ÝÄãµÄMySQLÊý¾ÝÂð?ÄãÓÐ¶à¹ØÐÄÄãµÄÊý¾Ý?Äã¸ÒÈ·¶¨ÄãÏÖÔÚÕýÔÚÔËÐеĽű¾¾ÍÊǿɿ¿µÄ£¬¿É»Ö¸´µÄ±¸·Ý£¬¶øÇÒÔÚÔËÐйý³ÌÖв»»áÓ°ÏìÄãµÄ¹Ø¼ü×÷ÒµÂð?ÔڻشðÕâ¸öÎÊÌâ֮ǰ£¬ÏȻشðÏÂÃæÊ®¸öÎÊÌâ°É£º
¡¡¡¡1. ±¸·ÝÒªÇóÍ£Ö¹Êý¾Ý¿âÂð?Èç¹û²»ÐèÒª£¬ÄÇô±¸·ÝµÄʱºò»áÓ°Ïìʲô?¿éÉ豸?I/O¸ºÔØ?»º³å?»òÕßÊÇÆäËû?
¡¡ ......
Ò» ÏÂÔØMySQL
http://dev.mysql.com/downloads/mysql/5.0.html
½âѹMySQL£¨F:\Program Files\MySQL\£©MySQL°²×°Ä¿Â¼
¶þ н¨my.ini
ÔÚF:\Program Files\MySQL\Ͻ¨Á¢my.iniÎļþ£¬ÄÚÈÝΪ
my.ini
[mysqld]
# ÉèÖÃmysqlµÄ°²×°Ä¿Â¼
basedir=F:\\Program Files\\MySQL
# ÉèÖÃmysqlÊý¾Ý¿âµÄÊý¾ÝµÄ´æ·ÅĿ¼£¬±ØÐ ......
µ±mysqlÊý¾Ý¿âΪGBK±àºÅ£¬.net³ÌÐòʹÓÃĬÈϱàÂ루UTF-8£©£¬ÏòmysqlÖвåÈëÊý¾ÝÈÝÒײúÉúÂÒÂë¡£½â¾ö°ì·¨ÊÇÔÚÁ¬½Ó×Ö·û´®¼ÓÈëCharset=gbk£º
MySqlConnection myConnection = new MySqlConnection("Database=test2;Data Source=localhost;User Id=root;Password=ikmbikmb;Charset=gbk"); ......
ɾ³ýrpm°ü
rpm -e mysql-embedded-5.1.39-4.fc12.i686 --nodeps
°²×°rpm°ü
rpm -vih MySQL-server-community-5.1.37-0.rhel5.i386.rpm
²éѯÒѰ²×°µÄrpm°ü
rpm -qa | grep MySQL
Æô¶¯mysql
mysql£¨Ã»ÓÐÃÜÂëµÄÇé¿ö£©
&nbs ......