Category: SQL

Categories
Data Science Programming SQL

How we built Data Science Web App “Route Planner X” on AWS infrastructure

Continue reading “How we built Data Science Web App “Route Planner X” on AWS infrastructure”
Categories
Data Science JavaScript Programming React SQL

[Guide] Building Data Science Web Application with React, NodeJS, and MySQL

Continue reading “[Guide] Building Data Science Web Application with React, NodeJS, and MySQL”
Categories
Data Science Programming SQL

How to import data from MySQL database into Pandas Data Frame

It is easy to load CSV data into Python’s Pandas Data Frame. I always think this is also the case for loading MySQL into Data Frame. However, it turns out to be quite troublesome.

Continue reading “How to import data from MySQL database into Pandas Data Frame”
Categories
Programming SQL

[MySQL] Reset & Import Database in MySQL using Command Line

Sometimes client’s server doesn’t has PHPMyAdmin installed (and it is 11MB, too big in my opinion), and I have to import database to deploy website from localhost to production server. Thus, I need to find a way to import SQL file directly in command line.

Continue reading “[MySQL] Reset & Import Database in MySQL using Command Line”