1064 error in CREATE TABLE … TYPE=MYISAM

by

As documented under CREATE TABLE Syntax:

Note
The older TYPE option was synonymous with ENGINE. TYPE was deprecated in MySQL 4.0 and removed in MySQL 5.5. When upgrading to MySQL 5.5 or later, you must convert existing applications that rely on TYPE to use ENGINE instead.

Therefore, you want:

CREATE TABLE dave_bannedwords(
  id   INT(11)     NOT NULL AUTO_INCREMENT,
  word VARCHAR(60) NOT NULL DEFAULT '',
  PRIMARY KEY (id),
  KEY id(id) -- this is superfluous in the presence of your PK, ergo unnecessary
) ENGINE = MyISAM ;

More Related Contents:

  1. How can I fix MySQL error #1064?
  2. Using an Alias in SQL Calculations
  3. What is the question mark’s significance in MySQL at “WHERE column = ?”?
  4. How do I modify a MySQL column to allow NULL?
  5. What’s the difference between comma separated joins and join on syntax in MySQL? [duplicate]
  6. MySQL delimiter syntax error
  7. Get Insert Statement for existing row in MySQL
  8. GRANT with database name wildcard in MySQL?
  9. DELETE FROM `table` AS `alias` … WHERE `alias`.`column` … why syntax error?
  10. Using LIMIT within GROUP BY to get N results per group?
  11. Possible to do a MySQL foreign key to one of two possible tables?
  12. MySQL error: key specification without a key length
  13. Mysql query to dynamically convert rows to columns
  14. Suppress warning messages using mysql from within Terminal, but password written in bash script
  15. How can I view live MySQL queries?
  16. Convert partially non-numeric text into number in MySQL query
  17. MYSQL ORDER BY CASE Issue
  18. Can’t use a MySQL connection for entity framework 6
  19. MySQL difference between two rows of a SELECT Statement
  20. MySQL Select last 7 days
  21. connecting to mysql server on another PC in LAN
  22. MySQL view performance
  23. Does MySQL Regexp support Unicode matching
  24. mysqld_safe Directory ‘/var/run/mysqld’ for UNIX socket file don’t exists
  25. How to retrieve JSON data from MySQL?
  26. Is incrementing a field in MySQL atomic?
  27. Delete from one table with join
  28. MySQL column type “TIMESTAMP” implicitly includes “NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP”
  29. MySQL: Compare BETWEEN time
  30. MySQL: how to do row-level security (like Oracle’s Virtual Private Database)?

Leave a Comment