November 15, 2022 in Laravel, MySql
$articles = DB::table('articles')
->select('articles.id as articles_id', ..... )
->join('categories', 'articles.categories_id', '=', 'categories.id')
->join('users', 'articles.user_id', '=', 'users.id')
->get();October 8, 2022 in MySql, Ubuntu
For ubuntu (i used ubuntu 12.04), the default phpmyadmin apache configuration can be found at /etc/phpmyadmin/apache.conf
You can open it by type sudo nano /etc/phpmyadmin/apache.conf and change the third
Alias /yournewalias /usr/share/phpmyadminTo restart apache service
sudo service apache2 restart
August 19, 2022 in MySql
Get the department name and number of employees in the department
SELECT department_name AS 'Department Name',
COUNT(*) AS 'No of Employees'
FROM departments
INNER JOIN employees
ON employees.department_id = departments.department_id
GROUP BY departments.department_id, department_name
ORDER BY department_name;Department Name No of Employees
Accounting 2
Administration 1
Executive 3
Finance 6
Human Resources 1
IT 5
Marketing 2
Public Relations 1
Purchasing 6
Sales 34
Shipping 45August 17, 2022 in MySql, Tips and Tricks
Xampp Users
xampp\phpMyAdmin\$cfg['ExecTimeLimit'] = 300;$cfg['ExecTimeLimit'] = 900; (or 0 for unlimited)Important: setting the execution time limit to unlimited is not recommended.
July 24, 2022 in MySql, Ubuntu
remove mysql install in centos 7
yum remove mysql
yum remove mysql-server
yum clean allInstall MySQL server centos 7
yum install mysql mysql-server
OR
yum install mysql
yum install install mysql-serverJuly 20, 2022 in MySql
yum install mysql mysql-serverOR
yum install mysql
yum install install mysql-serverJuly 20, 2022 in MySql
yum remove mysql
yum remove mysql-server
yum clean allJuly 18, 2022 in MySql
DELETE FROM t1 USING users_15july t1 INNER join users t2 ON ( t1.email = t2.email )
May 12, 2022 in MySql
Use the following sql commands in phpmyadmin
UPDATE wp_options SET option_value = 'http://new-domain-name.com' WHERE option_name = 'home';
UPDATE wp_options SET option_value = 'http://new-domain-name.com' WHERE option_name = 'siteurl';
UPDATE wp_posts SET post_content = REPLACE(post_content,'http://old-domain-name.com','http://new-domain-name.com');
UPDATE wp_posts SET guid = REPLACE(guid,'http://old-domain-name.com','http://new-domain-name.com');April 26, 2022 in MySql, Ubuntu
sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf
sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
Then restarted mysql
sudo service restart mysql
