Student Reviews
( 5 Of 5 )
1 review
Video of MySQL Controlling the integrity of inserted data in Apache HTTP Server course by theurbanpenguin channel, video No. 13 free certified online
More videos like this online at http://www.theurbanpenguin.com
We have seen that id data is too large for the specified data type MySQL can adjust the value to within the acceptable range. This though may not suit your data integrity rules and you may prefer the server simply to error on errors rather than trying to help you out. Using the sql_mode variable we can see that setting the value STRICT_ALL_TABLES will ensure that data has to meet the requirements of the the data type. Setting the /etc/my.cnf we can ensure that this becomes the default value used on the server