MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table emp(idemp  not null)
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 'not null)' at line 1

create table emp(idemp  int not null)
CREATE TABLE IF NOT EXISTS `karakoyd`.`emp` (
      `idemp`  NOT NULL,
      `name` VARCHAR(45) NOT NULL,
      `email` VARCHAR(255) NOT NULL,
      `pass` VARCHAR(255) NOT NULL,
      `salt` VARCHAR(19) NOT NULL,
      `log` VARCHAR(45) NOT NULL,
      `rütbe` VARCHAR(45) NOT NULL,
      PRIMARY KEY (`idemp`),
      UNIQUE INDEX `idemployee_UNIQUE` (`idemp` ASC) VISIBLE)
    ENGINE = InnoDB
    AUTO_INCREMENT = 19
    DEFAULT CHARACTER SET = utf8
    COLLATE = utf8_turkish_ci;
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 'NOT NULL,
      `name` VARCHAR(45) NOT NULL,
      `email` VARCHAR(255) NOT NULL' at line 2

CREATE TABLE IF NOT EXISTS `emp` (
      `idemp` int NOT NULL,
      `name` VARCHAR(45) NOT NULL,
      `email` VARCHAR(255) NOT NULL,
      `pass` VARCHAR(255) NOT NULL,
      `salt` VARCHAR(19) NOT NULL,
      `log` VARCHAR(45) NOT NULL,
      `rütbe` VARCHAR(45) NOT NULL,
      PRIMARY KEY (`idemp`),
      UNIQUE INDEX `idemployee_UNIQUE` (`idemp` ASC) VISIBLE)
    ENGINE = InnoDB
    AUTO_INCREMENT = 19
    DEFAULT CHARACTER SET = utf8
    COLLATE = utf8_turkish_ci;