My problem is this. I\'ve tried to make tables, but to no avail. I fill in the names of the columns, I pick out a type, I actually know what the types mean, I fill in a length, and I make a primary key. According to this one tutorial I\'m going off of, you don\'t need any more than that to create a basic table. Click the save button, and everythings OK, right?
Wrong. PHPMyAdmin keeps hacking up errors in the generated SQL syntax that I haven\'t the slightest clue how to fix, though I have tried changing my methods of entering stuff. The code looks like this-
CREATE TABLE `Character Names` (`Name` TINYTEXT( 20 ) NOT NULL ,`Male or Female` ENUM( \'male\', \'female\', \'either\' ) NOT NULL ,`Meaning` TINYTEXT( 150 ) NOT NULL ,PRIMARY KEY ( `Name` ) )
The error looks like this.
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 \'(20) NOT NULL, `Male or Female` ENUM(\'male\',\'female\',\'either\')
I\'ll give you a hug if you can help me. This is extremely aggravating.