My table has been not creat in php my admin SQL quary please help and check my code
CREATE TABLE IF NOT EXISTS products (prod_id INT UNSIGNED NOT NULL AUTO_INCREMENT, prod_code CHAR(4) NOT NULL, name VARCHAR(50) NOT NULL, quanrity INT UNSIGNED NOT NULLL DEFAULT 0, price DECIMAL(10,2) NOT NULL DEFAULT 99999.99, PRIMARY KEY(prod_id));
There is showing error.
I AM FACING THE SAME PROBLEM .I AM A LEARNER PLEASE HELP .
HERE IS MY QUARY
create table if not Exists products(prod_id INT UNSIGNED NOT NULL AUTO_INCREMENT,prod_id char(4) NOT null,name VARCHAR(50)not null,quantity int unsigned Not null default 0,price DECIMAL(10,2)Not null default 99999.99,primary key(prod_id));
please help me. i am tired to create a tabel .
I AM FACING THE SAME PROBLEM .I AM A LEARNER PLEASE HELP .
HERE IS MY QUARY
create table if not Exists products(prod_id INT UNSIGNED NOT NULL AUTO_INCREMENT,prod_id char(4) NOT null,name VARCHAR(50)not null,quantity int unsigned Not null default 0,price DECIMAL(10,2)Not null default 99999.99,primary key(prod_id));
please help
Check code sharply there is spelling mistake