mysql advanced (16) summary of frequently asked questions

mysqlAdvanced(六)Common Question Summary

MySQL View learning:

http://www.php.cn/

When performing a delete operation, the following appears Error message:

The reason for the above problem is that operations involving primary and foreign keys in the database should be set to cascade deletion when deleting them. As shown in the figure below:

When deleting data in the view, the following error message appears:

Solution: To delete the data in the view, you should actually delete the data in the base table. Only in this way can the data in the view be deleted.

Note: In fact, this is only done when directly completing the SQL command or manually adding object information. Only the default value of the field value will take effect. It should be possible to implement it in Java code, but you need to do some tricks when executing the SQL statement.

##MySQL

中BLOBField type introduction:

http://www.php.cn/

## The meaning of each character in

#MySQL

:

##MySQL

Multiple condition query statements in a single data table

：select * from table name where condition 1 and condition 2 and condition 3

The above is the summary of common questions in mysql advanced (sixteen), more related Please pay attention to the PHP Chinese website (www.php.cn) for content!