title: SQL insert , update stored procedure
body: <pre><code>CREATE TABLE `db_customer`.`customer` (
    `customer_id` INT NOT NULL AUTO_INCREMENT,
    `first_name` VARCHAR(45) NOT NULL,
    `lastname` VARCHAR(45) NOT NULL,
    `date_of_birth` DATE NOT NULL,
    `country` VARCHAR(45) NOT NULL,
    `email` VARCHAR(100) NOT NULL,
    `username` VARCHAR(45) NOT NULL,
    `short_biography` TEXT NOT NULL,
    `photo` BLOB NULL,
    PRIMARY KEY (`customer_id`)
  );
  </code></pre>
  
  <p>DELIMITER $$
      CREATE PROCEDURE <code>table_in</code> (
        first_name VARCHAR(45),
        lastname VARCHAR(45),
        date_of_birth DATE,
        country VARCHAR(45),
        email VARCHAR(100),
        username VARCHAR(45),
        short_biography TEXT
      )
      BEGIN
        INSERT INTO customer (
          first_name,
          last_name,
          date_of_birth,
          country,
          email,
          username,
          short_biography
        ) VALUES (
          customer_id,
          first_name,
          laast_name,
          date_of_birth,
          country,
          email,
          username,
          short_biography
      );
      END$$</p>
  
  <p>DELIMITER ;</p>