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

MySQLÔÓ

MySQLµÄtimestampÀàÐÍ×Ô¶¯¸üÐÂÎÊÌâ
 ½ñÌ콨ÁËÒ»¸ö±í£¬ÀïÃæÓÐÒ»¸öÁÐÊÇtimestampÀàÐÍ£¬ÎÒ±¾ÒâÊÇÔÚÊý¾Ý¸üÐÂʱ£¬Õâ¸ö×ֶεÄʱ¼äÄÜ×Ô¶¯¸üС£ÆñÖª¶ÔÕâ¸öÀàÐ͵ÄÖµ»¹²»ÉõÁ˽⣬µ¼Ö³ö´í¡£·¢ÏÖÕâ¸ö×Ö¶ÎÖ»ÊÇÔÚÕâÐÐÊý¾Ý½¨Á¢µÄʱºòÓÐÖµ£¬ÔÚ¸üеÄÈ´Îޱ仯¡£
    ²éÕÒ×ÊÁÏ£¬·¢ÏÖÊÇÎÒ½¨±íµÄÓï¾äÓÐÎÊÌ⣺
ÒÔÏÂÊÇ´úÂëÆ¬¶Î£º
CREATE TABLE `test` (
  `t1` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `ww` varchar(5) NOT NULL
) ENGINE=MyISAM ;
    ¶øÊµ¼ÊÉÏ£¬ÒÔÏÂÁ½¸ö½¨±íÓï¾äµÄЧ¹ûÊÇÒ»ÑùµÄ£º
ÒÔÏÂÊÇ´úÂëÆ¬¶Î£º
CREATE TABLE `test` (
`t1` TIMESTAMP NOT NULL ,
`ww` VARCHAR( 5 ) NOT NULL
) ENGINE = MYISAMCREATE TABLE `test` (
  `t1` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `ww` varchar(5) NOT NULL
) ENGINE=MyISAM ;
    ±È½Ï֮ϣ¬ÎÒµÄÓï¾äÉÙÁË“on update CURRENT_TIMESTAMP”»ò¶àÁË“default CURRENT_TIMESTAMP”¡£Èç´ËÒ»À´£¬Õâ¸ötimestamp×Ö¶ÎÖ»ÊÇÔÚÊý¾ÝinsertµÄʱ¼ä½¨Á¢Ê±¼ä£¬¶øupdateʱ¾Í²»»áÓб仯ÁË¡£µ±È»£¬Èç¹ûÄã¾ÍÊÇÏë´ïµ½Õâ¸öÄ¿µÄµ¹Ò²ÎÞËùν¡£
    ²éÕÒÓ¢ÎÄÊֲᣨhttp://dev.mysql.com/doc/refman/5.1/en/timestamp.html£©£¬µÃµ½¸üÏêϸµÄ½â˵£¬·­ÒëÈçÏ£º
———————————–·­Ò뿪ʼ——————————–
    ÔÚCREATE TABLEÓï¾äÖУ¬µÚ1¸öTIMESTAMPÁпÉÒÔÓÃÏÂÃæµÄÈκÎÒ»ÖÖ·½Ê½ÉùÃ÷£º
    1£º Èç¹û¶¨ÒåʱDEFAULT CURRENT_TIMESTAMPºÍON UPDATE CURRENT_TIMESTAMP×Ӿ䶼ÓУ¬ÁÐֵΪĬÈÏʹÓõ±Ç°µÄʱ¼ä´Á£¬²¢ÇÒ×Ô¶¯¸üС£
    2£º Èç¹û²»Ê¹ÓÃDEFAULT»òON UPDATE×Ӿ䣬ÄÇôËüµÈͬÓÚDEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP¡£
    3£º Èç¹ûÖ»ÓÐDEFAULT CURRENT_TIMESTAMP×Ӿ䣬¶øÃ»ÓÐON UPDATE×Ӿ䣬ÁÐֵĬÈÏΪµ±Ç°Ê±¼ä´Áµ«²»×Ô¶¯¸üС£
    4£º Èç¹ûûÓÃDEFAULT×Ӿ䣬µ«ÓÐON UPDATE CURRENT_TIMESTAMP×Ӿ䣬ÁÐĬÈÏΪ0²¢×Ô¶¯¸üС£
    5£º Èç¹ûÓÐÒ»¸ö³£Á¿ÖµDEFAULT£¬¸ÃÁлáÓÐÒ»¸öĬÈÏÖ


Ïà¹ØÎĵµ£º

ËÄÖÖÔÚMySQLÖÐÐÞ¸ÄrootÃÜÂëµÄ·½·¨

 <>ÕûÀíÁËÒÔÏÂËÄÖÖÔÚMySQLÖÐÐÞ¸ÄrootÃÜÂëµÄ·½·¨,¿ÉÄܶԴó¼ÒÓÐËù°ïÖú!
·½·¨1£º ÓÃSET PASSWORDÃüÁî
¡¡¡¡mysql -u root
¡¡¡¡mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpass');
·½·¨2£ºÓÃmysqladmin
 
¡¡¡¡mysqladmin -u root password "newpass"
¡¡¡¡Èç¹ûrootÒѾ­ÉèÖà ......

UbuntuÏÂmysqlÐÞ¸Ä×Ö·û¼¯

Ê×ÏÈÍ£Ö¹MySQL·þÎñ£ºsudo /etc/init.d/mysql stop
È»ºó±à¼­MySQLÅäÖÃÎļþ£ºsudo gedit /etc/mysql/my.cnf
ÔÚmy.cnfÎļþÖеÄ[client]¶ÎÏÂÃæ¼ÓÈë
default-character-set=utf8
[mysqld_safe]
default-character-set=utf8
[mysqld]
default-character-set=utf8
[mysql]
default-character-set=utf8
ÖØÐÂÆô¶¯MySQL·þÎñ ......

LinuxÖв鿴ºÍÉèÖÃMySQLÊý¾Ý¿â×Ö·û¼¯(ת)

6
¡¢ÐÞ¸ÄÊý¾Ý¿âµÄ×Ö·û¼¯
mysql>use mydb
mysql>alter database mydb character set utf-8;
 
6
¡¢´´½¨Êý¾Ý¿âÖ¸¶¨Êý¾Ý¿âµÄ×Ö·û¼¯
mysql>create database mydb character set utf-8;
ͨ¹ýÅäÖÃÎļþÉèÖô´½¨Êý¾Ý¿âʱ×Ö·û¼¯:
#vi /var/lib/mysql/mydb/db.opt
default-character-set=latin1
default-col ......

Java ¶ÁÈ¡ MySQL ÖÐÎÄ ÂÒÂë

Java ¶ÁÈ¡ MySQL ÖÐÎÄ ÂÒÂë
³¡¾°:Java,eclipse£¬¶ÁÈ¡MySQLÊý¾Ý¿â£¬MySQL±àÂëΪutf-8
ÎÊÌ⣺¶Á³öÀ´µÄÖÐÎÄÔÚeclipseµÄÊä³ö´°¿ÚÖÐÏÔʾΪÂÒÂë
´íÎóµÄд·¨
1
   System.out.print(new String( rs.getString("bib_author").getBytes("utf-8"),"GBK" )); 

   System.out.print( ......

mysql µÄ×Ö·û±àÂë

 === ÉÔºóÔÙÕûÀí
mysql
4.0µ½mysql
5.0µÄÊý¾Ýµ¼Èë³öÏÖÂÒÂëµÄ½â¾ö·½°¸
×ÖÌå´óС£º´ó
| ÖÐ
| С
2007-02-08 17:09 -
ÔĶÁ£º485 - ÆÀÂÛ
£º0
×î½ü×ömysql
4.0µ½mysql
5.0µÄÊý¾Ýת»¯¹¤×÷£¬·¢ÏÖÂÒÂë
ÎÞÊý£¬¹Û²©¿ÍÎÞÊýÐĵÃÈçÏ£º
£ªmysql
ÖÐÎÄ亂碼µÄÔ­Òò
mysql
會³ö現ÖÐÎÄ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ