I’ve just started reading the book "Build your own database driven website using PHP and MySQL and managed myself to fly my way through to the actual mysql commands in creating/managing tables and databases. I have a small problem though. When I try to create a table, I can’t seem to do it properly, I always get a syntax error!
I am using version 5.045 and here is the code I’m typing in:
create table clients (
id int not null auto_increment primary key,
);
Even that gives me a syntax error! Where am I going wrong?