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() ??? Ï£Íû´ó¼ÒÓ»Ô¾·¢ÑÔ£¬ÎÒ¶¥ÏÈ
Ïà¹ØÎÊ´ð£º
×ö¸öÕ¾ÄÚËÑË÷£¬ÏÖÔÚÓÃlike ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£ µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿ µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......
ϵͳµÄʼþ²é¿´Æ÷ÖпÉÒÔ¿´µ½Å¶ ÔØ£ºTable 'mysql.host' doesn't existµÄ´íÎó »¹ÊDz»Äܽâ¾öÎÊÌ⠲ο¼ÈçÏ indowsÏÂÐÞ¸ÄMySQL°²×°Ä¿Â¼ºÍMySQLÊý¾ÝĿ¼ 2009-04-04 08:49:20 ¡¡± ......
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Àï¿ÉÒÔ£¬µ«ÊÇÈ´² ......
ÔÚdocÏÂÖ´Ðе¼ÈëÃüÁî mysql -uadmin -padmin student < d:\a.txt ʱÌáʾϵͳÕÒ²»µ½Îļþ£¬»·¾³±äÁ¿¶¼ÉèÖöÔÁ˰¡£¬Ö®Ç°Ò²Ã»ÓгöÏÖ¹ýÕâ¸ö´íÎó£¬Çë´ó¼Ò°ïæ½â¾öÏ£¡Ð»ÁË£¡£¡ mysql -uadmin -padmin st ......