如何在mysql CREATE TABLE查询中设置变量值?爪哇 [英] how to set variable value in mysql CREATE TABLE query? Java

问题描述

String query = "CREATE TABLE user_post_data ("+str+" varchar(255), post_text varchar(255), post_image longblob, post_date date, like varchar(255), like_time timestamp, like_date date )";

这里，str 是代表用户电子邮件的字符串.我想创建一列用户的电子邮件 ID，但出现以下错误:

Here, str is the String representing email of a user. I want to create one column of email id of the user but i am getting this error below:

未封闭的字符串字面量:指向 ..."+str+" ...

Unclosed string literal: pointing at ..."+str+" ...

请提供建议.

推荐答案

你需要做的就是将你的变量像这样包含在 sql 语句中

what you need to do is enclose your variable like this within the sql statement

'"+变量+"'

所以你的声明会是:

"CREATE TABLE user_post_data ('"+str+"' varchar(255), post_text varchar(255), post_image longblob, post_date date, like varchar(255), like_time timestamp, like_date date )";

这篇关于如何在mysql CREATE TABLE查询中设置变量值?爪哇的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！