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

SpringÅäÖÃmysqlÊý¾Ý¿â


<! -- beans ÔªËØÊÇSpringÅäÖÃÎļþµÄ¸ùÔªËØ£¬ËùÓеÄSpring µÄÅäÖÃÎļþ¶¼Ó¦°´ÈçϽṹÊéдһ¡µ
<beans>
<!Ò»ÅäÖÃid ΪdataSource µÄbean£¬¸Ãbean ÊǸöÊý¾ÝԴʵÀýÒ»¡µ
<bean ¹¤d="dataSource" class="org.apache.corrunons.dbcp.BasicDataSource"
destroy-method="close">
<! È·¶¨Êý¾ÝÔ´µÄÇý¶¯-->
<property name="driverClassName">
<value>com.mysql.jdbc.Driver</value>
</property>
<!-- È·¶¨Á¬½ÓÊý¾Ý¿âµÄurl -- >
<property name= "url " >
<!-- j2ee ÊÇÐèÒªÁ¬½ÓµÄÊý¾Ý¿âÃû-->
<value>jdbc:mysql://localhost:3306/j2ee</value>
</property>
<!--È·¶¨Á¬½ÓÊý¾Ý¿âµÄÓû§Ãû-->
<property name="username">
<! -- root ÊÇÁ¬½ÓÊý¾Ý¿âµÄÓû§Ãû-->
<value>root</value>
</property>
<!һȷ¶¨Á¬½ÓÊý¾Ý¿âµÄÃÜÂë>
<property name="password">
<!Ò»pass ÊÇÁ¬½ÓÊý¾Ý¿âµÄÃÜÂë…¡µ
<value>pass</value>
</property>
</bean>
</beans>


Ïà¹ØÎĵµ£º

mysql ±¸·ÝÁ·Ï°

<?php
$db_name="new";
mysql_connect("localhost","root","123456");
mysql_select_db($db_name);
$tb=mysql_list_tables($db_name);
$sql="";
while($query=mysql_fetch_row($tb)){
 $sql="";$table_sql="";
    $sql.= get_table_fn($query[0]);
    get_table_row($que ......

MYSQLÊý¾Ý¿âÓÅ»¯ÕªÂ¼

1¡¢Ñ¡È¡×îÊÊÓõÄ×Ö¶ÎÊôÐÔ
¡¡¡¡MySQL¿ÉÒԺܺõÄÖ§³Ö´óÊý¾ÝÁ¿µÄ´æÈ¡£¬µ«ÊÇÒ»°ã˵À´£¬Êý¾Ý¿âÖеıíԽС£¬ÔÚËüÉÏÃæÖ´ÐеIJéѯҲ¾Í»áÔ½¿ì¡£Òò´Ë£¬ÔÚ´´½¨±íµÄʱºò£¬ÎªÁË»ñµÃ¸üºÃµÄÐÔÄÜ£¬ÎÒÃÇ¿ÉÒÔ½«±íÖÐ×ֶεĿí¶ÈÉèµÃ¾¡¿ÉÄÜС¡£ÀýÈ磬ÔÚ¶¨ÒåÓÊÕþ±àÂëÕâ¸ö×Ö¶Îʱ£¬Èç¹û½«ÆäÉèÖÃΪCHAR(255),ÏÔÈ»¸øÊý¾Ý¿âÔö¼ÓÁ˲»±ØÒªµÄ¿Õ¼ä£¬ÉõÖÁʹ ......

¡¾×ª¡¿³£ÓÃmysql²Ù×÷ÃüÁî

   
Administration ¹ÜÀí
Kill a Thread  ½áÊøÒ»¸öÏß³Ì
mysql > KILL 999;
 
Optimize Table ÓÅ»¯±í
mysql > OPTIMEZE TABLE foo;
 
Reload Users Permissions Ë¢ÐÂMySQLϵͳȨÏÞÏà¹Ø±í  
mysql > FLUSH PRIVILEGES;
 
Repair Table ÐÞ¸´±í
mysql > ......

MySQL Cluster Configuration — Basic Example


To support MySQL Cluster, you will need to update
my.cnf
as shown in the following example.
You may also specify these parameters on the command line when
invoking the executables.

Note
The options shown here should not be confused with thos ......

MySqlµÄ±íÀàÐÍ

create database sample;
create table 't_user' (
    'id' int(11) not null auto_increment,
    'name' varchar(100) not null default '',
    primary key ('id')
) type=myisam;
Ñ¡ÏîÖ»ÔÚMySQL 3.23ºÍÒÔºó°æ±¾Öб»ÊµÏÖ¡£
²»Í¬µÄ±íÀàÐÍÊÇ£º
ISAM Ô­À´µÄ±í´¦ÀíÆ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ