Add Hour Minute in DateTime Mysql

To add Hour in datetime column use the following query: UPDATE users SET `timestamp` = DATE_ADD(timestamp, INTERVAL 1 SECOND); UPDATE users SET `timestamp` = DATE_SUB(timestamp, INTERVAL 1 SECOND); UPDATE users SET `timestamp` = DATE_SUB(timestamp, INTERVAL 1 SECOND); UPDATE users SET … Readmore +

Category: MySql

Backups in mysql

Introduction:- It is important to back up your databases so that you can recover your data and be up and running again in case problems occur, such as system crashes, hardware failures, or users deleting data by mistake. MySQL offers … Readmore +

Category: MySql

MySQL Conversion Functions

Introduction :- These type of functions are used to convert a value from one data type to another. Conversions can be done between string, date, and numeric type of data. Following are the three conversion functions:- 1.Binary 2.Cast 3.Convert Example:- … Readmore +

Category: MySql

SHOW Statements and INFORMATION_SCHEMA

Introduction:- Several SHOW statements provide additional character set information. These include SHOW CHARACTER SET, SHOW COLLATION, SHOW CREATE DATABASE, SHOW CREATE TABLE and SHOW COLUMNS.INFORMATION_SCHEMA has several tables that contain information similar to that displayed by the SHOW statements.For example, … Readmore +

Category: MySql

Loading Data into a Table

Introduction:- After creating your table, you need to populate it. The LOAD DATA and INSERT statements are useful for this. Suppose that your pet records can be described as shown here. name owner species sex birth … Readmore +

Category: MySql