MySQL database (day6) index, ORM Framework

Reference blog:
Http://www.cnblogs.com/wupeiqi/articles/5713323.html
Http://www.cnblogs.com/wupeiqi/articles/5716963.html
Content review:

Reference Blog: http:www.cnblogs.com/wupeiqi/articles/5713323. HTML http:www.cnblogs.com/wupeiqi/articles/5716963. HTML Content review:1. What is a database2. MySQL installation3. User Authorization4. Database Operations-Data Sheet-Data Type-whether it is possible to empty-Self-increment-PRIMARY Key-FOREIGN Key-Unique index data row additions and deletions change sort: ORDER by desc/ASC Group: GROUP BY Condition: where hyphen table: Left JOIN                Right join INNER JOIN temp table: Wildcard paging: Limit Composition: Union view (Virtual equivalent temporary table) trigger (which is a function of each row) Select XX (f) Stored procedure -Cursors-Transactions-Result set +"return value" Pymysql-Connect to connect (...) -action (cursor)-Change and deleteCommit-SearchFetchone,fetchall-SQL injection-Call Stored procedure: Callproc ('P1', parameters) Select @_ stored procedure name _0-Close Cursors-Close Connection

View Code

MySQL database (day6) index, ORM Framework