• Categories
    • PHP
    • phpMyAdmin
    • PHPMailer
    • FFMpeg
    • PHPEXcel
    • PHPDoc
    • PHPUnit
    • CakePHP
    • CakePHP 2.0
    • Cake PHP 2.1
    • CakePHP Model
    • Facebook PHP SDK
    • composer-php
    • PHP 7
    • PHP GD
    All Categories
  • About

phpMyAdmin Accepts NULL in the NOT NULL field

mysqlsqldatabasephpmyadmin


PHP Snippet 1:

SET SQL_MODE='STRICT_ALL_TABLES'

PHP Snippet 2:

SQL_MODE='STRICT_ALL_TABLES'

PHP Snippet 3:

# You can copy this file to
# C:/xampp/mysql/bin/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is C:/xampp/mysql/data) or
# ~/.my.cnf to set user-specific options.

Related Snippets

LARAVEL: How to fetch id dynamically in a query builder?

Delete a database in phpMyAdmin

MySQL default time format UTC or GMT?

How to disable only_full_group_by option in Laravel

definer/invoker of view lack rights to use them

WordPress Subquery returns more than 1 row on SELECT

The sum of the user's points

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource [duplicate]

What is wrong with this inner join sql query

laravel 5.6 bulk inserting json data

Undefined Array Key error when uploading image on php

Fatal error: Uncaught mysqli_sql_exception: Unknown database 'test' in ... (How do I fix that? Using PHP)

Correct way to use LIKE '%{$var}%' with prepared statements?

HTML and PHP in one file

MySQL - Connection failed: No route to host

About Contact Privacy policy Terms and conditions