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

mysqlµÄ°²×°ÎÊÌ⣬¾ßÌåÇë¿´´íÎóÈÕÖ¾£¬ÒѾ­À§ÈÅÎÒn¾ÃÁË

090929 18:14:02 [Note] Plugin 'FEDERATED' is disabled.
090929 18:14:02 [Note] Plugin 'InnoDB' is disabled.
D:\mysql5.1\bin\mysqld: Too many arguments (first extra is 'd:/mysql5.1/my.ini').
Use --verbose --help to get a list of available options
090929 18:14:02 [ERROR] Aborting

090929 18:14:02 [Warning] Forcing shutdown of 2 plugins
090929 18:14:02 [Note] D:\mysql5.1\bin\mysqld: Shutdown complete

ÔÚGoogleÉÏËÑmysqld: Too many arguments (first extra  my.ini
¾ÓÈ»µÚÒ»¸öÊÇmysqlÖ÷Ò³µÄbugÒ³Ãæ¡£´ó¸Å¿´ÁËÏ£¬²¢Ã»¸ø³ö½â¾ö°ì·¨£¬Ï£Íû¸ßÊÖ°ïæ
ÄãÊÇÈçºÎÆô¶¯µÄ£¿

ÁíÍâÌùÒ»ÄãµÄ my.ini ÎļþµÄÄÚÈÝ

ÊÔ¹ýn¸ö£¬Ò»¸öÊǸ´Öư²×°°æµÄmy.ini£¬È»ºó¸ÄÁËmysql·¾¶ºÍdata·¾¶¡£Ò»¸ö¸´ÖÆmy-small£¬Ò»¸ö¸´ÖÆmedium£¬½ÔÖ»ÐÞ¸ÄÁË·¾¶£¬¾ù±¨´Ë´í

ÄÇÄã¾ÍÖ±½ÓϸöZIP°æµÄMYSQL£¬UNZIPһϣ¬¾Í¿ÉÒÔÖ±½ÓÓÃÁË¡£

²»Ã÷°×ÄãʲôÒâ˼¡«
ÎÒÒªÖÆ×÷Ò»¸ömysqlÓëjavaµÄ¼¯³É°²×°°ü£¬ËùÒÔÖ»ÄÜͨ¹ýÅú´¦ÀíÀ´¶Ômysql½øÐа²×°¡£³öÏÖÁËÕâ¸öÎÊÌâÏÖÔÚºÜÉËÄÔ½î

ÏÖÔÚÓÐÁ½¸ö˼·¡£

1¡£ ÕÒ³öÄãÏÖÔÚµÄMYSQLϵͳΪʲôÎÞ·¨Æô¶¯¡£
          ÇëÌù³öÄãµÄmy.ini ÄÚÈÝ£¬È»ºó¸ù¾ÝÄãµÄmy.ini½øÐÐϲ½²½²âÊÔ¡£Õâ¸öÒѾ­ÒªÇó¹ýÒ»´Î£¬µ«ÄãºÃÏó²»·½±ãÌù³öÀ´¾ÍËãÁË¡£
2¡£ Ö±½ÓÓÃZIP°æ£¬È»ºó×ö¸öÆô¶¯¡£
          Õâ¸öÄã¿ÉÒÔÖ±½ÓʹÓã¬ÖÁÓÚÓû§¶Ë£¬Äã¿ÉÒÔͨ¹ýJAVAÔÚÓû§µÄWINDOWS×¢²á±íÖÐÌí¼ÓÒ»¸öMYSQLµÄ·þÎñ¡£

²»ºÃÒâ˼£¬ÏÖÔÚûÔÚ¹¤×÷µÄµØ·½£¬ËùÒÔµÃÃ÷Ìì²ÅÄÜÌù³ö


Ïà¹ØÎÊ´ð£º

MySqlÎÊÌâ

MySqlÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿
now()

SQL code:

sqlÀïÊÇ£º
getdate()

ÒýÓÃ
now()


ѧϰ

SQL code:
select now();

SQL code:
TODAY()
?

SQL code:
select now();
/* ......

mysql°²×°ÎÊÌâ unpacking of archive failed on¡£¡£

linuxϵͳ Ô­À´×Ô´ømysqlÒѾ­Ð¶ÔØ ÐÂװа汾 °²×°Ê±Ìáʾ unpacking of  archive  failed on file usr/bin/ replace 4acebledle4d:cpio :read ÇëÎÊÊÇʲôÎÊÌâ

ÒýÓÃ
ÎļþÊÇÖ»¶ÁµÄ ¸ü¸ÄϸÃĿ¼ȨÏÞΪ ......

MySQLÈ¡×Ö½Úº¯Êý

±¾ÈË´¿Êô³õѧMySQL£¬ÏÖÏë°ÑÒ»¸öOracleÉϵĴ洢¹ý³Ì¸Äµ½MySQLÉÏ£¬µ«ÊÇÆäÖÐÓÐÒ»¸ösubstrbµÄ×Ö·û´®°´Î»·µ»ØÖµº¯Êý²»ÖªµÀÓ¦¸ÃÔõô×öÁË£¿Ï£Íû¸÷λǰ±²ÃÇÖ¸µãСµÜÎÒһϣ¬²»Ê¤¸Ð¼¤°¢~~~

Àýaaa := 'dsadsa'; ......

MySQLÈëÃÅ

MySQLÈëÃÅ
¿ÉÒÔÏÈ¿´Ê²Ã´Êé¼®°¡£¿
ÏȶÁÈý±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ¡·,ÕÆÎÕÊý¾Ý¿âµÄ»ù´¡ÀíÂÛ¡£
È»ºóÔÙ´Ö¿´Ò»±éMYSQLµÄ¹Ù·½Îĵµ¡£ MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html

¾ÍÕÒÒ»±¾ºÜ»ù´ ......

MYSQLÐÂÊÖÎÊÌ⣬

SQL code:

--½¨Á¢ÁÙʱ±í£¬ÎÊÌâ1
create TEMPORARY table tmp_table(s1 int,s2 varchar(30))
--select * from tmp_table
--½¨Á¢ÁÙʱ±äÁ¿£¬ÎÊÌâ2
set @v=0;
--Ñ­»·Ö´ÐвåÈë²Ù×÷£¬ÎÊÌâ3
while @v<20 do
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ