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

Recommended Answers

All 2 Replies

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.

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.