Databases
StackOverflow2013
Postsdbo
POMYSQL script import error
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POMYSQL script import error
    text
    copied!<p>I am getting an error when I try to import data through the command:</p> <pre><code>mysql -u root -p"root" cvdb &lt; "cvdb.sql" </code></pre> <p>The error I am getting is:</p> <blockquote> <p>ERROR 1064 (42000) at line 72: 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 '(14) NOT NULL, <code>Created</code> datetime NOT NULL default ' 0000-00-00 00:00:00 ', ' at line 14</p> </blockquote> <p>The code of my SQL file is:</p> <pre><code>DROP TABLE IF EXISTS `activity`; CREATE TABLE `activity` ( `AllDay` enum('YES','NO') default 'NO', `ActivityID` int(11) unsigned NOT NULL auto_increment, `Type` int(11) NOT NULL default '0', `Priority` int(11) NOT NULL default '0', `Status` int(11) NOT NULL default '0', `Title` varchar(255) default NULL, `DueDate` datetime default NULL, `CompletedDate` datetime default NULL, `Details` text, `Creator` int(11) NOT NULL default '0', `Owner` int(11) default NULL, `ModifiedBy` int(11) default NULL, `Modified` timestamp(14) NOT NULL, `Created` datetime NOT NULL default ' 0000-00-00 00:00:00 ', `Start` datetime default NULL, `End` datetime default NULL, `AttachmentType` enum('NONE','FILE','LINK') NOT NULL default 'NONE', `Location` varchar(25) default NULL, `visibility` enum('PRIVATE','PUBLIC') NOT NULL default 'PRIVATE', `Notes` varchar(255) default NULL, PRIMARY KEY (`ActivityID`), UNIQUE KEY `ActivityID` (`ActivityID`), KEY `Type` (`Type`), KEY `Priority` (`Priority`), KEY `Status` (`Status`), KEY `Creator` (`Creator`), KEY `Owner` (`Owner`), KEY `ModifiedBy` (`ModifiedBy`), KEY `Location` (`Location`) ) ENGINE=InnoDB; </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload