MySqlÎÊÌâ
MySqlÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿
now() SQL code: sqlÀïÊÇ£º getdate()ÒýÓà now() ѧϰ SQL code: select now(); SQL code: TODAY() ? SQL code: select now(); /** now() ------------------- 2009-09-29 14:16:39 **/ select current_date(); /** current_date() -------------- 2009-09-29 **/ jintian() ??? Ï£Íû´ó¼ÒÓ»Ô¾·¢ÑÔ£¬ÎÒ¶¥ÏÈ
Ïà¹ØÎÊ´ð£º
ÓÃjsp×ö¶«Î÷¸øÍêÈ«²»¶®mysqlµÄÈËÓ㬿ÉÊDZ¸·ÝʱֻÓпÕÎļþ£¬ÕâÊÇʲôÇé¿ö£¬ ×îºÃÓÐÔ´´úÂ룬лл Æäʵ±¸·ÝµÄ¹ý³ÌÎÒÏë´ó¸ÅÊÇÕâÑùµÄ£º ½«±íAÖеÄÊý¾Ý·Åµ½ArrayListÖУ¬È»ºó½«Õâ¸öArrayListÖеÄÊý¾ÝÔÙ´æµ½±íBÖС£ ......
ÔÚMySQL5.0Öд¬½¢´æ´¢¹ý³Ìͨ²»¹ý£¬Ìáʾ£º [Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' ......
orcle Óï¾ä create table book1(name, price) as select book_name, price form book; ¶ÔÓ¦µÄMySQLµÄÓï¾äÊÇʲô create table book1 as select book_name, price form book; ÕâÑùÔÚMySQLÀï¿ÉÒÔ£¬µ«ÊÇÈ´² ......
´ÓÆô¶¯µ½ÄÜÕý³£ÔËÐÐ,´ó¸ÅÒª15µ½20·ÖÖÓ×óÓÒ ÏÖÏóÊÇ,Æô¶¯ÒÔºómysql½ø³ÌÔÚÈÎÎñ¹ÜÀíÆ÷ÀïÒѾ¿ÉÒÔ¿´µ½ÁË,µ«ÊÇnetstat -anoûÓп´µ½Óнø³ÌÔÚ¼àÌý3306¶Ë¿Ú,ÉÏÃæÊý¾Ý¿â¶¼²»ÄÜ·ÃÎÊ Ö±µ½15-20·ÖÖÓºó,ÄÜ¿´µ½mysqlÔÚ¼à ......