CREATE TABLE book_2021510391(
no int not null auto_increment primary key,
bookname varchar(25) not null,
name varchar(4 not null,
pub varchar(5) not null,
year int(4) not null,
rating float(3) not null;<br />
<b>Fatal error</b>:  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 'not null,
pub varchar(5) not null,
year int(4) not null,
rating float(3) n...' at line 4 in /users/2021/i2151039/public_html/2022/WebDB/test/create.php:12
Stack trace:
#0 /users/2021/i2151039/public_html/2022/WebDB/test/create.php(12): mysqli_query()
#1 {main}
  thrown in <b>/users/2021/i2151039/public_html/2022/WebDB/test/create.php</b> on line <b>12</b><br />