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
sorry i wanted to write it in mysql thread

Edited by xxmp because: n/a
  • 2 Contributors
  • 2 Replies
  • 96 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by xxmp
Member Avatar for apegram

By placing 1 inside single quotes, you're treating it as a string, but the destination field is an int. That's a syntax error.

Member Avatar for xxmp

ok i corrected the problem thank you very much

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.