learn mysql

MySQL SUM function

March 11, 2019 Manisha Patel how to use sum in mysql, learn mysql, MySQL, mysql function, mysql sum, MySQL SUM function, mysql sum query, mysql sum query example, sum in mysql, sum in select query mysql

MySQL SUM function The SUM() function returns the total sum of a numeric column. The SUM() function is an aggregate function that allows you to

mysql

MySQL MIN() and MAX() Functions

March 3, 2019March 3, 2019 Manisha Patel learn mysql, MySQL, mysql function, mysql function example, mysql max function, mysql min function, MySQL MIN() and MAX() Functions

MySQL MIN() and MAX() Functions The MIN() function returns the smallest value of the selected column and the MAX()

mysql

Install mysql on centos linux

October 31, 2018 eduguru how to install mysql, Install mysql on centos linux, installation of mysql, learn mysql, mysql install, mysql o centos, mysql secure installation, secure installation mysql

Install mysql on centos linux Reference : https://blog.eduguru.in/linux-2/install-lamp-server-apache-mysql-php-on-rhel-centos-scientific-linux-6-56-4 Install MySQL MySQL is an enterprise class, open source, world’s second most used

mysql

MySQL conditional expression CASE

October 30, 2018 eduguru case in mysql, case query mysql, case when in mysql, conditional query in mysql, learn mysql, MySQL, mysql case condition, mysql case expression, mysql case statement, mysql conditional expression, MySQL conditional expression CASE, mysql query case when

MySQL conditional expression CASE MySQL CASE expression is a conditional expression that allows you to construct conditions inside a query such as SELECT or WHERE

mysql

mysql get date interval of 30 days

March 26, 2018March 26, 2018 Satya Prakash 0 Comments date - MySQL Query - Records between Today and Last 30, Getting mysql result from the last 30 days, How to select last 30 days dates in MySQL?, learn mysql, MySQL, mysql date between interval, mysql get data of date range, mysql get date interval of 30 days, mysql get date interval of 7 days, mysql query, mysql query get date interval, mysql select dates in 30-day range, mysql tutorial, Selecting 30 days or older entries using MySQL DateTime, Selects all rows with a start_date value from within the last date

Very often we need to extract last 30 days, 7 days data from mysql DB. Here we will show easy way

mysql

mysql query get date of 1 month interval

March 18, 2018March 23, 2018 eduguru 0 Comments learn mysql, MySQL, mysql interval, mysql query, mysql query get date of 1 month interval, use of interval in mysql query

Very often we need to extract last 1 month, 2 months data from mysql DB. Here we will show easy way to

mysql

myisamchk — MyISAM Table-Maintenance Utility

February 17, 2018 eduguru 0 Comments learn mysql, myisam, myisam table, myisam table check, MyISAM Table maintenance, MyISAM Table Maintenance Utility, myisamchk, myisamchk — MyISAM Table-Maintenance Utility, MySQL, mysql tutorial

The myisamchk utility gets information about your database tables or checks, repairs, or optimizes them. myisamchk works with MyISAM tables

mysql

MySQL substring function

April 12, 2016April 12, 2016 Satya Prakash 0 Comments database function, learn mysql, MySQL, mysql string function, MySQL substring function, mysql tutorial

MySQL SUBSTRING() returns a specified number of characters from a particular position of a given string. Syntax: SUBSTRING(str, pos, len)

Databse mysql

MYSQL Partitioning : What is and HOW To ?

August 15, 2014March 29, 2016 eduguru 3 Comments fname VARCHAR(30), hired DATE NOT NULL DEFAULT '1970-01-01', How to mysql partition, job_code INT, learn mysql, lname VARCHAR(30), MySQL, mysql partition, MYSQL Partitioning : What is and HOW To ?, PARTITION p1 VALUES LESS THAN (1996), PARTITION p2 VALUES LESS THAN (2001), PARTITION p3 VALUES LESS THAN MAXVALUE ); This allows to speed up e.g.: Dropping old data by simple: ALTER TABLE employees DROP PARTITION p0; Database can speed up a query like this: SELECT COUNT(*) F, separated DATE NOT NULL DEFAULT '9999-12-31', store_id INT ) PARTITION BY RANGE ( YEAR(separated) ) ( PARTITION p0 VALUES LESS THAN (1991), The idea behind partitioning isn't to use multiple servers but to use multiple tables instead of one table. You can divide a table into many tables so that you can have old data in one sub table and n, What is mysql partition, you define how the data is partitioned. Simple example from the MySQL Documentation: CREATE TABLE employees ( id INT NOT NULL

The idea behind partitioning isn’t to use multiple servers but to use multiple tables instead of one table. You can

Databse mysql

What is the best way to reduce the size of ibdata in mysql?

August 10, 2014April 8, 2016 eduguru 0 Comments best way to reduce the size of ibdata in mysql, ibdata, innodb, learn mysql, MySQL, mysql innodb, mysql learn, mysql tutorial, reduce the size of innoDB tables, reducr size of innoDB, size of innoDB table, What is the best way to reduce the size of ibdata in mysql?

The busiest file in the InnoDB infrastructure is /var/lib/mysql/ibdata1 This file normally houses many classes of information (when innodb_file_per_table is 0) Table