Having some trouble with Create Table

NeoTechni · #1 (**permalink**) 06-15-10, 01:29

It tells me something is wrong with my syntax, but oh so helpfully doesn't tell me what is wrong.

CREATE TABLE 'Friends'
(Name TINYTEXT,
Phone CHAR(10))

shammat · #2 (**permalink**) 06-15-10, 01:42

Remove the single quotes around Friends:

Code:

CREATE TABLE friends
(
  name tinytext,
  phone char(10)
);

It also might be that "name" is a reserved word, so you want to check that in the manual

NeoTechni · #3 (**permalink**) 06-15-10, 02:04

I added code to auto-error if it detects any reserved keywords or spaces in names, it didnt find any.
I removed the single quotes

I think that did it.

EDIT: I forgot to thank you, thank you by the way.
I am now 2 steps farther into MySQL than I got with MS's BS (couldn't even connect to it)