MySQL Error #1064 Link counter

Question

I have been using this site to build a simple link counter.

When I insert their code to create the columns, it won't work and displays the following error:

error #1064.

id INT AUTO_INCREMENT NOT NULL PRIMARY_KEY, clicks INT

Any idea what I am doing wrong?

Kindly paste your query here – Munjal Mayank Nov 18 '15 at 14:06 — Munjal Mayank, Nov 18 '15 at 14:06
http://stackoverflow.com/a/23515348/3181416 – Munjal Mayank Nov 18 '15 at 14:06 — Munjal Mayank, Nov 18 '15 at 14:06

score 0 · Answer 1 · answered Nov 18 '15 at 14:07

Error 1064 means : "You have an error in your SQL syntax". It happens because

id INT AUTO_INCREMENT NOT NULL PRIMARY_KEY, clicks INT

is not a valid SQL query at all. It's just the fields definition part.

To create your table, ensure you have a database selected and try:

CREATE TABLE IF NOT EXISTS `clickcount` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `click` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

I created the tables but they won't update the value. – Qluvyy Nov 18 '15 at 20:55 — Qluvyy, Nov 18 '15 at 20:55

MySQL Error #1064 Link counter

1 Answers1