5 Python Flask CRUD Application Inserting Data In Mysql Database

Support me in Patreon

Join Free Programming Courses

My Affiliate Books:
Building REST APIs with Flask

Full Stack Web Development with Flask

Please Subscribe The Channel, This is our fifth video in python flask creating a crud web application in this video we are going to cover how you can insert data to mysql database, before this you should have wampserver because we are using wamp server and after this you should import from flask-mysql Mysql

installing flask framework
pip install flask
pip install flask-mysql

Download The Source Code From Github

Download Wamp Server

Download Pycharm IDE Comunity Edition

Download Python 3.6

Dow You Want Learn More In Python Than Watch These Playlists

Tkinter Application Development Playlist

Complete Video Tutorial For PyQt5 Application Development

Pyglet Tutorial For Multimedia Applications And Game Development

Python Opengl Programming With Pyopengl

Python For Data Science Playlist

Pyqt5 And Qt Designer Making Rich Text Editor

Developign QtQuick C++ Applications

[fatimaanjum]

thank you very much for this tutorial😁😃

[paolarangelvega]

Hi thanks for your video, i have a problem with "POST" when i tryed to insert data i got "Method Not Allowed
The method is not allowed for the requested URL." :( help

[madhusudanj]

open terminal in the ide and use command pip install flask-mysqldb

[wallawalla]

Nice video. How to create link for 'name example jhon' that can redirect us to a page which contain his data like email, etc that added before

[NishanaWebCreation]

hello sir mysqldb can not install in linux how to install please help me

[samriddhiagarwal]

Is there any way possible to link it to postgres sql instead of mysql?

[shilpak]

Please share a vedio about searching functionality with this

[deepikabhardwaj]

Sir show
Bad Request
The browser (or proxy ) sent a request that this server could not understand.
This show after insert tha data

[Reasonable]

Hi Parwiz, great video. I want to know how to include a dropdown menu in insert data and update data. I tried bootstrap class="dropdown" but some how no action is performed when i click on the button. Thanks in advance.

[FidaaAhmad]

what is the solution of this !!
Error: 'NoneType' object has no attribute 'cursor'

[herzoncaliwara]

When i'm insert the data it not work

----> (1045, "Access denied for user 'root'@'localhost' (using password: NO)")

[TheAbhinav]

Hey!! the python module mysqldb doesn't exist. I'm using flask-mysql and I cannot connect to database when I press insert!!

[krishnachaitu]

hi I am unable to connect to MYSQL DB
I have followed your code but a bad server error reported continuously
I am doing one project so I need to get the server success

[anchitagarwal]

how to add date in mysql table using flask?

[blockcoder]

In /insert route, return is "Index" means for...?

[renzmarrionperez]

it said that field id doest have default value how to fix this

[madalinamada]

How can import data from an Excel file into database (FLASK)? Thx :)

[shubhamgurjar]

from flask_mysqldb import MySQL
ModuleNotFoundError: No module named 'flask_mysqldb'
any solution?

[sunilrajput]

ImportError: No module named 'flask_mysql' error

[kevenoshea]

Hi, I really hope someone can answer my question. I have been trying to solve for hours with no success.

The error I receive when I run the app is : Could not build url for endpoint 'insert'. Did you mean 'Index' instead?

Any help would be great :)

Thanks !