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

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

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

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

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

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, 2014April 5, 2023mysql

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

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

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/