• 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)
  • 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,

    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.