开发者

Inserting text into a varchar which happens to contain sql in MySQL?

I'm trying to insert text which happens to contain a sql query into a varchar, but MySQL is producing an error when I execute the insert. How can I accomplish this without producing an error?

Here's what I have so far. I created a table called "info":

CREATE TABLE  `info`.`sample` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `one_query` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

开发者_开发问答And then I try to insert the data:

insert into info.sample (one_query) values ('select u.county_id, u.name from sample.upfall u')

This produces the error message, "You have an error in your SQL syntax; check the manual that... blah blah not very helpful." I think MySQL may be looking at my text as an actual select query, which it's trying to execute.


I think you're using a reserved word. Are there any other fields in your table you're not telling us about?


Do you need the table part to be

info.sample

or could it be just

sample
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜