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

mysqlѧϰ4

£­£­¶à±í²Ù×÷
   Ç°ÃæÎÒÃÇÊìϤÁËÊý¾Ý¿âºÍÊý¾Ý¿â±íµÄ»ù±¾²Ù×÷£¬ÏÖÔÚÎÒÃÇÔÙÀ´¿´¿´ÈçºÎ²Ù×÷¶à¸ö±í¡£
   ÔÚÒ»¸öÊý¾Ý¿âÖУ¬¿ÉÄÜ´æÔÚ¶à¸ö±í£¬ÕâЩ±í¶¼ÊÇÏ໥¹ØÁªµÄ¡£ÎÒÃǼÌÐøÊ¹ÓÃÇ°ÃæµÄÀý×Ó¡£Ç°Ã潨Á¢µÄ±íÖаüº¬ÁËÔ±¹¤µÄһЩ»ù±¾ÐÅÏ¢£¬ÈçÐÕÃû¡¢ÐԱ𡢳öÉúÈÕÆÚ¡¢³öÉúµØ¡£ÎÒÃÇÔÙ´´½¨Ò»¸ö±í£¬¸Ã±íÓÃÓÚÃèÊöÔ±¹¤Ëù·¢±íµÄÎÄÕ£¬ÄÚÈݰüÀ¨×÷ÕßÐÕÃû¡¢ÎÄÕ±êÌâ¡¢·¢±íÈÕÆÚ¡£
1¡¢²é¿´µÚÒ»¸ö±ímytableµÄÄÚÈÝ£º
mysql> select * from mytable;
+----------+------+------------+-----------+
| name    |   | birth    | birthaddr |
+----------+------+------------+-----------+
| abccs   |f    | 1977-07-07 | china    |
| mary    |f    | 1978-12-12 | usa     |
| tom    |m    | 1970-09-02 | usa     |
+----------+------+------------+-----------+
2¡¢´´½¨µÚ¶þ¸ö±ítitle£¨°üÀ¨×÷Õß¡¢ÎÄÕ±êÌâ¡¢·¢±íÈÕÆÚ£©:
mysql> create table title(writer varchar(20) not null,
   -> title varchar(40) not null,
   -> senddate date);
   Ïò¸Ã±íÖÐÌî¼Ó¼Ç¼£¬×îºó±íµÄÄÚÈÝÈçÏ£º
mysql> select * from title;
+--------+-------+------------+
| writer | title | senddate   |
+--------+-------+------------+
| abccs | a1   | 2000-01-23 |
| mary   | b1   | 1998-03-21 |
| abccs | a2   | 2000-12-04 |
| tom   | c1   | 1992-05-16 |
| tom   | c2   | 1999-12-12 |
+--------+-------+------------+
5 rows in set (0.00sec)
3¡¢¶à±í²éѯ
   ÏÖÔÚÎÒÃÇÓÐÁËÁ½¸ö±í: mytable ºÍ title¡£ÀûÓÃÕâÁ½¸ö±íÎÒÃÇ¿ÉÒÔ½øÐÐ×éºÏ²éѯ£º
ÀýÈçÎÒÃÇÒª²éѯ×÷ÕßabccsµÄÐÕÃû¡¢ÐÔ±ð¡¢ÎÄÕ£º
mysql> SELECT name,,title from mytable,title
   -> WHERE name=writer AND name='abccs';
+-------+------+-------+
| name |   | title |
+-------+------+-------+
| abccs | f   | a1   |


Ïà¹ØÎĵµ£º

linux mysqlµÄ°²×°¼°Ò»Ð©ÅäÖ÷½·¨

1.¼ì²éÒÔǰ°²×°µÄMySQL,Ð¶ÔØ¡£
rpm -qa|grep -i mysql
rpm -e XXXXX
×¢Èç¹û³öÏÖÁ½ÌõÏàͬµÄ£¬ÔòʹÓÃrpm -e --allmatches
2.°²×°rpm°ü¡£
rpm -ivh MySQL-server-community-5.1.37-0.rhel5.x86_64.rpm
rpm -ivh MySQL-shared-community-5.1.37-0.rhel5.x86_64.rpm
rpm -ivh MySQL-devel-community-5.1.37-0.rhel5.x86_6 ......

Oracle,MySQL,MSSQL ServerºÍAccessÊý¾Ý¿âµÄͳ¼Æº¯Êý

Oracle,MySQL,MSSQL ServerºÍAccessÊý¾Ý¿âµÄͳ¼Æº¯Êý
ÎÒÃÇÔÚ±à³ÌÖг£ÓõÄͳ¼Æº¯ÊýÓмÆÊý,ÇóºÍ,Çó×î´óÖµ,Çó×îСֵ,Ç󯽾ù,·½²îºÍ±ê×¼²î.
·½²î(Variance)
·½²îÊDZê׼ƫ²îµÄƽ·½¡£×éÖеÄÖµ£¬ÓëËüÃÇÆ½¾ùÖµÖ®¼äÆ«Àë³Ì¶ÈµÄ¶ÈÁ¿¡£
±ê׼ƫ²î(Standard Deviation)
Ò»¸ö²ÎÊý£¬Ö¸³öÒ»ÖÖ·½Ê½£¬Ò»¸ö¸ÅÂʺ¯ÊýÒÔÕâÖÖ·½Ê½·Ö²¼ÔÚÆ½¾ùÖµ¸ ......

c++µ÷ÓÃmysql½Ó¿ÚÒÔ¼°´æ´¢¹ý³Ì

      mysqlÔÚsdkÖÐΪcÓïÑÔÌṩÁËһЩ·ÃÎʽӿڣ¬ÎÒÃÇ¿ÉÒÔʹÓÃÕâЩ½Ó¿ÚÁ¬½Ó²¢·ÃÎÊmysqlÊý¾Ý¿â£¬µ±È»Ò²¿ÉÒÔµ÷ÓÃmysqlµÄ´æ´¢¹ý³Ì¡£
Àý×Ó£º
      Ê×ÏÈÏÂÔØmysqlµÄsdk£¬½âѹºÃÒÔºó£¬ÀïÃæ°üº¬Ò»¸öinclude,ºÍlibÎļþ¼Ð¡£ÎÒÃÇÔÚ×Ô¼ºµÄ¹¤³ÌÖаüº¬ÕâÁ½¸öÎļþ¼ÐµÄĿ¼£¬²¢Ç ......

UbuntuÏÂMySQL·þÎñ¹ÜÀí

²âÊÔ»·¾³£ºUbuntu 9.10 + MySQL 5.1.37-1ubuntu5
Ubuntu ÔÚÆô¶¯¹ÜÀí init.d
ÀïÃæ¹ØÓÚ MySQL µÄÃüÁîÓУº
/etc/init.d/mysql start|stop|restart|reload|force-reload|status
ÀýÈçÖØÆôMySQL·þÎñ£ºsudo /etc/init.d/mysql restart
......

ʹÓÃHibernate+MySql+native SQLµÄBUG,ÒÔ¼°½â¾ö°ì·¨

±¾À´ÊÇmssql+hibernate+native SQL Ó¦ÓõĺܺÍг
µ«Êǵ½Á˰Ñmssql»»³Émysql£¬¾Í³öÁË´í(ͬÑùµÄÊý¾Ý½á¹¹ºÍÊý¾Ý)¡£
²éѯ·½·¨ÊÇ£º
String sql =
"select id XXX_ID from t_tab";
List<Map> list = session.createSQLQuery(sql)
.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP)
.list();
´í ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ