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-...
Watch video MySQL Load Data Infile with CSV | MySQL XAMPP using Command Prompt and phpmyadmin online without registration, duration hours minute second in high quality. This video was added by user ZebraCode 09 December 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 4,809 once and liked it 68 people.