²é¿´ MySql ×Ö·û¼¯
MySQL ÂÒÂëµÄ¸ùÔ´ÊÇµÄ MySQL ×Ö·û¼¯ÉèÖò»µ±µÄÎÊÌ⣬±¾ÎÄ»ã×ÜÁËÓйز鿴 MySQL ×Ö·û¼¯µÄÃüÁî¡£°üÀ¨²é¿´ MySQL Êý¾Ý¿â·þÎñÆ÷×Ö·û¼¯¡¢²é¿´ MySQL Êý¾Ý¿â×Ö·û¼¯£¬ÒÔ¼°Êý¾Ý±íºÍ×ֶεÄ×Ö·û¼¯¡¢µ±Ç°°²×°µÄ MySQL ËùÖ§³ÖµÄ×Ö·û¼¯µÈ¡£
Ò»¡¢²é¿´ MySQL Êý¾Ý¿â·þÎñÆ÷ºÍÊý¾Ý¿â×Ö·û¼¯¡£
mysql> show variables like '%char%';
+--------------------------------+-----------------------------------------------+------
| Variable_name | Value |......
+--------------------------------+-------------------------------------+------
| character_set_client | utf8 |...... -- ¿Í»§¶Ë×Ö·û¼¯
| character_set_connection| utf8 |......
| character_set_database | utf8 |...... -- Êý¾Ý¿â×Ö·û¼¯
| character_set_filesystem | binary |......
| character_set_results | utf8 |......
| character_set_server | utf8 |...... -- ·þÎñÆ÷×Ö·û¼¯
| character_set_system | utf8 |......
| character_sets_dir | D:\MySQL Server 5.0\share\charsets\ |......
+--------------------------+-------------------------------------+------
¶þ¡¢²é¿´ MySQL Êý¾Ý±í£¨table£© µÄ×Ö·û¼¯¡£
mysql> show table status from sqlstudy_db like '%countries%';
+-----------+--------+---------+------------+------+-----------------+------
| Name | Engine | Version | Row_format | Rows | Collation |......
+-----------+--------+---------+------------+------+-----------------+------
| countries | InnoDB | 10 | Compact | 11 | utf8_general_ci |......
+-----------+--------+---------+------------+------+-----------------+------
Èý¡¢²é¿´ MySQL Êý¾ÝÁУ¨column£©µÄ×Ö·û¼¯¡£
mysql> show full columns from countries;
+----------------------+-------------+-----------------+--------
| Field | Type | Collation
Ïà¹ØÎĵµ£º
1. mysql Èë¿âÂÒÂëÎÊÌâ
½â¾ö°ì·¨
Ê×ÏÈ °²×°µÄʱºò±ØÐëÑ¡Ôñutf-8×Ö·û¼¯
Èç¹û²»ÊÇ¿ÉÒÔ½øÐÐÔÙ´ÎÅäÖûòÕßÉèÖÃÏà¹Ø±äÁ¿
£¨¿ÉÒÔÓà SHOW VARIABLES LIKE %CHARACTER%; ²é¿´ Óà set CHARACTER_** = UTF8£©
Æä´ÎÁ¬½ÓµÄʱºò Ö¸¶¨×Ö·û¼¯
jdbc:mysql://localhost/guestbooktes ......
Ò»¡¢°²×°·þÎñÆ÷¶Ë
£¨1£©¡¢ÔÚÓÐÁ½¸örmpÎļþµÄĿ¼ÏÂÔËÐÐÈçÏÂÃüÁ
[root@test1 local]# rpm -ivh MySQL-server-5.0.26-0.i386.rpm
ÏÔʾÈçÏÂÐÅÏ¢£º
warning: MySQL-server-5.0.26-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing……¡¡¡¡¡¡¡¡¡¡¡¡¡¡##################################### ......
×÷Õߣº°½Ê¿Î°
·þÎñÆ÷£ºIBM X346
CPU:Intel Xeon 3.0 *4
Äڴ棺2GB
Ó²ÅÌ£ºRAID5
OS£ºwin2003 SE
Ò»¡¢MySQL 5.5 M2
MySQL ĬÈÏÒýÇæInnoDB£¬ÓÅ»¯Ç°ºó¼¸ºõÎÞ²î±ð
¶þ¡¢SQL SERVER 2000 SE
´ÓÕâû´Î²âÊÔ¿´£¬MysqlÔÚÊÂÎñÐÔÄܱíÏÖ²»ÈçSQL SERVER¡£Í¬Ê±£¬Á½ÕßÔÚĬÈÏÇé¿ö£¬ÅúÁ¿Insert£¬Mysql±íÏ ......
1.ͨ¹ýÐÞ¸ÄMYSQLÊý¾Ý¿âÖÐMYSQL¿âµÄUSER±í
¾ÍÓÃÆÕͨµÄUPDATE¡¢INSERTÓï¾ä¾Í¿ÉÒÔ
use mysql
update user set Password=password('newpassword') where User='root';
flush privileges;
£¨Õâ¸öÇ××ÔʵÑé¹ý£¬¿ÉÒÔÖ´ÐУ¡£©
2.ÔÚÃüÁîÐÐÖÐʹÓÃÈçÏÂÃüÁî
&nbs ......
<!--
/* Font Definitions */
@font-face
{font-family:ËÎÌå;
panose-1:2 1 6 0 3 1 1 1 1 1;
mso-font-alt:SimSun;
mso-font-charset:134;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:3 135135232 16 0 262145 0;}
@font-face
{font-family:"\@ËÎÌå" ......