1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

How to turn strict mode off in phpmyadmin?

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

  1. #1
    Is it possible to turn strict mode off in phpmyadmin?
    SEMrush
    Thanks :)
    Dan
     
    maney, Oct 16, 2006 IP
    SEMrush
  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