Page 738 of 738 FirstFirst ... 238638688728736737738
Results 7,371 to 7,374 of 7374
  1. #7371
    hi, i try to add script but get thisq error
    9 erreurs trouvées lors de l'analyse.

    Caractère inattendu. (near "$" at position 41)
    Caractère inattendu. (near "$" at position 43)
    Une expression était attendue. (near "IN" at position 16)
    Mot clé non reconnu. (near "IN" at position 16)
    Mot clé non reconnu. (near "EXISTS" at position 19)
    Jeton inattendu. (near "addLogPlayerID" at position 26)
    Jeton inattendu. (near "$" at position 41)
    Jeton inattendu. (near "$" at position 43)
    Un nouvel énoncé a été trouvé, mais il n'y a aucun délimiteur entre celui-ci et le précédent. (near "CREATE" at position 46)
    Requête SQL : Documentation

    DROP PROCEDURE IN EXISTS addLogPlayerID $ $ CREATE PROCEDURE addLogPlayerID() COMMENCER - Ajouter la colonne logPlayerID en toute sécurité IF NOT EXISTS( ( SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND COLUMN_NAME = ' logPlayerID ' ET TABLE_NAME = ' tbl_chatlog ') ) ALORS ALTER TABLE ` tbl_chatlog ` ADD COLUMN ` logPlayerID ` INT(10) DEFAULT UNSIGNED NULL

    MySQL a répondu : Documentation

    #1064 - Erreur de syntaxe près de 'IN EXISTS addLogPlayerID $ $
    CREATE PROCEDURE addLogPlayerID() COMMENCER - Ajou' à la ligne 2

  2. #7372
    Translation:
    9 errors found during the analysis.

    Unexpected character (near "$" at position 41)
    Unexpected character (near "$" at position 43)
    An expression was expected. (near "IN" at position 16)
    Unrecognized keyword. (near "IN" at position 16)
    Unrecognized keyword. (near "EXISTS" at position 19)
    Unexpected token (near "addLogPlayerID" at position 26)
    Unexpected token (near "$" at position 41)
    Unexpected token (near "$" at position 43)
    A new statement has been found, but there is no delimiter between it and the previous one. (near "CREATE" at position 46)
    SQL query: Documentation

    DROP PROCEDURE IN EXISTS addLogPlayerID $ $ CREATE PROCEDURE addLogPlayerID () BEGIN - Add column logPlayerID safely IF NOT EXISTS ((SELECT * FROM info_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE () AND COLUMN_NAME = 'logPlayerID' AND TABLE_NAME = 'tbl_chatlog' )) THEN ALTER TABLE `tbl_chatlog` ADD COLUMN `logPlayerID` INT (10) DEFAULT UNSIGNED NULL

    MySQL replied: Documentation

    # 1064 - Syntax error near 'IN EXISTS addLogPlayerID $ $
    CREATE PROCEDURE addLogPlayerID () START - Add 'to line 2

  3. #7373
    Quote Originally Posted by HARAFAT69 View Post
    hi, i try to add script but get thisq error
    9 erreurs trouvées lors de l'analyse.

    Caractère inattendu. (near "$" at position 41)
    Caractère inattendu. (near "$" at position 43)
    Une expression était attendue. (near "IN" at position 16)
    Mot clé non reconnu. (near "IN" at position 16)
    Mot clé non reconnu. (near "EXISTS" at position 19)
    Jeton inattendu. (near "addLogPlayerID" at position 26)
    Jeton inattendu. (near "$" at position 41)
    Jeton inattendu. (near "$" at position 43)
    Un nouvel énoncé a été trouvé, mais il n'y a aucun délimiteur entre celui-ci et le précédent. (near "CREATE" at position 46)
    Requête SQL : Documentation

    DROP PROCEDURE IN EXISTS addLogPlayerID $ $ CREATE PROCEDURE addLogPlayerID() COMMENCER - Ajouter la colonne logPlayerID en toute sécurité IF NOT EXISTS( ( SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND COLUMN_NAME = ' logPlayerID ' ET TABLE_NAME = ' tbl_chatlog ') ) ALORS ALTER TABLE ` tbl_chatlog ` ADD COLUMN ` logPlayerID ` INT(10) DEFAULT UNSIGNED NULL

    MySQL a répondu : Documentation

    #1064 - Erreur de syntaxe près de 'IN EXISTS addLogPlayerID $ $
    CREATE PROCEDURE addLogPlayerID() COMMENCER - Ajou' à la ligne 2
    "IN EXISTS" is incorrect syntax. Something translated this code into an invalid state. Please run the script exactly as-is without any changes.
    ____

  4. #7374
    thanks, i didn't see chrome traduct pages and code in this case so it's fixed

 

 

Posting Permissions

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