eduguru 
MySQL interval values are used mainly for date and time calculations. INTERVAL {value of unit} {types of interval} INTERVAL is a MySQL keyword and this is case sensitive. This should be used in CAPITAL Later Only {value of unit} is a expression or value like 1,2,3,4 or any expression which result in value. {type of … Read more
Very often we need to extract last 1 month, 2 months data from mysql DB. Here we will show easy way to get the data of given interval. SELECT * from testtable WHERE startdate BETWEEN DATE_SUB(NOW(), INTERVAL 1 MONTH) AND DATE_SUB(NOW(), INTERVAL 2 MONTH) The above query will return records whose order date is between one and … Read more
The mkdir command in the Unix, DOS, OS/2, and Microsoft Windows operating systems and in the PHP scripting language is used to make a new directory.
UNEXPECTED INCONSISTENCY; RUN fsck MANUALLY means there is some file system error in the disk. Try this: fsck /dev/sda1 (where /dev/sda1 is the partition mentioned) And enter Yes(y) to all errors Then reboot and it should be fine.
There is a minor difference between the working of while and do while loops. This difference is the place where the condition is tested. The while tests the condition before executing any of the statements within the while loop. As against this, the do-while tests the condition after having executed the statements within the loop. … Read more
The myisamchk utility gets information about your database tables or checks, repairs, or optimizes them. myisamchk works with MyISAM tables (tables that have .MYD and .MYI files for storing data and indexes). The use of myisamchk with partitioned tables is not supported. How to run this Utility – myisamchk myisamchk [options] tbl_name The options specify … Read more
The keyword continue allows us to take up the control to the beginning of the loop, bypassing the statements inside the loop, which have not yet been executed. When continue is encountered inside any loop, control automatically passes to the beginning of the loop. A continue is usually associated with an if. Let’s consider the following … Read more
Try to add this line in [mysql] in my.cnf max_allowed_packet = 16M
Putty : Connect Linux Server from Windows Computer Here is video to show how to connect Linux server from Window Putty is free tool to connect Linux server. You can down putty from below link: https://www.chiark.greenend.org.uk/~sgtatham/putty/latest.html
While writing C program, We often come across situations where we want to jump out of a loop instantly, without waiting to get back to the conditional test. The keyword break allows us to do this. When break is encountered inside any loop, control automatically passes to the first statement after the loop. A break … Read more