MySQL Database with Python Tutorial Part 3 - UPDATE, DELETE, AND SELECT

Channel:
United States sentdex
Subscribers:
1,400,000
Published on ● Video Link: https://www.youtube.com/watch?v=1iHtAj85vcs


Category:
Tutorial
Duration: 12:19
49,724 views
148

Python + MySQL in playlist: http://www.youtube.com/watch?v=lhU2OZCKXhQ&feature=share&list=PLQVvvaa0QuDfhTF3Zfyzc_yD-Mq9iTp4G&index=26

Here, you are shown how to update, delete, and select data from a database. The UPDATE command allows you to modify pre-existing data. This can be useful is say a user wishes to change their username on your website. The DELETE command is self-explanatory, it deletes things. Finally, the SELECT command is used as a sort of "find" to find data that matches the SQL query you feed it.

This is an tutorial for using MySQL with the Python programming language and the MySQLdb import. This video covers how to update data in tables, how to delete data from your database, and how to retrieve/select data from your database with Python.


Sentdex.com
Facebook.com/sentdex
Twitter.com/sentdex



Other Videos By sentdex


2013-11-27Python: Graphing the Center of Gravity Stock Indicator in Matplotlib
2013-11-27Python: Programming Center of Gravity Stock Indicator 2
2013-11-27Python: Center of Gravity Stock Indicator 1
2013-11-27Python: Graphing Bollinger Bands 3 Programming in Python, and Graphing in Matplotlib
2013-11-27Python: Calculating Bollinger Bands 2 Programming in Python, and Graphing in Matplotlib
2013-11-27Python: Bollinger Bands 1 Programming in Python, and Graphing in Matplotlib
2013-11-27Python Standard Deviation part 2: Programming in Python, and Graphing in Matplotlib
2013-11-27Python Standard Deviation part 1: Programming in Python, and Graphing in Matplotlib
2013-11-26Streaming Tweets from Twitter API v1.1 into MySQL Database with Python
2013-11-26MySQL Database with Python Tutorial Part 4 - Inserting Variables as Data
2013-11-26MySQL Database with Python Tutorial Part 3 - UPDATE, DELETE, AND SELECT
2013-11-26MySQL Database with Python Tutorial Part 1 - Intro
2013-11-26MySQL Database with Python Tutorial Part 2 - creating tables and inserting data
2013-11-26Aroon Oscillator Calculation, Programming in Python, and Graphing in Matplotlib
2013-11-26Python: Graphing The Aroon Indicator in Matplotlib - Mathematics and stock indicators 18
2013-11-26Python: Programming The Aroon Indicator - Mathematics and stock indicators 17
2013-11-26Aroon Indicator - Mathematics and stock indicators in Python 16
2013-11-24Python: Graphing Average Directional Index (ADX) 5 Directional Movement System Calculation
2013-11-24Python: Average Directional Index (ADX) 4 Directional Movement System Calculation
2013-11-24Python: Average Directional Index (ADX) 3 Directional Movement System Calculation
2013-11-24Python: Average Directional Index (ADX) 2 Directional Movement System Calculation


Tags:
Python (Software)
Data (Website Category)
MySQL (Software)
Database (File Format Genre)
Technology
Tutorial
How-to (Media Genre)
UPDATE
DELETE
SELECT
mysqldb
Management
data
storage
SQL
Python (Programming Language)
Database (Software Genre)