Title: #1064 error
Last modified: August 31, 2016

---

# #1064 error

 *  [stelu](https://wordpress.org/support/users/stelu/)
 * (@stelu)
 * [10 years, 4 months ago](https://wordpress.org/support/topic/1064-error/)
 * I need to add i phpMyAdmin the followimg table:
 * #
    # Tabellenstruktur für Tabelle `demo_a_iptest` #
 * CREATE TABLE `demo_a_iptest` (
    ‘ip’ varchar(255) default ‘0’, ‘timefeld’, timestamp(
   14) NOT NULL ) ENGINE=MyISAM;
 * #
    # Daten für Tabelle `demo_a_iptest` #
 * but I get the message:
 * CREATE TABLE `demo_a_iptest` (
 *  ‘ip’VARCHAR( 255 ) DEFAULT ‘0’,
    ‘timefeld’, TIMESTAMP( 14 ) NOT NULL ) ENGINE
   = MYISAM ;
 * MySQL zice: Documentație
 * #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 ”ip’ varchar(255)
   default ‘0’, ‘timefeld’, timestamp(14) NOT NULL
    ) ENGINE=MyI’ at line 7
 * Can someone to show me what is wrong?
 * Thanks!

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [Digico Paris](https://wordpress.org/support/users/digico-paris/)
 * (@digico-paris)
 * [10 years, 4 months ago](https://wordpress.org/support/topic/1064-error/#post-6953172)
 * Hello,
 * Well i can tell you have just a little error in the mysql syntax, I can’t tell
   you where exactly in short, but if you pull the code on codepen.io I could.
 * All seems ok, just a missing comma or so.
 * By the way this code is a test and has nothhing to do with WP. In general you
   create custom tables, it’s more convenient to have all in same database.
 * Regards,
 *  [Digico Paris](https://wordpress.org/support/users/digico-paris/)
 * (@digico-paris)
 * [10 years, 4 months ago](https://wordpress.org/support/topic/1064-error/#post-6953173)
 * Put it on codepen.io please, just a matter of a missing ; or so.
    Otherwise code
   is good.
 * Regards,

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘#1064 error’ is closed to new replies.

## Tags

 * [message](https://wordpress.org/support/topic-tag/message/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)
 * [server](https://wordpress.org/support/topic-tag/server/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [Digico Paris](https://wordpress.org/support/users/digico-paris/)
 * Last activity: [10 years, 4 months ago](https://wordpress.org/support/topic/1064-error/#post-6953173)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics