mysql tutorial

Rename table in MYSQL

April 6, 2018April 6, 2018 eduguru 0 Comments how to rename mysql table, how to rename table in mysql, how to table rename, MySQL, mysql tutorial, Rename table in MYSQL

To rename a table in MySQL you just need to run a command named RENAME TABLE, the syntax is

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

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 Range Optimization – Where Clause

January 15, 2017 eduguru 0 Comments 'SELECT', MySQL, MySQL Range Optimization - Where Clause, mysql tutorial

In this post we will see how can we optimize where clause. Where clause restrict the result set to a

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)

mysql

mysql if function

February 26, 2016February 26, 2016 Satya Prakash 0 Comments if function mysql, MySQL, mysql if example, mysql if function, mysql if statement, mysql select, mysql tutorial, select mysql if

Syntax: IF(expr,if_true_expr,if_false_expr) MySQL IF function is control flow functions that returns a value based on a condition. The IF function

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