[½»Á÷] ѧϰMySQL³£ÓòÙ×÷ÃüÁî

£ mysql> select 

-> USER() 

-> , 

-> now() 

->; 

+--------------------+---------------------+ 

| USER() | now() | 

+--------------------+---------------------+ 

| ODBC@localhost | 2001-05-17 22:59:15 | 

+--------------------+---------------------+ 

1 row in set (0.06 sec) 

mysql> 







 £  ×¢ÒâÖмäµÄ¶ººÅºÍ×îºóµÄ·ÖºÅµÄʹÓ÷½·¨¡£ 



 £  6¡¢Ò»ÐжàÃüÁî 



 £  ÊäÈëÈçÏÂÃüÁ 



mysql> SELECT USER(); SELECT NOW(); 

+------------------+ 

| USER() | 

+------------------+ 

| ODBC@localhost | 

+------------------+ 

1 row in set (0.00 sec) 



+---------------------+ 

| NOW() | 

+---------------------+ 

| 2001-05-17 23:06:15 | 

+---------------------+ 

1 row in set (0.00 sec) 

mysql> 







 £  ×¢ÒâÖмäµÄ·ÖºÅ£¬ÃüÁîÖ®¼äÓ÷ֺŸô¿ª¡£ 



 £  7¡¢ÏÔʾµ±Ç°´æÔÚµÄÊý¾Ý¿â 



mysql> show databases; 

+----------+ 

| Database | 

+----------+ 

| mysql | 

| test | 

+----------+ 

2 row in set (0.06 sec) 

mysql> 







 £  8¡¢Ñ¡ÔñÊý¾Ý¿â²¢ÏÔʾµ±Ç°Ñ¡ÔñµÄÊý¾Ý¿â 



mysql> USE mysql 

Database changed 

mysql> 

(USE ºÍ QUIT ÃüÁî²»ÐèÒª·ÖºÅ½áÊø¡££© 

mysql> select database(); 

+---------------+ 

| database() | 

+---------------+ 

| mysql | 

+---------------+ 

1 row in set (0.00 sec) 

 9¡¢ÏÔʾµ±Ç°Êý¾Ý¿âÖдæÔڵıí 

 £  mysql> SHOW TABLES; 



 £  10¡¢ÏÔʾ±í(db)µÄÄÚÈÝ 

mysql>select * from db; 



 £  11¡¢ÃüÁîµÄÈ¡Ïû 



 £  µ±ÃüÁîÊäÈë´íÎó¶øÓÖÎÞ·¨¸Ä±ä£¨¶àÐÐÓï¾äÇéÐΣ©Ê±£¬Ö»ÒªÔڷֺųöÏÖÇ°¾Í¿ÉÒÔÓà cÀ´È¡Ïû¸ÃÌõÃüÁî 



mysql> select 

-> user() 

-> c 

mysql> 







 £  ÕâÊÇһЩ×î³£ÓõÄ×î»ù±¾µÄ²Ù×÷ÃüÁͨ¹ý¶à´ÎÁ·Ï°¾Í¿ÉÒÔÀÎÀÎÕÆÎæÁË¡£



[ Last edited by »ÃÓ°ÎÞºÛ on 2006-11-13 at 08:01 ]