0

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: n/a

2
Contributors
2
Replies
3
Views
7 Years
Discussion Span
Last Post by xxmp
0

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.

0

ok i corrected the problem thank you very much

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.