sql_notebook_text

test_notebook.sql

/*markdown
# MySQL vs. MSSQL

Typically in MSSQL we escape keywords by placing them in square brackets, but in MySQL it is not necessary. Sometimes it may cause errors.
*/

     SELECT *
       FROM `sakila`.`customer`
      LIMIT 10
;

/*markdown
I used the following in ChatGPT to create a new table:
```markdown
What MySQL statement will create a table called rental_history with the following columns:
- rental_id
- customer_id
- file_id
- rental_date
```
Below I will put the statement given by ChatGPT and the result.
*/

USE sakila;
DROP TABLE rental_history;

/*markdown
**USE the "USE" Command**: I just notied that in mySQL it's better to use the USE command to indicate which database we're talking about when using a SQL Notebook. May not be so necessary if using Jupyter notebook, but otherwise, this is better. 
*/

CREATE TABLE rental_history (
    rental_id INT AUTO_INCREMENT PRIMARY KEY,
    customer_id INT,
    file_id INT,
    rental_date DATE
);