CSV IMPORT MANUAL
Remove Commas from strings Truncate String Length using LEFT function in Excel Use CLEAN Function to remove unwanted breaks and non displaying characters
Remove Commas from strings Truncate String Length using LEFT function in Excel Use CLEAN Function to remove unwanted breaks and non displaying characters
UPDATE m_product SET name = TRIM(BOTH '"' FROM name) WHERE m_product_id = '1128493' UPDATE m_product set name = replace(name, '""', '"') WHERE m_product_id = '1128493'
Query to Select List: SELECT * FROM opportunities LEFT JOIN accounts_opportunities ON accounts_opportunities.opportunity_id = opportunities.id LEFT JOIN accounts ON accounts_opportunities.account_id = accounts.id WHERE accounts.assigned_user_id = '7077c616-4f2c-f966-d9b6-5581807bae86'; UPDATE Query: UPDATE opportunities x LEFT JOIN accounts_opportunities y ON y.opportunity_id […]
Select List of Calls to Update: SELECT * FROM calls LEFT JOIN accounts ON calls.parent_id = accounts.id LEFT JOIN leads ON calls.parent_id = leads.id WHERE ( accounts.assigned_user_id = '7077c616-4f2c-f966-d9b6-5581807bae86' OR leads.assigned_user_id = '7077c616-4f2c-f966-d9b6-5581807bae86' ) ; Update Query: UPDATE calls […]
Same as previous post but this time with Accounts instead of Leads. List the Contacts related to the Accounts this employee has assigned: SELECT contacts.* FROM accounts INNER JOIN accounts_contacts ON accounts.id = accounts_contacts.account_id INNER JOIN contacts ON accounts_contacts.contact_id = contacts.id […]