CREATE TABLE #temps
(
id int,
agentCnt int,
serviceTeamCnt int
PRIMARY KEY (id)
)
The error I'm getting is
/* SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(
VId int,
id int,
agentCnt int,
serviceTeamCnt int
' at line 2 */
Does heidi not create temporary tables using this syntax? If not what could you suggest? I'm a big noob at this so any help would be greatly appreciated