Error Creating Table In Sql

I keep getting errors when running this query in phpmyadmin to create a customers table for my database. This is the query I am trying to use: CREATE TABLE customers ( cust_

Solution 1:

You added a comma after phone character(15)

Try this:

CREATETABLE customers (
cust_id INTNOTNULL AUTO_INCREMENT PRIMARY KEY,
Name character(30),
phone character(15)
);

Solution 2:

no need to put a comma for last column.

Remove comma after phone character(15).

Try this

CREATETABLE customers (
cust_id INTNOTNULL AUTO_INCREMENT PRIMARY KEY,
Name character(30), 
phone character(15)
);