Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    61

    Exclamation Unanswered: plz help!!!! mysql upgrade - now query 255 char doesn't work!

    I upgraded from mysql3 to mysql 4.1 and I just noticed that it won't take queries that are longer than 255 charectors!!!!

    When I try to execute this query - it cannot!!!

    INSERT INTO MAIN (PER_ID, DATE, AIR_ID, MODEL_ID, DEP, ROUTE, DEST, X_CONTRY, XC135, DAY, NIGHT, IMC, SIM_INST, APP_NUM, NAPP_NUM, HOLDS, DAY_LAND, NIGHT_LAND, DUAL, DUAL_GIV, TYPE, NOTES) VALUES ('guest', '2005-10-18','FDSFSDFSDFSD', '203', '', '', '', '', '', '','','','','', '', '', '1','', '', '', 'PIC', '')


    When I try to copy and paste it into the mysql command line it only lets me paste the first 255 charectors. I can't even manually add more!!!!

    mysql> INSERT INTO MAIN (PER_ID, DATE, AIR_ID, MODEL_ID, DEP, ROUTE, DEST, X_CON
    TRY, XC135, DAY, NIGHT, IMC, SIM_INST, APP_NUM, NAPP_NUM, HOLDS, DAY_LAND, NIGHT
    _LAND, DUAL, DUAL_GIV, TYPE, NOTES) VALUES ('guest', '2005-10-18','FDSFSDFSDFSD'
    , '203', '', '', '',

    What's going on?

  2. #2
    Join Date
    Dec 2003
    Posts
    61
    I found out what was happening, and I fixed it and I thought I'd explain it incase someone runs into a simular problem.

    the 255 charecters was my goof. It wasn't the problem...
    This query worked fine for me in mysqld 3.2:

    INSERT INTO MAIN (PER_ID, DATE, AIR_ID, MODEL_ID, DEP, ROUTE, DEST, X_CONTRY, XC135, DAY, NIGHT, IMC, SIM_INST, APP_NUM, NAPP_NUM, HOLDS, DAY_LAND, NIGHT_LAND, DUAL, DUAL_GIV, TYPE, NOTES) VALUES ('guest', '2005-10-18','FDSFSDFSDFSD', '203', '', '', '', '', '', '','','','','', '', '', '1','', '', '', 'PIC', '')

    Now in Mysql 4.1 it errors.

    The reason, the tilda signs need to be there appeanatly and mysql 4.1 appears to be much more sensetive...

    INSERT INTO `main` (`PER_ID`, `DATE` ...... etc.........

    Can anyone explain why it's working now with the tilda signs? Is it more propper sql sintax????

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •