CSV to MySQL with PowerShell

preview_player
Показать описание
Load a CSV file into PowerShell and create the table if you want!!

Code repository

My photo site

How to support my channel
1 - Like videos
2 - Subscribe to my channel
  1. Tom's Tech Show!
  2. PowerShell
  3. MySQL
  4. CSV
Рекомендации по теме
CSV to MySQL 0:14:44

CSV to MySQL with PowerShell

How to Import 0:03:12

How to Import csv to SQL Server with Powershell Core

PowerShell Tutorial: Import 0:14:30

PowerShell Tutorial: Import & Export CSV Data 🔥⌨️ DevOps | Automation | Developer

Import CSV file 0:11:04

Import CSV file to MySQL with PowerShell Process

Working with MySQL 0:04:38

Working with MySQL Using PowerShell | PowerShell Tutorial

PowerShell & MySQL 0:14:44

PowerShell & MySQL Demo

Connect MySQL Database 0:03:55

Connect MySQL Database to Powershell

CSV File Handling 0:21:16

CSV File Handling with PowerShell

Powershell SQL Connection 0:04:58

Powershell SQL Connection | Execute Queries

How to connect 0:01:26

How to connect to MySQL server in windows powershell command line

MySQL Dump with 0:13:35

MySQL Dump with PowerShell

Use This Trick 0:00:44

Use This Trick to Merge CSV Files Together Instantly

PowerShell MySQL Verbindung 0:07:46

PowerShell MySQL Verbindung erstellen

Windows PowerShell - 0:37:45

Windows PowerShell - How to - MySQL

Connecting Powershell to 0:09:34

Connecting Powershell to MySQL

mysql 1 from 0:05:53

mysql 1 from powershell

SQL Database Queries 0:11:02

SQL Database Queries using Powershell

Automate Active Directory 0:23:43

Automate Active Directory with PowerShell Tutorial 2 : Importing CSV

Backup Mysql com 0:01:10

Backup Mysql com Script Powershell

SQL export data 0:02:35

SQL export data to csv (Automatically)

95 How to 0:04:13

95 How to import a csv file into SQL Server using bulk insert SQL query

How to get 0:11:59

How to get SQL Server output in text tab delimited using PowerShell

How to Connect 0:05:37

How to Connect SQL Server with Powershell

Importing CSV with 0:02:17

Importing CSV with Powershell on Ubuntu

Комментарии
Автор

got a question (edit: no need to answer!) : why this MySQL module and not the MySQL NET Connector everyone else seem to use? | i got stuck because the system.time(dd/mm/yyyy) format is different than the databank.time format (yyyy/mm/dd) and there is no parameter to pass it | in the time the sysadmin made the change, i implemented the NET connector | thank you for the CSV part, but sadly its no export to csv^^

realmcafee
Автор

Hi Tom, would you mind explaining how the authentication works in the script please?
I'm trying to configure my credentials in the script, but that fails.
I can however authenticate to the DB when using the PS Shell, so I'm a little lost.
Thanks for the video,

LindsayForbes
Автор

hi how do i do this using LOAD DATA LOCAL INFILE in powershell and mysql

juanpabloalvarezsanchez
Автор

Hi Tom
Thanks so much for explaining really good your script.
I was wondering if you could help me out with a quickly thecnical concept, since I dont find the solution.
I have a .ps1 which import (bulk load) huge csv (more than 1 gb) into SQL server (MSQLSMS). But the csv are enclosed in quotes for the string fields. So, the quotes is being imported to SQL as well. When I imported the csv into a variable, in your example would be $csvdata, I did a foreach and try to replace ' " ', ' '. But it is not working.
Could you help me out? I also saw I can contribute with paypal. Thats great since I am sure you help a lot of people with your codes.
Thanks Tom

franesp