MySQL Check (Sample Notebook for preview ipynb

USE world;
SELECT * from city limit 5;

# LECTURE: Creating a Database - Part I here we are creating Sales Database

CREATE DATABASE IF NOT EXISTS Sales;

CREATE SCHEMA IF NOT EXISTS Sales;

#  use Sales database
USE Sales;

CREATE TABLE sales
(
    purchase_number INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
    date_of_purchase DATE NOT NULL,
    customer_id INT,
    item_code VARCHAR(10) NOT NULL

);

# %load R.py
"""
Created on Thu Mar  9 02:53:46 2023

@author: Administrator
"""

%load_ext rpy2.ipython

C:\Users\Administrator\anaconda3\lib\site-packages\rpy2\robjects\packages.py:367: UserWarning: The symbol 'quartz' is not in this R namespace/package.
  warnings.warn(

%%R
library(ggplot2)
p <- ggplot(iris, aes(Sepal.Length, Petal.Length, colour=Species)) + geom_point()
p

from matplotlib import pyplot as plt

#Plotting to our canvas

plt.plot([1,2,3],[4,5,1])

#Showing what we plotted

plt.show()

Resources:
+ https://www.educba.com/data-science/data-science-tutorials/mysql-tutorial/
+ https://www.w3schools.com/mysql/default.asp