SQL query to change all customers currency to the same?

[jmginer]

Hi, some sql dev can give me the query please?

[Kian]

Hi

 

Yes but "change all customers currency to the same"... same to what? Ok open tblcurrencies and find the currency that you want to use. Copy its ID for example EUR -> ID: 1. Let's say that you want to set all customers with EUR. Use this query:

UPDATE currency FROM tblclients SET currency = '[b][color="#FF0000"]1[/color][/b]'

[jmginer]

I get error:

 

UPDATE currency FROM tblclients SET currency = '1';

 

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM tblclients SET currency = '1'' at line 1

[WHMCS JamesX]

The correct format of such a query would be:

UPDATE `tblclients` SET `currency` = '1';

That query will change the default currency of *all* of your clients to whatever currency you have with the ID of "1". This may or may not be something that I'd suggest doing though; depending.

[jmginer]

Thanks! is Ok.