mysql×Ö·û¼¯Ð£Ñé¹æÔò
mysql×Ö·û¼¯Ð£Ñé¹æÔò
mysql ²»Í¬ÓÚÆäËûÊý¾Ý¿â£¨Èçoracle£©£¬Ëü¿ÉÒÔÔÚ¶à¸ö¼¶±ðÉèÖÃ×Ö·û¼¯ºÍУÑé¹æÔò£¬Èçserver¼¶±ð¡¢database¼¶±ð¡¢table¼¶±ðºÍcolumn¼¶±ð¡£Êµ¼ÊÉÏ£¬ÎÒÃÇÉõÖÁ»¹¿ÉÒÔµ¥¶À¶ÔÒ»´®×Ö·û´®É趨Æä×Ö·û¼¯ºÍУÑé¹æÔò£¬»¹¿ÉÒÔÔÚÁ¬½ÓÖÐÉèÖÃÆä×Ö·û¼¯ºÍУÑé¹æÔò£¬ÏÂÃæÀ´¼òµ¥µÄÌÖÂÛÏÂÇ°4ÖÖ¼¶±ðµÄ×Ö·û¼¯ºÍУÑé¹æÔòµÄÉèÖá£
server
ÔÚÆô¶¯mysql·þÎñµÄʱºò£¬¿ÉÒÔÖ¸¶¨mysql serverµÄ×Ö·û¼¯ºÍУÑé¹æÔò£¬Í¨¹ýÈçÏ·½Ê½£º
mysqld --character-set-server=latin1 --collation-server=latin1_swedish_ci
Èç¹û²»Ç××ÔÖ¸¶¨ËüÃÇ£¬ÄÇômysql¾Í»áʹÓÃĬÈÏÖµ¡£Ò»°ãÊÇlatin1ºÍlatin1_swedish_ci¡£µ±È»Õâ¸öĬÈÏÖµÊÇ¿ÉÒÔÐ޸ĵģ¬µ«ÊÇ·½·¨Ö»ÓÐÒ»ÖÖ£¬ÄǾÍÊÇÖرàÒëÔ´´úÂë¡£²ÉÓÃÈçÏ·½Ê½£º
./configure --with-charset=gbk --with-collation=gbk_bin
ÈçºÎ²éѯµ±Ç°µÄserverµÄ×Ö·û¼¯ºÍУÑé¹æÔòµÄÖµ£¬¿ÉÒԲ鿴ϵͳ²ÎÊýcharacter_set_serverºÍcollation_server£º
mysql> show variables like 'character_set_server%';
+----------------------+--------+
| Variable_name | Value |
+----------------------+--------+
| character_set_server | latin1 |
+----------------------+--------+
1 row in set (0.00 sec)
mysql> show variables like 'collation_server%';
+------------------+-------------------+
| Variable_name | Value |
+------------------+-------------------+
| collation_server | latin1_swedish_ci |
+------------------+-------------------+
1 row in set (0.00 sec)
serverµÄ×Ö
Ïà¹ØÎĵµ£º
ÔÚÖ÷Íâ¼ü±í´æÔÚ¹ØϵµÄʱºòÈç¹û¼ÓÉÏ"lazy=true"µÄ»°£¬Ôò±íÃ÷ÑÓ³Ù£¬¼´Ö»²éѯÖ÷±íÖеÄÄÚÈÝ£¬¶ø²»²éѯÍâ¼ü±íÖеÄÄÚÈÝ¡£
Àý£º
<hibernate-mapping>
<class name="com.pojo.Sortp" table="sortp" catalog="shjdc">
<id name="id" type= ......
TIMESTAMPÁÐÀàÐÍÌṩһÖÖÀàÐÍ£¬Äã¿ÉÒÔʹÓÃËü×Ô¶¯µØÓõ±Ç°µÄÈÕÆÚºÍʱ¼ä±ê¼ÇINSERT»òUPDATEµÄ²Ù×÷¡£Èç¹ûÄãÓжà¸öTIMESTAMPÁУ¬Ö»ÓеÚÒ»¸ö×Ô¶¯¸üС£
×Ô¶¯¸üеÚÒ»¸öTIMESTAMPÁÐÔÚÏÂÁÐÈκÎÌõ¼þÏ·¢Éú£º
ÁÐûÓÐÃ÷È·µØÔÚÒ»¸öINSERT»òLOAD DATA INFILEÓï¾äÖÐÖ¸¶¨¡£
ÁÐûÓÐÃ÷È·µØÔÚÒ ......
Ò»:mysqlÀïÄ¿Ç°Ö»Ö§³Ö4ÖÖË÷Òý·Ö±ðÊÇ:b-tree,full-text,hashÒÔ¼°r-treeË÷Òý b-treeË÷ÒýÓ¦¸ÃÊÇmysqlÀï×î¹ã·ºµÄË÷ÒýµÄÁË,³ýÁËarchive,»ù±¾ËùÓеĴ洢ÒýÇ涼֧³ÖËü. 1.b-treeÔÚmyisamÀïµÄÐÎʽºÍinnodbÉÔÓв»Í¬ ÔÚinnodbÀïÃæÓÐÁ½ÖÖÐÎ̬:ÆäÒ»ÊÇprimary keyÐÎ̬Æäleaf nodeÀï´æ·ÅµÄÊÇÊý¾Ý.¶øÇÒ²»½ö´æ·ÅÁËË÷Òý¼üµÄÊý¾Ý,»¹´æ·ÅÁËÆ ......
1.ÉèÖñäÁ¿
set @x = 2;
»ò:
select @x := max(fields) as max from table;
2.Éú³Éhtml»òxml
mysql -H -uroot -p databaseName Éú³ÉhtmlÎļþ
mysql -x -uroot -p databaseNam ......
MysqlÊý¾Ý¿âÌṩÁ½ÖÖÀàÐ͵ÄË÷Òý£¬Èç¹ûûÕýÈ·ÉèÖã¬Ë÷ÒýµÄÀûÓÃЧÂÊ»á´ó´òÕÛ¿ÛÈ´ÍêÈ«²»ÖªÎÊÌâ³öÔÚÕâ¡£
CREATE TABLE test (
id INT NOT NULL,
last_name CHAR(30) NOT NULL,
first_name CHAR(30) NOT NULL,
PRIMARY KEY (id),
INDEX name (last_name,first_name)
);
ÒÔÉÏ´ ......