xampp Óë mysql - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql
ÎÒÊDzËÄñ£¬ÎÊÎʸ÷λ¸ßÊÖ¡£
ÎÒµÄmysql rootÃÜÂëÊÇ root
×Ô´Ó°²×°ÁËxamppÖ®ºó£¬Ö±½ÓÔËÐÐMySQL Command Line Client ÊäÈëroot¾Í²»ÄܽøÈëmysql£¬¶ø¿ªÆôxamppÖ®ºó¾Í¿ÉÒÔ¡£²¢ÇҹرÕÁËxamppÖ®ºóÒ²¿ÉÒÔ½øÈëmysqlÁË¡£
Ò²¾ÍÊÇ˵£¬Ã¿´Î¿ª»úÎÒÔÚÔËÐÐmysql֮ǰ±ØÐëÏÈÔËÐÐÒ»´Îxampp¡£ÕâÊÇʲôµÀÀíÄØ£¿
ÄãµÄmysqlÓ¦¸ÃÊÇÓÉxamppÁ¬´øÆô¶¯µÄ.
¿ÉÄÜÊÇ£¬µ«ÊÇÎÒµÄmysql°²×°ÔÚxampp֮ǰ¡£
ÄÇôxampp¸Ä±äÁËmysqlµÄÉèÖá£Æñ²»ÊÇmysql¾Í²»°²È«¡£ÈκÎÈ˶¼¿ÉÒÔͨ¹ý°²×°xampp½øÈëÊý¾Ý¿â¡£
ÕâÑù×Ó£¿ÄÇ¿ÉÄÜÊÇxampp¸Ä¶¯ÁËmysqlµÄÆô¶¯²ÎÊý¡£
Äã´Ó·þÎñÁбíÀï¿´¿´mysql·þÎñµÄÆô¶¯²ÎÊý¡£¿´Ëü¶ÔÓ¦µÄÊÇÄĸöÅäÖÃÎļþ£¿
ÁíÍ⣬ÄãÍêÈ«¿ÉÒÔÊÖ¶¯Æô¶¯mysqlµÄ¡£Ö»ÒªÖªµÀmysqlµÄÅäÖÃÎļþµÄλÖ㨲»ÒªÅª´íÁË)
¶÷£¬Ð»Ð»¡£
{{
Ïà¹ØÎÊ´ð£º
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
ÇëÎÊ
Ìí¼ÓÐÂÊý¾ÝÔ´->Êý¾Ý¿â->Ìí¼ÓÁ¬½Ó
Õâ¸ö½çÃæÏ£¬Êý¾ÝÔ´Ñ¡Ôñ£ºMicrosoft SQL Server (SqlClient)£»
·þÎñÆ÷Ãû£º
Ó¦¸ÃÐ´Ê²Ã´ÄØ£¿
ÓÐËÖªµÀ£¿¶àл¸÷λ£¡£¡
Äãµ½µ×ÊÇÒªÁ¬mysql»¹ÊÇmssql£¿
ÒýÓÃ
ÇëÎÊ
......
3̨µçÄÔ£¬ÆäÖÐһ̨×÷ΪMYSQL·þÎñÆ÷£¬ÁíÍâ2̨ΪTOMCAT·þÎñÆ÷¡£
MYSQL·þÎñÆ÷ÀïÓÐÒ»Ìõ¼Ç¼£¬ IDΪ10.
ÏÖÔÚ2̨TOMCATͬʱ£¨100%£©·¢ÆðÐÞ¸ÄMYSQLÀïIDΪ10µÄÄÇÌõ¼Ç¼£¬±ÈÈçÐ޸ĴËID¼Ç¼ÀïijһÏîµÄÄÚÈÝ¡£ ±ÈÈçTOMCAT 1Ò ......
Java code:
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was51093 seconds ago.The last packet sent successfully to the server was 5 ......
¹òÇó½«ÒÔϺ¯Êý·ÒëΪ mysql µÄÓï·¨
CREATE FUNCTION workdayadd(
@date datetime, --»ù´¡ÈÕÆÚ
@workday int --ÒªÔö¼ÓµÄ¹¤×÷ÈÕÊý
)RETURNS datetime
AS
BEGIN
DEC ......