Skip to content

Instantly share code, notes, and snippets.

@cozingo

cozingo/null_and_default.txt

Created February 25, 2017 05:41
Show Gist options
  • Save cozingo/11826cec4df703fa55de53ed5c248476 to your computer and use it in GitHub Desktop.
Save cozingo/11826cec4df703fa55de53ed5c248476 to your computer and use it in GitHub Desktop.
Download ZIP
null and default null difference in phpmyadmin
Raw
null_and_default.txt
Null column is like NOT NULL in query for int will not accept empty value only 0 or some other number, for char its acceptable as "" is value for char.
Default means if it is empty it will be set to NULL or to current timestamp or something to DEFAULT VALUE which is set by user.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment