neue Tabelle mit Felder in MYSQL klappt nicht

Diese Seite verwendet Cookies. Durch die Nutzung unserer Seite erklären Sie sich damit einverstanden, dass wir Cookies setzen. Weitere Informationen

  • neue Tabelle mit Felder in MYSQL klappt nicht

    Hallo,
    könnte mir mal bitte jemand sagen was hier drann Falsch sein soll ????

    Quellcode

    1. CREATE TABLE phpbb_impressum ( config_name varchar(255) NOT NULL default '', config_value text NOT NULL, PRIMARY KEY (config_name) ) TYPE=MyISAM
    2. INSERT INTO phpbb_impressum (config_name, config_value) VALUES ('imp_complete_on', '1')
    3. INSERT INTO phpbb_impressum (config_name, config_value) VALUES ('imp_complete_off', '0')
    4. INSERT INTO phpbb_impressum (config_name, config_value) VALUES ('config_id', '1')
    5. INSERT INTO phpbb_impressum (config_name, config_value) VALUES ('webm_name', '')
    6. INSERT INTO phpbb_impressum (config_name, config_value) VALUES ('webm_street', '')
    7. INSERT INTO phpbb_impressum (config_name, config_value) VALUES ('webm_home', '')
    8. INSERT INTO phpbb_impressum (config_name, config_value) VALUES ('webm_phone', '')
    9. INSERT INTO phpbb_impressum (config_name, config_value) VALUES ('webm_fax', '')
    10. INSERT INTO phpbb_impressum (config_name, config_value) VALUES ('webm_email', '')
    11. INSERT INTO phpbb_impressum (config_name, config_value) VALUES ('webm_ustidnr', '')
    12. INSERT INTO phpbb_impressum (config_name, config_value) VALUES ('webm_avatar_id', '2')
    13. INSERT INTO phpbb_impressum (config_name, config_value) VALUES ('webm_avatar_opt', '1')
    14. INSERT INTO phpbb_impressum (config_name, config_value) VALUES ('webm_phone_opt', '1')
    15. INSERT INTO phpbb_impressum (config_name, config_value) VALUES ('webm_fax_opt', '1')
    16. INSERT INTO phpbb_impressum (config_name, config_value) VALUES ('webm_email_opt', '1')
    17. INSERT INTO phpbb_impressum (config_name, config_value) VALUES ('webm_ustidnr_opt', '1')
    18. INSERT INTO phpbb_impressum (config_name, config_value) VALUES ('impressum_off_msg', 'Das Impressum ist vorübergehend Deaktiviert.')
    19. INSERT INTO phpbb_impressum (config_name, config_value) VALUES ('disclaimer_msg', 'Trotz sorgfältiger inhaltlicher Kontrolle übernehmen wir keine Haftung für die Inhalte externer Links. Für den Inhalt der verlinkten Seiten sind ausschließlich deren Betreiber verantwortlich.')
    20. INSERT INTO phpbb_impressum (config_name, config_value) VALUES ('mngt_name', '')
    21. INSERT INTO phpbb_impressum (config_name, config_value) VALUES ('mngt_street', '')
    22. INSERT INTO phpbb_impressum (config_name, config_value) VALUES ('mngt_home', '')
    23. INSERT INTO phpbb_impressum (config_name, config_value) VALUES ('mngt_phone', '')
    24. INSERT INTO phpbb_impressum (config_name, config_value) VALUES ('mngt_fax', '')
    25. INSERT INTO phpbb_impressum (config_name, config_value) VALUES ('mngt_email', '')
    26. INSERT INTO phpbb_impressum (config_name, config_value) VALUES ('mngt_avatar_id', '3')
    27. INSERT INTO phpbb_impressum (config_name, config_value) VALUES ('mngt_avatar_opt', '1')
    28. INSERT INTO phpbb_impressum (config_name, config_value) VALUES ('mngt_phone_opt', '1')
    29. INSERT INTO phpbb_impressum (config_name, config_value) VALUES ('mngt_fax_opt', '1')
    30. INSERT INTO phpbb_impressum (config_name, config_value) VALUES ('mngt_email_opt', '1')
    31. INSERT INTO phpbb_impressum (config_name, config_value) VALUES ('management_on_opt', '1')
    32. INSERT INTO phpbb_impressum (config_name, config_value) VALUES ('management_off_opt', '0')
    Alles anzeigen


    Fehlermeldung
    MySQL meldet: Dokumentation
    #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO phpbb_impressum (config_name, config_value) VALUES (

  • Danke, aber wenn ich hinter jedes INSERT bzw am Ende der Zeile ein ; setzte kommt dieser Fehler :/

    #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO phpbb_impressum (config_name, config_value) VALUES ('imp_complete_on' at line 2

    Quellcode

    1. CREATE TABLE phpbb_impressum ( config_name varchar(255) NOT NULL default '', config_value text NOT NULL, PRIMARY KEY (config_name) ) TYPE=MyISAM
    2. INSERT INTO phpbb_impressum (config_name, config_value) VALUES ('imp_complete_on', '1');