MYSQL 常用功能 Indexes

q9989

　　1. Executing SQL Statements from a Text File

    
http://dev.mysql.com/doc/refman/5.1/en/batch-commands.html



　　

　　2. Using MySQL in batch Mode\

　　
http://dev.mysql.com/doc/refman/5.1/en/batch-mode.html

　　
　　3. Data-and-time types


    http://dev.mysql.com/doc/refman/5.1/en/date-and-time-types.html

　　
Datatime



　　http://dev.mysql.com/doc/refman/5.1/en/datetime.html

　　Current time/Current Timestamp/Current Date/

　　http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_current-date


　　    Example
:
   


INSERT INTO HAODAO.USER (ID, USERNAME, PASSWORD, ROLE, EMAIL, REGISTRYTIME) VALUES (1000, 'expressTestor', 'expressTestor', 'expressor', 'comedshang@gmail.com', now() )
 　　
4. Database and Schema

    
Database is synonym with the Schema. 
    http://dev.mysql.com/doc/refman/5.0/en/create-database.html
 

    Example,

SELECT * FROM MYTEST.USER U
INNER JOIN TEST.SCORE S ON U.ID = S.USERID;