#INSERT INTO MYSQL FLASK INSTALL#

I'm able to connect to the database but when trying to insert data it is giving internal server error. I am also new to this but i have done lot of research then got this. I am trying to insert data into a MySQL table. MySQL If you use Windows you can use WAMP or XAMPP, if you are using Linux XAMPP is a good choice. You can use another py file for db connection and use that db connection anywhere in the project. Steps Create file upload form Upload the CSV using Flask Parse CSV file data Connect to the database Insert rows into a specific table in the database Stack we will use: Flask A Python Minimal (Micro) web frameworks. MySQL provides a number of useful statements when it is necessary to INSERT rows after determining whether that row is, in fact, new or already exists. As your project become bigger you dont have to make db conn again and again. you only need to push yr code to production. Print('Something is wrong with your database user name or password '.format(fail))

#INSERT INTO MYSQL FLASK INSTALL#

pip install Flask-MySQLdb Now we will need to import the required libraries: from flask import Flask from flaskmysqldb import MySQL Now we will create an app instance and instantiate this app using the MySQL (app) class. MYSQL_DATABASE_HOST = 'linktoyourdb' # eg to amazone db :- .Īfter that use pip3 install flask-mysql # app.pyĬursor.execute('SELECT * from yrtablename') The first thing we will do is to install a module called Flask-MySQLdb. MYSQL_DATABASE_DB = 'FlaskProject' # can be any # config.py you can put this file anywhere in the project in future you should not use only development environment, you will need to automatically set the env while in production env.įirstly we should make a file where it will check and set mysql config for production/development env and set the values to app.config. We can use mysql using app.config to set the configurations.

Insert into mysql flask