Left Join on mysql

SQL LEFT JOIN Syntax SELECT column_name(s) FROM table1 LEFT JOIN table2 ON table1.column_name=table2.column_name; or: SELECT column_name(s) FROM table1 LEFT OUTER JOIN table2 ON table1.column_name=table2.column_name; PS! In some databases LEFT JOIN is called LEFT OUTER JOIN. Example: You have a surveys table and a services table and the id’s are bothRead More…

IS my mysql database table Innodb or Mysiam

MariaDB [(none)]> show table status from admin_geek01; +—————————–+——–+———+————+——+—————-+————-+——————+————–+———–+—————-+———————+———————+———————+—————–+———-+—————-+———+ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | +—————————–+——–+———+————+——+—————-+————-+——————+————–+———–+—————-+———————+———————+———————+—————–+———-+—————-+———+ | 2qGr3sjm_commentmeta | MyISAMRead More…

Reset maria DB password on Plesk

Is it mysql or maria? # service mysqld status Redirecting to /bin/systemctl status mysqld.service mysqld.service Loaded: not-found (Reason: No such file or directory) Active: inactive (dead) ]# systemctl status mariadb.service mariadb.service – MariaDB database server Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled) Active: active (running) since Mon 2015-10-05 21:03:57 EST; 3min 30s agoRead More…

Install mtop on centos 6

Install RPMForge on CentOS 6 # wget http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm # rpm -Uvh rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm Import RPMForge Repository Key in CentOS 6 # wget http://dag.wieers.com/rpm/packages/RPM-GPG-KEY.dag.txt # rpm –import RPM-GPG-KEY.dag.txt Install Mtop in CentOS 6 Once you’ve installed and enabled RPMForge repository, let’s install MTOP using following YUM command. # yum install mtop ToRead More…