MySQL Add view

Sometimes a complex query needs to create a view that simplifies the query. We can also wrap the view as an object so that the query can be encapsulated directly in Java as an object.

The original table structure

To create a view statement:

Create View Danger_spot as SELECT d.dangerid,d.findtime,d.classtype,d.findperson,d.checkunit,d.address,d.content, D.dangergrade,d.type,d.unit,d.manager,d.dangerstatusnum,d.dangerstatus,d.dangerreport,s.hassafemeasure, S.disposemeasure,s.disposedate,s.disposeperson from ' danger '. ' Danger ' d,spotdispose s where D.dangerid = S.dangerid

Adds a piece of data to the spotdispose after inserting a piece of data into the danger table.

The system automatically refreshes the view.

Query view:

SELECT * from Danger_spot

MySQL Add view