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

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Ö»ÓпÕÎļþ

ÓÃjsp×ö¶«Î÷¸øÍêÈ«²»¶®mysqlµÄÈËÓ㬿ÉÊDZ¸·ÝʱֻÓпÕÎļþ£¬ÕâÊÇʲôÇé¿ö£¬
×îºÃÓÐÔ´´úÂ룬лл
Æäʵ±¸·ÝµÄ¹ý³ÌÎÒÏë´ó¸ÅÊÇÕâÑùµÄ£º
½«±íAÖеÄÊý¾Ý·Åµ½ArrayListÖУ¬È»ºó½«Õâ¸öArrayListÖеÄÊý¾ÝÔÙ´æµ½±íBÖС£ ......

MySQL´´½¨´æ´¢¹ý³Ì³ö´í

ÔÚ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 '' ......

oracle ¶ÔÓ¦µÄMySQLÓï¾ä

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Àï¿ÉÒÔ£¬µ«ÊÇÈ´² ......

mysqlÆô¶¯ºó¼ÓÔØʱ¼äÌ«³¤...

´ÓÆô¶¯µ½ÄÜÕý³£ÔËÐÐ,´ó¸ÅÒª15µ½20·ÖÖÓ×óÓÒ

ÏÖÏóÊÇ,Æô¶¯ÒÔºómysql½ø³ÌÔÚÈÎÎñ¹ÜÀíÆ÷ÀïÒѾ­¿ÉÒÔ¿´µ½ÁË,µ«ÊÇnetstat -anoûÓп´µ½Óнø³ÌÔÚ¼àÌý3306¶Ë¿Ú,ÉÏÃæÊý¾Ý¿â¶¼²»ÄÜ·ÃÎÊ
Ö±µ½15-20·ÖÖÓºó,ÄÜ¿´µ½mysqlÔÚ¼à ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ