Question

Database querry for CSV

  • 15 February 2024
  • 1 reply
  • 21 views

Badge +2

can we update CSV file data using the query?

 

UPDATE [MissingCustomers.csv]

SET [PASS] = 'TARUNA'

WHERE [PASS] = 'NA';


1 reply

Userlevel 5
Badge +11

Hi @Prashant M ,

Yes, you can update

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

 

Reply