Why does this CREATE Table statement not work?

Here's my CREATE TABLE statement:

CREATE TABLE 'volte7' ('Num Days' varchar(20)DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=latin1

I keep getting an error that says something is wrong with my syntax and I can't figure out what it is.

What's wrong?
brucegustPHP DeveloperAsked:
Who is Participating?
 
Steve WalesSenior Database AdministratorCommented:
Two things immediately come to mind.

* Space between varchar(20) and DEFAULT
* I believe that the 'quotes' around object names in MySQL is the back quote (usually the key to the left of 1 on US keyboards), not a regular quote - so ` not '
0
 
GaryCommented:
CREATE TABLE volte7 (`Num Days` varchar(20) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=latin1

Open in new window

0
 
brucegustPHP DeveloperAuthor Commented:
Excellent
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.