Скачать или смотреть MySQL Load Data Infile with CSV | MySQL XAMPP using Command Prompt and phpmyadmin

In this video, you will learn how to use the MySQL Load Data Local Infile command, work with MySQL XAMPP using the Shell or Command Prompt (CMD), work with CSV files, create a database, create a table, create your own CSV file, load data into a table and display data from a table. You will work with google play store CSV data and use the PHPMYADMIN web interface GUI.

Timestamp
00:00:00 - Introduction to video
00:01:10 - Starting up XAMPP
00:01:23 - Starting Apache and Start MySQL Server
00:01:36 - Opening Shell (Command Prompt)
00:01:50 - Logging into the MySQL Server
00:03:16 - Creating a database
00:04:09 - Creating a table (members)
00:06:40 - Creating a CSV file
00:11:20 - Loading a CSV file into a table (members table)
00:14:41 - Displaying data from a table (members table)
00:15:40 - Working with the google play store CSV data
00:20:20 - Using the MySQL Load Data Local Infile function (google play store CSV file)
00:25:10 - Using phpmyadmin

Web link to the google play store csv file used in the video
https://www.kaggle.com/lava18/google-...