开发者

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

开发者 https://www.devze.com 2023-03-19 12:30 出处:网络
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?

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

精彩评论

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

关注公众号