mysql – Page 2 – ricardo malla's blog

October 23, 2015mysql, sugarcrm

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 = 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 […]

October 23, 2015mysql, sugarcrm

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 = 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 […]

October 22, 2015October 22, 2015mysql

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: 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 […]

October 22, 2015October 22, 2015mysql

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 in intermediary Table C. The query to show the filtered Table C (which is what I want to […]

October 16, 2015October 16, 2015mysql, sugarcrm

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 them. SELECT * FROM notes right JOIN a26_proveedor_notes_c ON a26_proveedor_notes_c.a26_proveedor_notesnotes_idb = notes.id WHERE notes.deleted IS NULL

August 10, 2015mysql, sugarcrm

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%’;

February 8, 2014February 9, 2014mysql

mysql: external connection to database blocked

Cannot establish an external MySQL connection to the server. Error 1. Error 10061: connect to MySQL server failed Fixed it using the following solution (https://help.ubuntu.com/community/ApacheMySQLPHP) Solution 1. Set mysql bind address Before you can access the database from other computers in your […]

August 18, 2013April 16, 2021mysql

mysql: backup databases

Backups all databases mysqldump -u [user] -p[password] –all-databases > [filename].sql specific databases mysqldump -u [user] -p[password] [database_name] > [filename].sql specific database but omitting specific tables mysqldump -u [user] -p[password] [database_name] –ignore-table=db1.tbl1 –ignore-table=db2.tbl1 > [filename].sql restore mysql -u […]

April 5, 2013May 18, 2014mysql

mysql: relevant commands

Connect to Database Linux: mysql -u root -p Show All Databases: show databases; Reference: http://www.cyberciti.biz/faq/mysql-command-to-show-list-of-databases-on-server/