PowerShell & MySQL Demo

preview_player
Показать описание
During This Demonstration, expert instructor Rafiq Wayani will demonstrate how to take a CSV file and import it into MySQL using PowerShell.
  1. Rafiq Wayani
  2. PowerShell
  3. MySQL
  4. automation
Рекомендации по теме
PowerShell & MySQL 0:14:44

PowerShell & MySQL Demo

Using PowerShell Core 0:13:11

Using PowerShell Core to Query MySQL

Windows PowerShell - 0:37:45

Windows PowerShell - How to - MySQL

MySQL Dump with 0:13:35

MySQL Dump with PowerShell

mysql 1 from 0:05:53

mysql 1 from powershell

Working with MySQL 0:04:38

Working with MySQL Using PowerShell | PowerShell Tutorial

Connect MySQL Database 0:03:55

Connect MySQL Database to Powershell

CSV to MySQL 0:14:44

CSV to MySQL with PowerShell

Windows PowerShell Automaticly 0:04:53

Windows PowerShell Automaticly Backup MySQL Databases on Windows with Tasks Management

Powershell SQL Connection 0:04:58

Powershell SQL Connection | Execute Queries

PowerShell MySQL Verbindung 0:07:46

PowerShell MySQL Verbindung erstellen

Windows : MySQL 0:01:26

Windows : MySQL Dump with PowerShell

Connecting Powershell to 0:09:34

Connecting Powershell to MySQL

Continuously deploying SQL 0:44:13

Continuously deploying SQL code using Powershell by Kirill Kravtsov

How to connect 0:01:26

How to connect to MySQL server in windows powershell command line

Backup Mysql com 0:01:10

Backup Mysql com Script Powershell

Conectar a MySQL 0:04:15

Conectar a MySQL desde PowerShell

Using PowerShell with 1:02:24

Using PowerShell with MariaDB (MySQL) ODBC (For Drexel INFO-365)

Is there a 0:01:41

Is there a way to run MySQL queries from Windows Powershell or Command Prompt?

you need to 0:24:25

you need to learn SQL RIGHT NOW!! (SQL Tutorial for Beginners)

PowerShell for SQL 1:28:40

PowerShell for SQL DBAs Demo Class

Powershell tutoriaali osa 0:17:43

Powershell tutoriaali osa 14 (MySQL connector)

Unlock the Secret 0:08:10

Unlock the Secret Power of PowerShell: Master MySQL Queries in Minutes

PDQ Live! : 0:33:01

PDQ Live! : How Do I Connect PowerShell To A Database?

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

You can optionally use the -Parameters parameter if you don't want to do string concatenation.

potatoradio
Автор

Great video. Any idea how to handle special characters like # and % when those are use in Column names on the table and CSV file? The ` (backtick) symbol seems to work in MySQL workbench, but can't get it to work when using my PS script like yours.

jimterpstra
Автор

This is helpful. Thanks for making this video....

prakashjha
Автор

Good video Rafiq Wayani, I have one question I'm using the csv with the decimal limiter, instead of an . and now i'm getting an error cause of this. How can I fix it?

trainergo
Автор

Your content is nice, but I have a question for you. Why do you yell all the time during your Coursera SQL Proficiency Course? Did you think your mic volume was low or something? Your voice here on this video is in a nice calm tone.

LeoAlexandre
Автор

at the 9 min mark trying the foreach after I press enter i receive this error not what you show any ideas ? PS C:\temp\tools> foreach ($user in $userdata)
Missing statement body in foreach loop.
+ CategoryInfo : ParserError: (:) [],
+ FullyQualifiedErrorId : MissingForeachStatement

abrickwo