how to set variable value in mysql CREATE TABLE query? Java

Question

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.

Answer 1

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