Material for teaching Web Development in BGU - IEM faculty

Flask

Flask Docs CS50 2020 - Lecture 9 - Flask | Harvard

Flask Blueprint

Flask Blueprint | Real Python

Jinja2

Jinja | Real Python

Jinja Docs

MySQL information

First, you will need to install MySQL on a computer.

• Installation of MySQL

Then, install mysql.connector.

• mysql - get started

You need to create schema and then a certain table inside this schema. Here is the cheatsheet to help you with the basic commands.

• MySQL cheatsheet

Example of creating a table:

CREATE TABLE table_try1 (
  id int auto_increment primary key,
  name varchar(255),
  email text,
  create_date timestamp default CURRENT_TIMESTAMP,
  password varchar(120)
);

Check syntax of MySQL. For example here:

• MySQL Syntax Check

You can explore all the possibilities of MySQL here.

• MySQL docs