Its essential thing to knowing, how to reset the wordpress password from Mysql server without following traditional method. Because your site may hacked, you may forgot your admin password and its email id to reset the password, you are no longer able to login into wordpress using login credentials. This method will very useful to …
Category: MySQL
Permanent link to this article: https://blog.openshell.in/2013/09/how-to-reset-a-wordpress-password-from-mysql-server/
Aug 28
Find number of working days between two dates in Mysql
This which helps to find number of working days between two dates in Mysql. There is no specific or inbuilt function in mysql, For that we need to use the SQL query as below. [sql] SELECT 5 * ((DATEDIFF(@end_date, @start_date) ) DIV 7) + MID(‘0123455501234445012333450122234501101234000123450’, 7 * WEEKDAY(@start_date) + WEEKDAY(@end_date) + 1, 1) [/sql] For …
Permanent link to this article: https://blog.openshell.in/2013/08/find-number-of-working-days-between-two-dates-in-mysql/
Aug 04
MySQL Error – SQL_BIG_SELECTS
While executing JOIN SQL query in live server, i got the following error. [code] The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay: [/code] To resolve this error, I have used the following SQL query before executing the JOIN SQL query. …
Permanent link to this article: https://blog.openshell.in/2013/08/mysql-error-sql_big_selects/
May 02
Mysql GROUP_CONCAT
MySQL has useful extention to the GROUP BY operation – function GROUP_CONCAT: GROUP_CONCAT(expr) – This function returns a string result with the concatenated non-NULL values from a group. Returns NULL when there are no non-NULL values. Where it can be useful? For example to get array without looping inside the code, In single SQL query …
Permanent link to this article: https://blog.openshell.in/2013/05/mysql-group_concat/
Sep 22
Disable foreign key checks in MySQL
Disabling foreign key checks in MySQL is usefull when you are dealing with tables that use foreign keys (InnoDB engine). You can not delete (drop) multiple tables, a parent table or a child table until you disable foreign key checks four your current database. The sql command to disable foreign key checks is: [sql]SET FOREIGN_KEY_CHECKS …
Permanent link to this article: https://blog.openshell.in/2012/09/disable-foreign-key-checks-in-mysql/
Jul 20
Segmentation fault with rake db:create in ruby on rails
Whenever we invoke rake db:migrate, getting segmentation fault error. Segmentation fault ruby 1.9.1p430 (2010-08-16 revision 28998) [i386-mingw32] Code Aborted probably a bug in our database connectivity DLL file Place this linmysql.dll file within your ruby/bin folder. If the file exists already, replace that file by this file. Download libmySQL.dll
Permanent link to this article: https://blog.openshell.in/2012/07/segmentation-fault-with-rake-dbcreate-in-ruby-on-rails/
Sep 19
PHP MYSQL ORDER BY Multiple Columns
If you want to Order 2 or more columns in SQL Query. When ordering by more than one column, the second column is only used if the values are identical with the onces in the first column. Example [sql] ‘Order by Column ORDER BY COLUMN1, COLUMN2 [/sql] Order 2 or more columns with different orders …
Permanent link to this article: https://blog.openshell.in/2011/09/php-mysql-order-by-multiple-columns/
Jun 13
Create an RSS feed with PHP
Having an RSS feed on your website is a great way of sharing your content with the rest of the Internet. It’s not a new technology and it’s probably something that you use on a daily basis. If you have a blog or use any form of CMS, that software will most likely handle the …
Permanent link to this article: https://blog.openshell.in/2011/06/create-an-rss-feed-with-php/
Jun 09
Guide to MySQL database Engine.
A MySQL database gives you a choice of database engines and an easy way to switch them. Default MySQL Engine would be enough for most of your application but in certain circumstances where the other available engines may be better suited to the task at hand. Choose your engine The number of database engines available …
Permanent link to this article: https://blog.openshell.in/2011/06/guide-to-mysql-database-engine/
May 09
Excel to MySQL using Java
Target Audience: Java Developers, Database Developers What should you know already? Basics of Java, JDBC Excel to MySQL conversion can be done using LOAD DATA INFILE command as I discussed in Excel to MySQL blog. But that command is inadequate when you need to read the excel cell value and making some calculations or concatenations …
Permanent link to this article: https://blog.openshell.in/2011/05/excel-to-mysql-using-java/