postgresql: remove single quotes after table import.
After several iterations this one worked for me: UPDATE "Import" SET tracking_number = NULL where tracking_number ='';
Category: databases
pgsql: pgdump authentication
create .pg_pass file on the root folder of the user that will run the pgsql command for example. /root or /user […]
mysql: assign opportunities to user based on parent account
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 = […]
mysql: assigned calls to user based on parent account or lead
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 […]
mysql: update or delete with join operators (contacts)
Same as previous post but this time with Accounts instead of Leads. List the Contacts related to the Accounts this employee has assigned: […]
mysql: update or delete with join operators
I'm trying to update some records on Table C (contacts.assigned_used), but I have a Join from Table A (leads) and passing through […]
mysql: query to find "orfan" notes on sugarcrm
The following Query get me a List of the Lines I want to Delete, but I cannot execute a query to Delete […]
pgsql: list and remove triggers
I want to delete directly on the PgSQL database on my OpenBravo application but it has a los of triggers that prevent […]
pgsql: cannot delete line on table.
This happens when I try to manually delete a record on the Database ERROR: update or delete on table "m_inoutline" violates […]
mysql: update database
SELECT * FROM crm_em.notes WHERE name LIKE '%cierre%'; UPDATE crm_em.notes SET name = 'Nota de Cierre' WHERE name LIKE '%cierre%';