How to turn strict mode off in phpmyadmin?

Discussion in 'MySQL' started by maney, Oct 16, 2006.

0
  1. #1
    Is it possible to turn strict mode off in phpmyadmin?

    Thanks :)
    Dan
     
    maney, Oct 16, 2006 IP
  2. kjewat

    kjewat Active Member

    Messages:
    149
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    53
    #2
    I think you can turn strict mode off (at least for the current session) in phpMyAdmin by running the following sql:

    SET sql_mode = ''

    If the current user has the neede privileges I think you can run this sql:

    SET @@global.sql_mode=''

    Take a look at the SQL Mode documentation.
     
    kjewat, Oct 17, 2006 IP