Im trying to create a database. Which has been created and i have many tables within the database but when i go to create my "Supplies" Table i get this error.
Coding is below
I get this error
SQL is CREATE TABLE Supplys(Supply_ID int(4) NOT NULL AUTO_INCREMENT PRIMARY KEY,Supply_Name varchar(100) NOT NULL,Supply_Type varchar(50) NOT NULL,Supply_Cost varchar(20) ,Supply_Availble varchar(20),Staff_ID varchar(20);
Error creating Supplys table: 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 '' at line 1