将文本插入到恰好包含 MySQL 中的 sql 的 varchar 中？

发布于 2024-11-19 02:48:13 字数 539 浏览 3 评论 0原文

我试图将恰好包含 sql 查询的文本插入到 varchar 中，但是当我执行插入时 MySQL 产生错误。我怎样才能做到这一点而不产生错误？

这是我到目前为止所拥有的。我创建了一个名为“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

然后我尝试插入数据：

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

这会产生错误消息：“您的 SQL 语法有错误；请检查手册……等等不是很有帮助。”我认为 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.

分享到QQ

分享到微博