BATCH: FOR LOOP with IF ELSE

Question

I need some help. I want to execute for loop with if-else statement but i got some error. This is my code

mysql -u%UserName% -N -B -e "SHOW DATABASES LIKE '%%sample%%';" | FOR /F %%D IN ('C:\Windows\System32\findstr /V "information_schema performance_schema"') DO (IF EXIST %pathx%\%%D (echo test) ELSE (echo fail))

The output is

< was unexpected at this time

it does not contain. SET path=C:\Users\neca\Desktop thats it sir. @npocmaka — xXxrk04
– xXxrk04, Commented Feb 11, 2015 at 6:53
this is just the output sir. < was unexpected at this time @Magoo — xXxrk04
– xXxrk04, Commented Feb 11, 2015 at 6:53
You are piping the output of the mysql command mysql -u%UserName% -N -B -e "SHOW DATABASES LIKE '%%sample%%';" into a for/f command. I've asked for a sample output of that mysql command. — Magoo
– Magoo, Commented Feb 11, 2015 at 7:22

Magoo · Accepted Answer · 2015-02-11 09:01:56Z

1

Your error report is incorrect. The output you are receiving is

( was unexpected at this time

You can't validly pipe output into a for statement. Change your code to

FOR /F %%D IN ('mysql -u%UserName% -N -B -e "SHOW DATABASES LIKE '%%sample%%';" ^| C:\Windows\System32\findstr /V "information_schema performance_schema"') DO (IF EXIST %pathx%\%%D (echo test) ELSE (echo fail))

answered Feb 11, 2015 at 9:01

Magoo

80.8k8 gold badges68 silver badges92 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

BATCH: FOR LOOP with IF ELSE

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related