create table `book_201858056`(
num int auto_increment,
bookname VARCHAR(30) NOT NULL,
author VARCHAR(30) NOT NULL,
publisher VARCHAR(50) NOT NULL,
price INT NOT NULL,
bookno VARCHAR(50) NOT NULL
primary key(num)
)
Fatal error: Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(30) NOT NULL,
author VARCHAR(30) NOT NULL,
publisher VARCHAR(50) NOT...' at line 3 in /users/2018/i1858056/public_html/2022/WebDB/test/create.php:20
Stack trace:
#0 /users/2018/i1858056/public_html/2022/WebDB/test/create.php(20): mysqli_query()
#1 {main}
thrown in /users/2018/i1858056/public_html/2022/WebDB/test/create.php on line 20