MySQL¿ª·¢Ð¡½á
×î½üÕýÔÚ½øÐÐÒ»¸ö¶þ´Î¿ª·¢½Ó¿ÚµÄÏîÄ¿£¬ÔÚ¿ª·¢¹ý³ÌÖз¢ÏÖ£ºÎÒÃÇ֮ǰʹÓõĴ¦Àí¿Í»§¶ËºÍWEBÖ®¼ä±àÂë¼æÈÝÎÊÌâµÄ·½·¨ÊÇ´æÔÚÎÊÌâµÄ¡£ÓÉÓÚΪÁËÖ§³Ö¶àÓïÑÔ£¬Êý¾Ý¿â±íÖÐÀàÐÍΪvarcharµÄ×ֶΣ¬ËûÃǵÄ×Ö·û¼¯¶¼ÉèÖóÉÁËutf8¡£Ö®Ç°µÄ×ö·¨Êǿͻ§¶Ë½«×Ö·û´®µÄ±àÂë¸Ä³Éutf8±àÂ룬Ȼºó½«¸Ãutf8±àÂëµÄ×Ö·û´®Ö±½ÓдÈëÊý¾Ý¿â£¬ÕâÑùWEB(ʹÓÃPHPÓïÑÔ¿ª·¢µÄ)¾ÍÖ»ÐèÒª¼òµ¥µÄÐ޸ľÍÄÜÖ§³Ö¶à¹úÓïÑÔ£¬²¢ÇÒ»¹ÄܺͿͻ§¶ËµÄ¶àÓïÑÔ¼æÈÝ¡£ÓÉÓÚÎÒÃǵijÌÐòÔÚÁ¬½ÓÊý¾Ý¿âʱ£¬Ê¹ÓõÄÊÇĬÈϵÄ×Ö·û¼¯(latin1)£¬ËùÒÔµ±ÎÒÃÇÖ±½Ó²é¿´Êý¾Ý¿â±íÖеÄÊý¾Ýʱ£¬¿´µ½µÄ¾ÍÊÇÃ²ËÆÂÒÂëµÄÊý¾Ý(Õâ¾ÍÊÇ´æÈë×Ö·û´®µÄutf8±àÂë)¡£µ«µ±Ê¹ÓÃASP.NET¿ª·¢WEBʱ£¬Í¬ÑùµÄ×ö·¨¾ÍÎÞЧÁË¡£²éÔÄMySQLÊÖ²áºó£¬²ÂÏëÉèÖÃÁ¬½ÓµÄ×Ö·û¼¯¿ÉÄÜ¿ÉÒÔ½â¾öÕâ¸öÎÊÌâ¡£¾²âÊÔ£¬È·Êµ¿ÉÐС£ÕâÀï×ܽáһϽâ¾ö·½·¨£º
1.¸ü¸ÄÁ¬½ÓµÄ×Ö·û¼¯µÄ·½·¨
MySQLÌṩÁËÁ½ÖÖ·½·¨À´¸ü¸ÄÁ¬½ÓµÄ×Ö·û¼¯£¬ÕâÁ½ÖÖ·½·¨·Ö±ðÊÇ£º
(1)SET NAMESÓï¾ä;
(2)APIº¯Êýmysql_set_character_set()
MySQLÊÖ²áÖн¨Òé×îºÃʹÓÃ(2)À´ÐÞ¸ÄÁ¬½ÓµÄ×Ö·û¼¯£¬ÒòΪ“Èç¹ûÐèÒª¸ü¸ÄÁ¬½ÓµÄ×Ö·û¼¯£¬Ó¦¸ÃʹÓÃmysql_set_character_setº¯Êý£¬¶ø²»ÊÇÖ´ÐÐSET NAMESÓï¾ä¡£mysql_set_character_setµÄ¹¤×÷·½Ê½ÀàËÆÓÚSET NAMES£¬µ«Ëü»¹ÄÜÓ°Ïìmysql_real_escape_stringËùʹÓõÄ×Ö·û¼¯£¬¶øSET NAMES²»ÄÜ¡£”
2.Ö´ÐÐmysql²åÈëÓï¾äʱ£¬·µ»Ø1366µÄ´íÎóµÄ½â¾ö°ì·¨
µ¼ÖÂÕâ¸öÎÊÌâµÄÔÒòÊÇ£ºµ±½«mysqlµÄÁ¬½ÓµÄ×Ö·û¼¯¸ÄΪutf8ºó£¬Èç¹û²åÈëÊý¾Ý¿â±íÖеÄ×Ö·û´®²»ÊÇutf8±àÂëµÄ´®£¬Ôò»á³öÏÖÕâ¸ö´íÎó¡£ÔÚ½«Á¬½Ó¸ü¸ÄΪutf8ºó£¬¶Á³öÀ´µÄ×Ö·û´®Êý¾ÝÒ²ÊÇutf8±àÂëµÄ¡£ËùÒÔÎÒÐèÒª½«×Ö·û´®ÔÚutf8ºÍansiÖ®¼äÏ໥ת»»£¬×ª»»µÄÖ÷Òª´úÂëÈçÏ£º
void AnsiToUtf8(const char* szAnsi, char* szUtf8, int nSize)
{
int nChar = MultiByteToWideChar(CP_ACP, 0, szAnsi, -1, NULL, 0);
if (nChar > 0)
{
wchar_t* pBufw = new wchar_t[nChar];
MultiByteToWideChar(CP_ACP, 0, szAnsi, -1, pBufw, nChar);
WideCharToMultiByte(CP_UTF8, 0, pBufw, -1, szUtf8, nSize, NULL, NULL);
delete[] pBufw;
}
}
void Utf8ToAnsi(const char* szUtf8, char* szAnsi, int nSize)
{
int nChar = MultiByteToWideChar(CP_UTF8, 0, szUtf8, -1, NULL, 0);
if (nChar > 0)
{
wchar_t* pBufw = new wchar_t[nChar];
MultiByteToWideChar(CP_UTF8,
Ïà¹ØÎĵµ£º
MYSQL×ÔÔöÁÐ
1.¹Ø¼ü×Ö £ºauto_increment
2.×ÔÔöÓ÷¨
Àý:
CREATE TABLE animals ( id mediumint not null auto_increment,
name char(30) not null,
primary key (id));
3.¹ØÓÚ×ÔÔö
Q:Ôõô»ñµÃµ±Ç°µÄ×ÔÔöµÄ×î´óÖµ?
A:select @@identity
Q:Ôõô»ñµÃtableµÄµ±Ç°×ÔÔö×î´óÖµ?
A:select max(id) from table ......
ÔÚ½üÆÚµÄÏîĿά»¤¹¤×÷ÖУ¬Ê±³£³öÏÖÖ÷¼üÖØ¸´µÄÒì³£¡£¾¹ýһϵÁÐ×ÊÁϵIJéѯ֮ºó£¬·¢ÏÖʱhibernateÓ³ÉäÎļþÅäÖÃÎÊÌâ¡£
mysqlÌṩÖ÷¼ü“×Ô¶¯ÔöÁ¿”µÄÅäÖã¬Ö¸¶¨¸ÃÀàÐ͵ÄÖ÷¼ü£¬mysqlÄܹ»×Ô¶¯¼ÓÒ»¡£
ÔÚhibernateÓ³ÉäÎļþÖУ¬¹ØÓÚÖ÷¼üµÄÅäÖò»ÄÜÊÇ
<generator class="increment"&g ......
µ±Ç°»îÔ¾µÄÊÂÎñ:
------------
TRANSACTIONS
------------
Trx id counter080157601
Purge done for trx's n:o <0 80154573 undo n:o <0 0
History list length 6
Total number of lock structs in row lock hash table 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0 0, not started, proce ......
×î½üÏëÔÚ·þÎñÆ÷ÉÏÊÔÊÔMySQL5.1µÄ·ÖÇø£¬ÓÚÊǾÍÏë×Å×°¸öMySQL5.1£¬¾¹ýÍ´¿àµÄÒ»¶Î¾Àúºó£¬ÖÕÓÚÕÒ¸öÏÂÃæ×°¸öºÜºÃµÄ½Ì³Ì£¬ÌûÉÏÀ´±¸Íü¡£
1¡¢MySQLÃâ°²×°°æ/¶þ½øÖưæÈí¼þ£¬²»ÓñàÒ룬ÏÂÔØµØÖ·£º
http://dev.mysql.com/downloads/
Îļþ¸ñʽ£ºMYSQL-VERSION-OS.tar.gz
2¡¢´ ......
1.±àдshell½Å±¾
vi /data/www/project_name/bin/mysql_backup.sh
#!/bin/bash
#This is a ShellScript For Auto DB Backup
#Powered by liuzheng
#ϵͳ±äÁ¿¶¨Òå
DBName=test
DBUser=root
DBPasswd=123456
BackupPath=/tmp/mysql_backup/
NewFile="$BackupPath"db$(date +%y%m%d ......