Resolved: ERROR CODE 1064 MYSQL
How to Solve
purchase_number IS NOT NULL PRIMARY KEY AUTO_INCREMENT,
this line is showing after execution
2 answers ( 1 marked as helpful)
Super learner
This user is a Super Learner. To become a Super Learner, you need to reach Level 8.
MD. JAHID HASAN,
If you have copied your code exactly as you have entered it, there is an 'IS' after purchase_number which should be INT
purchase_number INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
Hope this helps.
Kev T.
Hi Jahid and Kev!
Thanks for reaching out.
@: Kev
Thanks for sharing this piece of information with the Community!
@: Jahid
As Kev said you have to use the following code:
purchase_number INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
Hope this helps.
Best,
Tsvetelin