Einzelnen Beitrag anzeigen

sippytom

Registriert seit: 21. Mai 2015
7 Beiträge
 
#93

AW: MySQL via PHP-Tunnel (über eigene libmysql.dll)

  Alt 25. Mai 2015, 13:42
Just did some tests and still got the error
Code:
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;

INSERT INTO nodes VALUES (1, NULL, 'A');
INSERT INTO nodes VALUES (2, 1, 'AA');
INSERT INTO nodes VALUES (3, NULL, 'B');
INSERT INTO nodes VALUES (4, 2, "AA=1234; bbA");
Still have error on the bottom line.
So not everything enclosed in quotes is passed as a string?

Tom
  Mit Zitat antworten Zitat