linux ÏÂmysql ÒÔrootºÍÆÕͨÓû§½øÈëmysqlµÄÎÊÌâ
×òÌì°²×°µÄ¡£
½ñÌìͻȻ·¢ÏÖÒÔÏÂÇé¿ö£º
ÎÒÒÔrootÓû§µÇ½ ½øÈëmysqlÐèÒªÊäÈëÃÜÂë
[root@localhost ~]# mysql -u root -p
Enter password:
ÒÔÆÕͨÓû§µÇ½ ½øÈëmysqlÖ»ÐèÒªÊäÈëmysql¾ÍÐÐÁË
[test@localhost bin]$ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 18 to server version: 5.0.20a-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
Ϊʲô°¡£¿ÕâÖÖÇé¿öÕý³£Âð£¿
ÊDz»ÊÇÒòΪÎÒÕâ¸öÆÕͨÓû§ÒѾÊôÓÚmysql×é²ÅÕâÑù£¿
ÎÊÌâÒѾ½â¾ö¡£À´È˽áÕ˸ø·Ö¡£
¾ßÌåÇé¿öÇë¿´£º
http://hi.baidu.com/loveyurui/blog/item/813ff7013b67557e3812bbc2.html
ÖкìÉ«²¹³ä²¿·Ö¡£
{{
Ïà¹ØÎÊ´ð£º
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it.
¿ ......
ÎÒÓÐÒ»¸öjava»·¾³ÏµijÌÐò£¬ÔÚ±¾»úÔËÐÐÕý³££¬µ«·¢²¼µ½ÍøµÄÐéÄâÖ÷»úʱ²»ÄÜÁ¬½ÓÊý¾Ý¿âÁ¬½Ó³Ø
jdk 1.6 tomcat6.0.18 mysql5 mysqljdbc5.1.5
ÐéÄâÖ÷»úµÄ¼¼ÊõÈËԱ˵£¬Ö»ÄÜÅäÖþÖÓòµÄÊý¾Ý¿âÁ¬½Ó³Ø£¬Ò²¾ÍÊÇÔÚM ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
SQL code:
create PROCEDURE aa(SqlCMD1 varchar(8000),SqlCMD2 varchar(8000),SqlCMD3 varchar(8000))
begin
declare exit handler for sqlexception rollback;
start TRANSACTION;
EXECUTE SqlCMD1;
EXE ......
ÈçÌ⣬MySQL²»»áÕâÑù°É
Ö§³Ö£¬Ä㽨Á¢Êý¾Ý¿âµÄʱºòÖ¸¶¨×Ö·û¼¯utf8»òÕßgbk¾ÍÐÐÁË¡£
http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL ÖÐÎÄÏÔʾÂÒÂë
Ö§³Ö£¬¼ì²é×Ö·û¼¯ÉèÖÃ
Ö§³Ö£¬¼ì² ......