Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

mysql ʱ¼äµÄ´¦Àí

TO_DAYS(date)   //¸ø¶¨Ò»¸öÈÕÆÚ£¬·µ»Ø´Ó0Ä꿪ʼµÄÌìÊý¡£
from_DAYS(N)   //¸ø¶¨Ò»¸öÌìÊý£¬·µ»ØÒ»¸öÈÕÆÚ¡£
È磺
select TO_DAYS('1997-10-7')   //·µ»Ø729669
select from_DAYS(729669)    //·µ»Ø1997-10-7
UNIX_TIMESTAMP(), UNIX_TIMESTAMP(date)
ÈôÎÞ²ÎÊýµ÷Óã¬Ôò·µ»ØÒ»¸ö Unix timestamp ('1970-01-01 00:00:00' GMT Ö®ºóµÄÃëÊý) ×÷ΪÎÞ·ûºÅÕûÊý¡£ÈôÓÃdate À´µ÷Óà UNIX_TIMESTAMP()£¬Ëü»á½«²ÎÊýÖµÒÔ'1970-01-01 00:00:00' GMTºóµÄÃëÊýµÄÐÎʽ·µ»Ø¡£date ¿ÉÒÔÊÇÒ»¸ö DATE ×Ö·û´®¡¢Ò»¸ö DATETIME×Ö·û´®¡¢Ò»¸ö TIMESTAMP»òÒ»¸öµ±µØʱ¼äµÄYYMMDD »òYYYMMDD¸ñʽµÄÊý×Ö¡£
mysql> Select UNIX_TIMESTAMP();
-> 882226357
mysql> Select UNIX_TIMESTAMP('1997-10-04 22:23:00');
-> 875996580
´ý¿´...........


Ïà¹ØÎĵµ£º

mysqlÇý¶¯Ñо¿Ö®Í¨ÓÃÊý¾Ýת·¢Æ÷

   Õâ¶Îʱ¼äÔÚѧϰC#,ÒªÁ¬½ÓmysqlÊý¾Ý¿â,²»ÖªµÀÔõôÁ¬½Ó ,ºóÀ´gooleÁËÏÂ,·¢ÏÖÒªÏÂÔØÇý¶¯,˳±ã¿´ÁËÏÂÁ¬½ÓµÄexample code
  ´úÂëºÍjavaÀïÃæµÄ²îºÜ¶à,֮ǰһֱÔÚѧC++ Ҳѧ¹ýÒ»¶Îʱ¼äµÄÇý¶¯¿ª·¢,Ò»ÌýmysqlÇý¶¯,ҲûÔÚÒâ, Çý¶¯ÔÚÐÄÀïÒ»Ö±¶¼ÊǺÜÄÑ
²¢ÇÒÈÝÒ×Ôì³ÉÀ¶ÆÁ,Êý¾Ý½á¹¹¸´ÔӵĴúÃû´Ê,Ò²¾ÍûÔÚÒâ,µ«ÊǺóÀ´Ô ......

MySQL°²×°ÓëÓ¦Óá¾LinuxϵݲװÓëÅäÖá¿

LinuxϵݲװÓëÅäÖÃ
Èç¹ûËù°²×°µÄLinuxϵͳûÓÐÄÚÖõÄMySQL£¬±ÊÕß½¨ÒéÔÚLinuxÖÐʹÓÃRPM°üÀ´°²×°MySQL£¬Í¬ÑùÕâÒ²ÊÇMySQL¹Ù·½ÌṩµÄ½¨Òé¡£±ÊÕß½Ó´¥×î¶àµÄLinuxϵͳÊÇRadhatµÄ“½üÇ×”£ºCentOS£¬ÓÉÓÚCentOS½Ïеİ汾¶¼ÄÚÖÃÁËMySQL£¬Òò´ËÔÚ°²×°ÏµÍ³Ê±¾Í½«MySQL°²×°²¢×¢²áΪϵͳ·þÎñ£¬Ê¡È¥Á˲»ÉÙ¹¤×÷Á¿£¬´Ë´¦Ò²¾Í²» ......

ÈçºÎ²é¿´mysqlÔËÐС¢·ÃÎʼǼµÈÈÕÖ¾


1.Ê×ÏÈÈ·ÈÏÄãÈÕÖ¾ÊÇ·ñÆôÓÃÁË
mysql>show variables like 'log_bin';
mysql>show variables like 'log';
2.Èç¹ûÆôÓÃÁË£¬¼´ON
Èç¹ûûÓÐÆôÓ㬼´OFF£¬
ÒªÐÞ¸Ämy.cnf
  
  #   The   MySQL   server   
  [mysqld]   
    
  # ......

MysqlË÷Òý

MySQLË÷Òý¼ò½é... 1
Ò»¡¢Ë÷Òý·Öµ¥ÁÐË÷ÒýºÍ×éºÏË÷Òý…………………………………………………………………………………&hel ......

CÓïÑÔÁ¬½ÓMySQLÖÐÎÄÎÊÌâ

ÔÚѧϰ£¼Linux³ÌÐòÉè¼Æ£¾µÚ8ÕÂMySQLÊý¾Ý¿â8.3½Ú£º
ʹÓÃCÓïÑÔ·ÃÎÊMySQL·ÃÎÊÊý¾Ý¿âʱ³¢ÊÔ°ÑSQLÊý¾Ý»»³ÉÁËÖÐÎÄ£¬µ«ÊÇÔÚÔËÐÐʾÀý³ÌÐòʱÖÕ¶ËÊä³öÈ´ÂÒÂ룬MySQL C ÓïÑÔÁ¬½ÓĬÈÏ×Ö·û¼¯ÊÇlatin1
²éÁËÏÂAPIÕÒµ½ÈçϺ¯Êý¿É½â¾öÖÐÎÄÂÒÂëÎÊÌâ¡£
int
mysql_set_character_set(
MYSQL *
mysql,
char
*
csname)
ÃèÊö
¸Ãº¯ÊýÓ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ