0

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

user3303274
  • 729
  • 2
  • 8
  • 21

0 Answers0