Rename table in MYSQL
To rename a table in MySQL you just need to run a command named RENAME TABLE, the syntax is
Read more
mysql
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 MySQL Server gone away while inserting or deleting
Try to add this line in [mysql] in my.cnf max_allowed_packet = 16M
Read more MySQL : Introduction to MySQL
Birth Of MySQL MySQL started out with the intention of using the mSQL database system to connect to tables using fast
Read more quickly copy MySQL InnoDB database without using MySQL dump
For this process We should noted that there must have the same architecture on both machines. I.e. if we have 32 bit on
Read more mysqli_connect() – function php mysql db connect
The mysqli_connect() function opens a new connection to the MySQL server. Syntax: mysqli_connect(host,username,password,dbname,port,socket); Parameter Description host Specifies a host name
Read more show progress on MySQL DB Import
You can use Pipe Viewer to monitor mysql dump. If you don’t already have pv, you can install it with: yum
Read more