#1064 -You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version

create-table, error-handling, mysql

Solution

Remove the comma

`receipt int(10),`

And also `AUTO INCREMENT` should be a KEY

`double` datatype also requires the precision of decimal places so right syntax is `double(10,2)`

Problem

I'm new to `PHP` and `MySQL` and ran into a little trouble with a learning project I'm working on. Whenever I try to create a table ``` CREATE TABLE transactions( id int NOT NULL AUTO_INCREMENT, location varchar(50) NOT NULL, description varchar(50) NOT NULL, category varchar(50) NOT NULL, amount double(10) NOT NULL, type varchar(6) NOT NULL, notes varchar(512), receipt int(10), ) ``` I get the following error message: #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 ') NOT NULL, type varchar(6) NOT NULL, notes varchar(512), receipt int(10), ' at line 6** Here is some info on what I'm working with - Server type: MySQL - Server version: 5.5.32 - MySQL Community Server(GPL) - phpMyAdmin: 4.0.4.1, latest stable version: 4.1.7 I've spent a day knocking my head against the wall over this and now I think its time to ask for help.I was wondering if anyone can tell me what I'm doing wrong?

Original source