I am trying to create a table with a fixed prefix and a variable, something similar as below.
set @id=10;
CREATE TABLE Exam_@id(
name varchar(25) not null,
roll int(11) not null
)
But mysql throws some error. can any one suggest me the right way to do?(I am working in phpmyadmin directly).
-thanks