Python MySQL







googletag.cmd.push(function() { googletag.display('div-gpt-ad-1422003450156-2'); });



Python MySQL



❮ Previous
Next ❯


Python can be used in database applications.


One of the most popular database is MySQL.



MySQL Database


To be able experiment with the code examples in this tutorial, you should
have MySQL installed on your computer.


You can download a free MySQL database at
https://www.mysql.com/downloads/.



Install MySQL Driver


Python needs a MySQL driver to access the MySQL database.


In this tutorial we will use the driver "MySQL Connector".


We recommend that you use PIP to install "MySQL Connector".


PIP is most likely already installed in your Python environment.


Navigate your command line to the location of PIP, and type the following:




Download and install "MySQL Connector":



C:UsersYour NameAppDataLocalProgramsPythonPython36-32Scripts>python -m pip install
mysql-connector


Now you have downloaded and installed a MySQL driver.




Test MySQL Connector


To test if the installation was successful, or if you already have "pymongo"
installed, create a Python page with
the following content:



demo_mysql_test.py:



import mysql.connector

Run example »


If the above code was executed with no errors, "MySQL Connector" is installed and
ready to be used.




Create Connection


Start by creating a connection to the database.


Use the username and password from your MySQL database:



demo_mysql_connection.py:



import mysql.connector

mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  passwd="yourpassword"
)

print(mydb)

Run example »


Now you can start querying the database using SQL statements.





❮ Previous
Next ❯

-

Popular posts from this blog

Python Lists

<!-- main_leaderboard, all: [728,90][970,90][320,50][468,60] --> Python Lists ❮ Previous Next ❯ Python Collections (Arrays) There are four collection data types in the Python programming language: List is a collection which is ordered and changeable. Allows duplicate members. Tuple is a collection which is ordered and unchangeable. Allows duplicate members. Set is a collection which is unordered and unindexed. No duplicate members. Dictionary is a collection which is unordered, changeable and indexed. No duplicate members. When choosing a collection type, it is useful to understand the properties of that type. Choosing the right type for a particular data set could mean retention of meaning, and, it could mean an increase in efficiency or security. List A list is a collection which is ordered and changeable. In Python lists are written with square brackets. Example Create a List: thislist = ["apple", "banana", ...
Read more

Aion

Image
Aion - 6+ , 5417 Aion - . MMORPG, World of Warcraft, World of Tanks My Lineage II . CryEngine. , . : Aion https://ru.4game.com/aion/ Aion , . , , . , , . , , , . . , , , . . : . , . , , . , , . 12 , 2 : ( ). ( ). ( ). ( ) ( ). ( ). , . , : . . , . , , . . , , . Aion, , . , . , . : . . . . , : , , , , , . , , , . : Aion https://ru.4game.com/aion/install/ : . , . , . , Aion . , . . , . , . , , . . : . . . , ( !), MMORPG Aion . , . ...
Read more

JavaScript Array Iteration Methods

<!-- main_leaderboard, all: [728,90][970,90][320,50][468,60] --> JavaScript Array Iteration Methods ❮ Previous Next ❯ Array iteration methods operate on every array item. Array.forEach() The forEach() method Calls a function once for each array element. Example var txt = ""; var numbers = [4, 9, 16, 25]; numbers.forEach(myFunction); function myFunction(value, index, array) {     txt = txt + item + "<br>"; } Try it Yourself » Note that the function takes 3 arguments: The item value The item index The array itself Array.forEach() is not supported in Internet Explorer 8 or earlier: Method forEach() Yes 9.0 Yes Yes Yes Array.map() The map() method creates a new array by performing a function on each array element. This example multiplies each array value by 2: Example var numbers1 = [4, 9, 16, 25]; var numbers2 = numbers1.map(myFunction); function m...
Read more