Forum: Software-Projekte der Mitglieder
by teosuper,
25. Mai 2015
HeidiSql is a tool like phpMyadmin.
I have a few general suggestions: first is to replace the ";" with some different character. If that works, at least you know what the issue is.
A quick work around: if you use stringreplace to replace ";" when posting and another stringreplace when retrieving the data, your problem should be worked around.
Forum: Software-Projekte der Mitglieder
by teosuper,
25. Mai 2015
I executed this in Heidisql without errors:
DROP TABLE IF EXISTS nodes;
CREATE TABLE nodes (
node_id int,
parent_id int,
bez TEXT,
CONSTRAINT PK_nodes PRIMARY KEY (node_id),
CONSTRAINT FK_nodes_parent FOREIGN KEY (parent_id) REFERENCES nodes (node_id)
) ENGINE=InnoDB;
Forum: Software-Projekte der Mitglieder
by teosuper,
25. Mai 2015
Ja, stimmt schon.. Nicht gut hingeschaut..
Indeed.. the whole part in quotes is inserted in a field in the database so the Pascal ":=" does not matter nor affect anything.