MYSQL

 MYSQL

1.MY SQL BASIC Click here

2. MYSQL JOINS click Here

3. MYSQL WITH PYTHON

4. MYSQL PRACTICE QUESTION CLICK HERE

--------------------------------------------------------------------------------------------------------------------------------

                                        MySql With Python

Step -1 Install Python

                pip install mysql-connector-python

 Step 2  Connect Database and use Module

        

    Step 3 Execute Queries 

        

Step 4 Database selected

Step 5 Create Table Queries

cursor.execute("CREATE TABLE office_staff id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,

person_name (name VARCHAR(255), phone_number VARCHAR(255))")

Step 6 Insert Values

Step 7 Database Fetch Function

Step 8