MYSQL 常用功能 Indexes

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;