Member Avatar for xxmp

I have this table publication_en
Field Type
related varchar(200)
public_area int(11)
title text
detail text
file varchar(200)

and i am trying to do this

INSERT INTO publication_en (related, public_area , title , detail , file) VALUES ('none','1','"helped"','la' "kajakjajk"','J3.pdf') but it doesn't work any idea why it doesn't work ?
Thank you very much

  • 2 Contributors
  • 1 Reply
  • 208 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by pritaeas
Member Avatar for pritaeas

typo:

INSERT INTO publication_en (related, public_area , title , detail , file) VALUES ('none','1','"helped"','la "kajakjajk"','J3.pdf')

There is a single quote after la. If you need it there, then you should escape it.

Edited by pritaeas because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.