1. Forum
  2. USENET
  3. comp.databases.mysql

  • problem moving up to 5.7

    From bill@william@TechServSys.com to comp.databases.mysql on Sat Nov 9 08:02:40 2019
    From Newsgroup: comp.databases.mysql

    I am having a problem moving up to 5.7.
    I remember there is a way of getting 5.7 to act like an earlier
    release, some way of setting mode. I have read the manual
    sections on mode and nothing rings a bell.

    It may have been as simple as removing the mode statements, but I
    can't figure out how to do that. Whenever I set global sql_mode
    = 'whatever' the new mode is added to the mode string.
    bill
    --- Synchronet 3.21d-Linux NewsLink 1.2
  • From Luuk@luuk@invalid.lan to comp.databases.mysql on Sat Nov 9 14:24:12 2019
    From Newsgroup: comp.databases.mysql

    On 9-11-2019 14:02, bill wrote:
    I am having a problem moving up to 5.7.
    I remember there is a way of getting 5.7 to act like an earlier release, some way of setting mode.-a I have read the manual sections on mode and nothing rings a bell.

    It may have been as simple as removing the mode statements, but I can't figure out how to do that.-a Whenever I set global sql_mode = 'whatever'
    the new mode is added to the mode string.
    bill



    I forgot to mention that this is a legacy PHP system of about 100,000 lines so rewriting it is not an option.
    bill


    The only option you have is to upgrade, ohter options will cost much
    more time in the (near) future.
    --
    Luuk
    --- Synchronet 3.21d-Linux NewsLink 1.2