求助：通过批处理脚本读取CSV生成带变量WHERE子句的SQL脚本

Hey there! Let's work through this together since you're just getting started with batch scripting. I'll show you a straightforward way to pull the first column from your CSV and generate that MySQL script you need.

1. Batch Script to Extract CSV First Column & Build WHERE Clause #

First, here's a batch script that handles reading your CSV and constructing the IN clause for your SQL. I've added comments to explain each part so you can tweak it to fit your exact setup:

@echo off
setlocal enabledelayedexpansion

:: Replace this with your actual CSV file path
set "csvFile=your_data.csv"
:: Initialize our WHERE clause variable
set "inValues="

:: Loop through each line, grabbing only the first comma-separated field
for /f "tokens=1 delims=," %%a in (%csvFile%) do (
    :: Uncomment and adjust this line if your CSV has a header row to skip
    :: if not "%%a"=="your_header_text" (
        :: Build the list of values for the IN clause
        if defined inValues (
            set "inValues=!inValues!, '%%a'"
        ) else (
            set "inValues='%%a'"
        )
    :: )
)

:: Generate the final MySQL script
echo SELECT * FROM your_target_table WHERE your_target_column IN (!inValues!); > final_query.sql

echo Done! Check final_query.sql for your generated MySQL script.
endlocal

Key Customization Tips: #

• Skip Headers: If your CSV has a header row (like a column name as the first line), uncomment the if not "%%a"=="your_header_text" block and replace your_header_text with the actual header value from your first column.
• Numeric vs String Columns: If the target MySQL column is numeric (not a string), remove the single quotes around %%a in the script (so it becomes set "inValues=!inValues!, %%a" and set "inValues=%%a").
• Quoted CSV Fields: If your first column values are wrapped in quotes (e.g., "1234"), add these lines inside the for loop right after grabbing %%a to strip the quotes:

  set "cleanVal=%%a"
  set "cleanVal=!cleanVal:"=!"
  

  Then use !cleanVal! instead of %%a when building inValues.

2. Example Output #

If your CSV first column looks like this:

user123
user456
user789

The generated final_query.sql will contain:

SELECT * FROM your_target_table WHERE your_target_column IN ('user123', 'user456', 'user789');

Quick Troubleshooting #

• Make sure your CSV uses commas as delimiters—if it uses tabs or another character, update the delims= value in the for loop (e.g., delims= for tabs).
• If your CSV file path has spaces, wrap the path in double quotes: set "csvFile=C:\My Files\data.csv".

内容的提问来源于stack exchange，提问作者Rokrman22