MySQL : Dumping Data in SQL Format with mysqldump
MySQL : Dumping Data in SQL Format with mysqldump By default, mysqldump writes information as SQL statements to the standard output.
Read more
MySQL
RANGE Partitioning in MySQL
RANGE Partitioning in MySQL What is Partitioning? Partitioning is a way in which a database (MySQL in this case) splits
Read more How can I check MySQL engine type for a specific database?
MySQL engine type for a specific database SHOW GLOBAL VARIABLES LIKE ‘storage_engine’ [xyz-ihs snippet=”Discuss”]
Read more mysqld — The MySQL Server
mysqld, also known as MySQL Server, is the main program that does most of the work in a MySQL installation.
Read more Rename table in MYSQL
To rename a table in MySQL you just need to run a command named RENAME TABLE, the syntax is
Read moreInstall LAMP Server (Apache, MySQL, PHP) On RHEL, CentOS
LAMP is a combination of operating system and open-source software stack. The acronym LAMP is derived from first letters of
Read more mysql get date interval of 30 days
Very often we need to extract last 30 days, 7 days data from mysql DB. Here we will show easy way
Read more MySQL Interval
MySQL interval values are used mainly for date and time calculations. INTERVAL {value of unit} {types of interval} INTERVAL is
Read more mysql query get date of 1 month interval
Very often we need to extract last 1 month, 2 months data from mysql DB. Here we will show easy way to
Read more myisamchk — MyISAM Table-Maintenance Utility
The myisamchk utility gets information about your database tables or checks, repairs, or optimizes them. myisamchk works with MyISAM tables
Read more