Question

Database querry for CSV

  • 15 February 2024
  • 2 replies
  • 59 views

Badge +2

can we update CSV file data using the query?

 

UPDATE [MissingCustomers.csv]

SET [PASS] = 'TARUNA'

WHERE [PASS] = 'NA';


2 replies

Userlevel 6
Badge +15

Hi @Prashant M ,

Yes, you can update

UPDATE your_table_name
SET PASS = 'TARUNA'
WHERE PASS = 'NA';
 

 
Userlevel 3
Badge +7

Hi @Prashant M 

Were you able to solve this? I think this gives syntactical error even though the query is correct.

Reply