I need to enter a new column in mysql but it does not leave me [closed]

Navigation
-3

I was entering columns normail mind but when creating a date type I get the following error 

      SQL query:


          ALTER TABLE 'asignacion_tablet'  ADD 'inicio' DATE NOT NULL  
          AFTER 'Celular';MySQL said: Documentation

           #1292 - Incorrect date value: '0000-00-00' for column 'inicio' at row 1

I appreciate your help

    
asked by Kevin Salazar 20.11.2017 в 17:17
source

1 answer

1

already the solutions thanksThe solution is because in MySQL from version 5.7 is activated by default the strict mode that does not allow to add in date fields from china you just have to put the column null and it is already

    
answered by 20.11.2017 / 17:32
source
How to validate php form how to find out what calls the JavaScript code makes [closed]