Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
349 views
in Technique[技术] by (71.8m points)

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 )";

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:

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

Please provide suggestions.

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

You cannot create a columnname with special characters like @ and . in it.

I believe Email ID has an @ in it, so it will not create a table.

Also make sure keywords are not used as column names. like is a keyword.

try creating a table by replacing @ and . with some other characters like $

String str = "example$gmail_com"

String query = "create table newTable("+str+" varchar(255));";

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...