In MySQL one of the widely used modules is PyMySQL You can install this library

In mysql one of the widely used modules is pymysql

This preview shows page 20 - 21 out of 21 pages.

SQL Database such as MySQL or MS SQL. In MySQL, one of the widely used modules is PyMySQL You can install this library by running the ‘pip install pymysql’ in the anaconda prompt. After successful installation, the Python module for connecting to a SQL Server is the pyodbc module. The same procedure is done to install the pyodbc module. To import, import pymysql is used. CONLCUSION: This is quite hard to do since the queries are long and requires a lot of time to type but while I was doing this lab activity I observed that SQL Server Management System has more functions like Inline single table, multi-line table and scalar function in SSMS while MySQL uses scalar function only. The former also has a security tool which ensures the data security unlike the other that does not have any. Setting up the necessary configurations for connecting MySQL database and SQL Server database requires necessary drivers and modules/packages including pymysql and pyodbc. Creating a connection object can be imported from the module/package using configuration of the database management system you wish to connect to (MySQL to SSMS or vice versa). A cursor object can be created which can be imported from the
Image of page 20
module/package that serves as the SQL Controller by providing a method that will allow you to execute SQL Commands and Stored Procedures as well as handle retrieval of values from the database. RECOMMENDATION: I don’t have recommendation for this activity. LESSON LEARNED: After doing this laboratory activity I’ve learned how to setup the necessary configurations for connection to a MySQL database and SQL Server database using PyMySQL and the pyodbc module. Also, I was able to recall the lessons I’ve learned during my course CPE009 which is Object Oriented Programming where we used python and create graphical user interface or GUI. I was also able to differentiate SSMS from MySQL. MySQL enables developers to manipulate database files through binaries while running. It even allows the database files to be accessed and manipulated by other processes at runtime. But SQL Server does not allow any process to access or manipulate its database files or binaries. It requires users to perform specific functions or manipulate files by running an instance. Also, you can only use scalar function in MySQL while you can use Inline single table, multi-line table and scalar function in SSMS.
Image of page 21

You've reached the end of your free preview.

Want to read all 21 pages?

  • Fall '16

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask ( soon) You can ask (will expire )
Answers in as fast as 15 minutes
A+ icon
Ask Expert Tutors