MySQL Controlling the integrity of inserted data
1,554 views · Published 1 September 2013 · 7:23 · Indexed 15 October 2026
Channel: theurbanpenguin · 2013 · Education
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
More from this channel
-
8:44
Bash History Demo
-
8:39
A bash script to backup the MBR of all drives
-
9:40
Using SQUID to implement time restrictions . Captions Avaiable
-
6:24
Creating Desktop Shortcuts
-
8:58
Scripting Apache Virtual Hosts
-
5:25
Accessing The Linux Command Line
-
8:42
Managing Global Gnome Settings
-
2:40
NFSv4 Crossmnt Option