Hello, I am trying to create a table in my database using a query, but it is not working. Here is the query:

CREATE TABLE `pastebin` (
      `pid` int(11) NOT NULL auto_increment,
      `poster` varchar(16) default NULL,
      `posted` datetime default NULL,
      `code` text,
      `parent_pid` int(11) default '0',
      `format` varchar(16) default NULL,
      `codefmt` mediumtext,
      `codecss` text,
      `domain` varchar(255) default '',
      `expires` DATETIME,
      `expiry_flag` ENUM('d','m', 'f') NOT NULL DEFAULT 'm',
 
      PRIMARY KEY  (`pid`),
      KEY `domain` (`domain`),
      KEY `parent_pid`,
      KEY `expires`
    );
 
create table recent
(
    domain varchar(255),
    pid int not null,
    seq_no int not null,
 
    primary key(domain,seq_no)
);

When I try putting that in phpmyadmin SQL query box, it returns:

#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 '
KEY `expires`
)' at line 16

What am I doing wrong? If I am not able to do this through phpmyadmin, how would I go about doing this using a .php file? I have tried doing this many times using guides, with no luck, so I would appreciate it if someone could help me.

KEY `parent_pid` (`parent_pid`),
KEY expires (`expires`)

supply a index name AND a column to be used.

Originally Posted by pkallberg21

What am I doing wrong? If I am not able to do this through phpmyadmin, how would I go about doing this using a .php file? I have tried doing this many times using guides, with no luck, so I would appreciate it if someone could help me.

That's because the database engine is rejecting the code; it won't matter how you send the commands.