Skip to content

ricardo malla's blog

  • home
  • remote cto
  • it
    • o/s
    • databases
    • software
  • life
    • gamechangers
    • tv series
    • blogs to follow
    • books to read
    • health
  • ideas
  • notes
  • hire us
Search

ricardo malla's blog

Close menu
  • home
  • remote cto
  • it
    • o/s
    • databases
    • software
  • life
    • gamechangers
    • tv series
    • blogs to follow
    • books to read
    • health
  • ideas
  • notes
  • hire us

ricardo malla's blog

Search Toggle menu

Category: mysql

August 8, 2021August 8, 2021mysql

mysql: create local user and remote user

  CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypass'; GRANT ALL ON *.* TO 'myuser'@'localhost';   CREATE USER 'myuser'@'%' IDENTIFIED BY 'mypass GRANT ALL […]

April 17, 2021April 17, 2021mysql, uncategorized

mysql: extract domain from email

  SUBSTR(email_addresses.email_address, INSTR(email_addresses.email_address, '@') + 1)

April 17, 2021April 17, 2021mysql

mysql: capitalize first word of all words

credits to: http://joezack.com/2008/10/20/mysql-capitalize-function/   create a function:   CREATE FUNCTION CAP_FIRST (input VARCHAR(255)) RETURNS VARCHAR(255) DETERMINISTIC BEGIN DECLARE len INT; DECLARE i […]

March 20, 2021March 20, 2021mysql

mysql: min value per group

surprisingly, to find the min date per company, which is a super basic query, on mysql you need to do a complicated […]

November 25, 2019March 24, 2021mysql

mysql: remove only_full_group_by and make it persistent

update it from the console (will revert upon reboot) from the command line go to the mysql console mysql then edit the […]

September 22, 2018November 30, 2019phpmyadmin

phpmyadmin: deprecation notice

    sudo apt-get remove --purge phpmyadmin php-gettext php-mbstring -y sudo apt-get autoremove -y sudo apt-get update sudo apt-get install phpmyadmin php-gettext […]

May 9, 2017May 9, 2017mysql

phpmyadmin: securing web console

I installed PHPMyadmin to check my help manage my database, eventhough I also use the desktop program MySQL Workbench, I fell sometimes […]

October 4, 2016October 4, 2016mysql

mysql: enable logging

mysql> show variables like '%log%'; Recreate the log files I deleted by mistake. It appears the MySQL does not recreate them automatically. […]

September 16, 2016mysql, postgresql

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

September 16, 2016mysql, postgresql

sql query: remove leading and trailing double quotes

UPDATE m_product SET name = TRIM(BOTH '"' FROM name) WHERE m_product_id = '1128493' UPDATE m_product set name = replace(name, '""', '"') WHERE […]

Posts navigation

1 2 >

Recent Posts

  • mysql: blocked because of many ...
  • bitnami: restart services
  • microsoft graph visual url test...
  • python: set $PYTHONPATH for env...
  • python: convert result from pym...
  • google cse: different results w...
  • wordpress: style of child theme...
  • mysql: like multiple values
  • prestashop: disable jquery css ...
  • idempiere: creating financial r...

Categories

  • adempiere (1)
  • android (1)
  • apache (3)
  • asterisk (11)
  • backup strategies (3)
  • blogs to follow (1)
  • centos (1)
  • documentaries (1)
  • dropbox (2)
  • elasticsearch (1)
  • email marketing (3)
  • emfs (1)
  • esxi (1)
  • fail2ban (1)
  • finance (1)
  • gamechangers (5)
  • gamechanging concepts (2)
  • google (1)
  • google cloud (1)
  • health (1)
  • history (1)
  • ideas (1)
  • idempiere (16)
  • it (1)
  • java (8)
  • laptop (1)
  • legal (1)
  • life (2)
  • magento (6)
  • management (1)
  • mautic (9)
  • microbiome (1)
  • microsoft stack (5)
  • mysql (18)
  • nginx (1)
  • notes (1)
  • o/s (1)
  • openbravo (37)
  • openerp/odoo (6)
  • openvpn (1)
  • outlook (1)
  • pentaho (1)
  • pfsense (6)
  • php (4)
  • phplist (1)
  • phpmyadmin (1)
  • pingdom (1)
  • podcasts (2)
  • podcasts (1)
  • podcasts (1)
  • postfix (1)
  • postgresql (19)
  • prestashop (22)
  • procurement (1)
  • python (3)
  • sales (1)
  • scrapy (1)
  • seo (1)
  • shell (3)
  • software (3)
  • splunk (1)
  • sugarcrm (19)
  • synology (2)
  • sys admin (2)
  • talend (3)
  • tibco - jasper reports (20)
  • tv series (1)
  • ubuntu (26)
  • uncategorized (195)
  • unifi (3)
  • virtualbox (1)
  • virtualization (1)
  • vmware (5)
  • wordpress (2)
  • zoiper (1)
© 2023 ricardo malla's blog. Proudly powered by Sydney