column datatype is not enforced
Posted by:
Shirley Lee
Date: September 06, 2013 04:33PM
I was concerned and wanted to make sure that datatype and integrity are enforced using workbench 5.6.So I did a few things to test that after I did forward engineer on my ER diagram.
Let's say I set a column type mediumint, yet it allows me to save "abc" or any character in it.
And I check primary key, unique, not null, autoincrement, yet it allows me to enter anything (even character) and never did the autoincrement for me, nor reject null, duplicate.
Can someone kindly explain to me why? Thanks ahead.
Subject
Views
Written By
Posted
column datatype is not enforced
1405
September 06, 2013 04:33PM
521
September 09, 2013 01:26AM
493
September 09, 2013 12:01PM
415
September 09, 2013 02:57PM
412
September 09, 2013 03:00PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.