MySQL (ii)

Introduction: Database-related operations

1.SQL Statement * * * * (MYSQL (a) already introduced ) Operational database;

2. Operate the database using the functions provided within MySQL ( views, triggers, functions, stored procedures );

First, the view: the frequently used query results, make the view chart preservation convenient reuse;

1. Create a view:

CREATE VIEW Zhanggen as SELECT * from score;

2. View View:

SELECT * from en;

3. Delete View

Drop View en

Second, trigger when to a table do: adding or deleting the operation, you can use the trigger to customize the association behavior;

Three, function four, stored procedure 1. Simple 2. Parameter (in,out,inout) 3. Parameter Out4. Transaction 5. Cursor 6. Dynamic execution of SQL (anti-SQL injection)

MySQL (ii)