Insert into a table or update if exists MySQL
Mysql 02-Jun-2023

Insert into a table or update if exists MySQL

Read More
Mysql 10-Jan-2023

Operation not allowed when innodb_forced_recovery > 0

Read More
60+ MySQL Interview Questions and Answers
Mysql 25-Apr-2022

60+ MySQL Interview Questions and Answers

Read More
Why Use MongoDB and When to Use It?
Nosql 11-Feb-2022

Why Use MongoDB and When to Use It?

Read More
MySQL Find Duplicate Records (Rows)
Mysql 08-Feb-2022

MySQL Find Duplicate Records (Rows)

Read More
Types of clauses in MySQL
Mysql 06-Jan-2022

Types of clauses in MySQL

Read More
MySQL - INDEXES
Mysql 16-Jun-2021

MySQL - INDEXES

Read More
MySQL - Regexps
Mysql 12-Jun-2021

MySQL - Regexps

Read More
TO_DAYS() Function Examples – MySQL
Mysql 09-Jun-2021

TO_DAYS() Function Examples – MySQL

Read More
FROM_DAYS() Function Examples – MySQL
Mysql 08-Jun-2021

FROM_DAYS() Function Examples – MySQL

Read More
Get First Day and Last Day of Current and Last Month MySQL
Mysql 07-Jun-2021

Get First Day and Last Day of Current and Last Month MySQL

Read More
LAST_DAY MySQL Function Examples
Mysql 05-Jun-2021

LAST_DAY MySQL Function Examples

Read More
NOW() MySQL Function | MySQL
Mysql 04-Jun-2021

NOW() MySQL Function | MySQL

Read More
Query For Get Data Of Last Day, Week, Month, YEAR – Mysql
Mysql 03-Jun-2021

Query For Get Data Of Last Day, Week, Month, YEAR – Mysql

Read More
Mysql Get Data Of Current Date, Week, Month, YEAR
Mysql 02-Jun-2021

Mysql Get Data Of Current Date, Week, Month, YEAR

Read More
MySQL YEARWEEK() Function Examples – MySQL
Mysql 01-Jun-2021

MySQL YEARWEEK() Function Examples – MySQL

Read More
WEEK MySQL Function Examples
Mysql 31-May-2021

WEEK MySQL Function Examples

Read More
SQL - Indexes
Sql Server 08-Sep-2020

SQL - Indexes

Read More
How to create Price Range Slider in jQuery & PHP with MySQL
Mysql 01-Mar-2019

How to create Price Range Slider in jQuery & PHP with MySQL

Read More
How to Search in MySQL using full-text indexing in PHP
Mysql 26-Feb-2019

How to Search in MySQL using full-text indexing in PHP

Read More
Most Popular Database Queries For an Interview
Mysql 23-Feb-2019

Most Popular Database Queries For an Interview

Read More
Docker Compose and App Deployment with MySQL
Mysql 22-Feb-2019

Docker Compose and App Deployment with MySQL

Read More
PHP With MySQL
Mysql 22-Feb-2019

PHP With MySQL

Read More
MySQL 8.0: Query Optimizer Takes Data Buffering into Account
Mysql 21-Feb-2019

MySQL 8.0: Query Optimizer Takes Data Buffering into Account

Read More
How to find database and table size in MySQL?
Mysql 20-Feb-2019

How to find database and table size in MySQL?

Read More
Write Set in MySQL 5.7: Group Replication
Mysql 19-Feb-2019

Write Set in MySQL 5.7: Group Replication

Read More
Making 30x performance improvements on Yelp’s MySQLStreamer
Mysql 18-Feb-2019

Making 30x performance improvements on Yelp’s MySQLStreamer

Read More
How to read Excel file & Insert data into MySQL Database using PHP
Mysql 16-Feb-2019

How to read Excel file & Insert data into MySQL Database using PHP

Read More
How to manage international languages in MySQL database
Mysql 13-Feb-2019

How to manage international languages in MySQL database

Read More
MySQL Shell 8.0.4: Introducing “Upgrade checker” utility
Mysql 11-Feb-2019

MySQL Shell 8.0.4: Introducing “Upgrade checker” utility

Read More
How to safely upgrade to MySQL 8.0 ?
Mysql 08-Feb-2019

How to safely upgrade to MySQL 8.0 ?

Read More
New Defaults in MySQL 8.0
Mysql 28-Jan-2019

New Defaults in MySQL 8.0

Read More
MySQL 8.0 : Digest Query Samples in Performance_Schema
Mysql 19-Jan-2019

MySQL 8.0 : Digest Query Samples in Performance_Schema

Read More
Docker Compose Setup for InnoDB Cluster
Mysql 16-Jan-2019

Docker Compose Setup for InnoDB Cluster

Read More
MySQL 8.0 Source Code Improvements
Mysql 15-Jan-2019

MySQL 8.0 Source Code Improvements

Read More
MySQL Cheat Sheet
Mysql 10-Jan-2019

MySQL Cheat Sheet

Read More
Announcing General Availability of MySQL 8.0
Mysql 09-Jan-2019

Announcing General Availability of MySQL 8.0

Read More
BEST NOSQL DATABASES 2019 – MOST POPULAR AMONG PROGRAMMERS
Nosql 08-Jan-2019

BEST NOSQL DATABASES 2019 – MOST POPULAR AMONG PROGRAMMERS

Read More
MySQL 8.0 – Announcing GA of the MySQL Document Store
Mysql 08-Dec-2018

MySQL 8.0 – Announcing GA of the MySQL Document Store

Read More
Big Data storage and streaming by MySQL NDB Cluster
Mysql 22-Nov-2018

Big Data storage and streaming by MySQL NDB Cluster

Read More
credorax payment processing mysql
Mysql 21-Nov-2018

credorax payment processing mysql

Read More
MySQL 8.0 – Welcome to the DevAPI!
Mysql 17-Jul-2018

MySQL 8.0 – Welcome to the DevAPI!

Read More
WealthObjects, a FinTech company offering
Mysql 29-Jun-2018

WealthObjects, a FinTech company offering

Read More
MySQL High Availability at GitHub
Mysql 27-Jun-2018

MySQL High Availability at GitHub

Read More
MySQL Connector/NET 8.0.11 is available as official MySQL NuGet packages
Mysql 22-Jun-2018

MySQL Connector/NET 8.0.11 is available as official MySQL NuGet packages

Read More
Reading the log positions of a snapshot consistently
Mysql 08-Jun-2018

Reading the log positions of a snapshot consistently

Read More
MySQL Cluster 7.6 is Generally Available
Mysql 02-Jun-2018

MySQL Cluster 7.6 is Generally Available

Read More
JSON, Emojis, GIS, And GraalVM: MySQL 8.0 Speaks To Modern Developers In Their Language
Mysql 23-May-2018

JSON, Emojis, GIS, And GraalVM: MySQL 8.0 Speaks To Modern Developers In Their Language

Read More
Mysql 09-Apr-2018

Test MySQL 8.0 right in your computer

Read More
Mysql 06-Apr-2018

MySQL 8.0: Changes and Expectations for Developers

Read More
TOP 10 MySQL 8.0 features for DBAs & OPS
Mysql 19-Feb-2018

TOP 10 MySQL 8.0 features for DBAs & OPS

Read More
MySQL Cluster 7.6.4 is out
Mysql 02-Feb-2018

MySQL Cluster 7.6.4 is out

Read More
How to find database and table size in MySQL?
Mysql 04-Jan-2018

How to find database and table size in MySQL?

Read More
Group Replication Features backported to MySQL 5.7
Mysql 25-Dec-2017

Group Replication Features backported to MySQL 5.7

Read More
MySQL Queries No Waiting
Mysql 09-Nov-2017

MySQL Queries No Waiting

Read More
Plan to improve the out of the Box Experience in MySQL 8.0
Mysql 01-Nov-2017

Plan to improve the out of the Box Experience in MySQL 8.0

Read More
MySQL 8 - Roles
Mysql 27-Oct-2017

MySQL 8 - Roles

Read More
SQL QUERY CHEAT SHEET
Mysql 16-Oct-2017

SQL QUERY CHEAT SHEET

Read More
MySQL 8.0 Will Bring Unicode 9.0, Schema-less JSON, Greater Geospatial Support
Mysql 09-Oct-2017

MySQL 8.0 Will Bring Unicode 9.0, Schema-less JSON, Greater Geospatial Support

Read More
What’s new in MySQL 8.0
Mysql 09-Oct-2017

What’s new in MySQL 8.0

Read More
Mysql 24-Aug-2017

Docker Secrets and MySQL Password Management

Read More
SWAP SEX FIELD
Mysql 11-Aug-2017

SWAP SEX FIELD

Read More
An Adventure in InnoDB Table Compression (for read-only tables)
Mysql 10-Aug-2017

An Adventure in InnoDB Table Compression (for read-only tables)

Read More
How large can MySQL Replication be in production?
Mysql 04-Aug-2017

How large can MySQL Replication be in production?

Read More
MySQL Connector/Net 8.0.8-dmr has been released
Mysql 26-Jul-2017

MySQL Connector/Net 8.0.8-dmr has been released

Read More
MySQL 8.0.2: Introducing Window Functions
Mysql 19-Jul-2017

MySQL 8.0.2: Introducing Window Functions

Read More
The MySQL 8.0.2 Milestone Release is available
Mysql 18-Jul-2017

The MySQL 8.0.2 Milestone Release is available

Read More
New Tool Identifies MySQL as Top Database in Software Stacks
Mysql 07-Jul-2017

New Tool Identifies MySQL as Top Database in Software Stacks

Read More
MySQL Documentation: Indexes in Release Notes
Mysql 05-Jul-2017

MySQL Documentation: Indexes in Release Notes

Read More
Stored procedures in PHP and MySQL
Mysql 29-Jun-2017

Stored procedures in PHP and MySQL

Read More
Howto make MySQL point-in-time recovery faster ?
Mysql 20-Jun-2017

Howto make MySQL point-in-time recovery faster ?

Read More
PHP With MySQL
Mysql 16-Jun-2017

PHP With MySQL

Read More
MySQL 8.0: New mysql-test-run option to minimize skipped tests in regression test runs
Mysql 12-Jun-2017

MySQL 8.0: New mysql-test-run option to minimize skipped tests in regression test runs

Read More
MySQL Documentation: Syntax Highlighting
Mysql 10-Jun-2017

MySQL Documentation: Syntax Highlighting

Read More
Evolving MySQL Compression?-Part 2
Mysql 02-Jun-2017

Evolving MySQL Compression?-Part 2

Read More
Evolving MySQL Compression?
Mysql 02-Jun-2017

Evolving MySQL Compression

Read More
MySQL Group Replication Demo
Mysql 26-May-2017

MySQL Group Replication Demo

Read More
How to login with LinkedIn oAuth2 in PHP and MySQL
Mysql 20-May-2017

How to login with LinkedIn oAuth2 in PHP and MySQL

Read More
MYSQL SERVER LOG MAINTENANCE
Mysql 19-May-2017

MYSQL SERVER LOG MAINTENANCE

Read More
Upgrading your MySQL Server Farm
Mysql 19-May-2017

Upgrading your MySQL Server Farm

Read More
MySQL Group Replication… synchronous or asynchronous replication ?
Mysql 17-May-2017

MySQL Group Replication… synchronous or asynchronous replication ?

Read More
MySQL Group Replication: about ack from majority
Mysql 15-May-2017

MySQL Group Replication: about ack from majority

Read More
HopFS: Scaling hierarchical file system metadata using NewSQL databases
Mysql 15-May-2017

HopFS: Scaling hierarchical file system metadata using NewSQL databases

Read More
Scaling Airbnb’s Experimentation Platform
Mysql 12-May-2017

Scaling Airbnb’s Experimentation Platform

Read More
MySQL InnoDB Cluster: Automated Installation with Puppet
Mysql 06-May-2017

MySQL InnoDB Cluster: Automated Installation with Puppet

Read More
WatchDog for MySQL Group Replication Servers
Mysql 06-May-2017

WatchDog for MySQL Group Replication Servers

Read More
MySQL InnoDB Cluster – What’s New in the Release Candidate
Mysql 28-Apr-2017

MySQL InnoDB Cluster – What’s New in the Release Candidate

Read More
MySQL InnoDB Cluster in Oracle Public Cloud: A Tutorial
Mysql 26-Apr-2017

MySQL InnoDB Cluster in Oracle Public Cloud: A Tutorial

Read More
MySQL 8.0.1: Using SKIP LOCKED and NOWAIT to handle hot rows
Mysql 24-Apr-2017

MySQL 8.0.1: Using SKIP LOCKED and NOWAIT to handle hot rows

Read More
Mysql 19-Apr-2017

Replication Features in MySQL 8.0.1

Read More
Mysql 15-Apr-2017

MySQL InnoDB Cluster – Preparing a Linux VM for a Real-World Cluster

Read More
MySQL InnoDB Cluster – Setting up a Real-World Cluster
Mysql 12-Apr-2017

MySQL InnoDB Cluster – Setting up a Real-World Cluster

Read More
An Insider’s View of MySQL Group Replication—Now Available in Oracle MySQL Cloud Service!
Mysql 08-Apr-2017

An Insider’s View of MySQL Group Replication—Now Available in Oracle MySQL Cloud Service!

Read More
Stop using PHP MySQL extension and start using MySQLi or PDO
Mysql 04-Apr-2017

Stop using PHP MySQL extension and start using MySQLi or PDO

Read More
Optimistic Incremental Backup
Mysql 09-Mar-2017

Optimistic Incremental Backup

Read More
Improved Redo Log Copying During Backup
Mysql 09-Mar-2017

Improved Redo Log Copying During Backup

Read More
Logging is a very important diagnostic tool for understanding the behavior of the application as well as troubleshooting any issue with the application. Since MySQL Enterprise Backup (MEB) is a command line application, there is little interaction with the myriad of operations going on behind the scenes. Thus, logging messages are very important for knowing the progress of current operation as well as learning more about errors should they occur. The messages logged by MEB are written to the con
Mysql 09-Mar-2017

Improved Logging Messages

Read More
Mysql 13-Feb-2017

The Unofficial MySQL 8.0 Optimizer Guide

Read More
Mysql 08-Feb-2017

PHP and MySQL Basics IV -- SQL Injection and Prepared Statements

Read More
MySQL Group Replication and table design
Mysql 25-Jan-2017

MySQL Group Replication and table design

Read More
The Ultimate Guide To MySQL Roles By Examples
Mysql 18-Jan-2017

The Ultimate Guide To MySQL Roles By Examples

Read More
PHPWithMySQL
Mysql 12-Jan-2017

PHPWithMySQL

Read More
JSON and MySQL Stored Procedures
Mysql 11-Jan-2017

JSON and MySQL Stored Procedures

Read More
MySQL Group Replication Limitations: savepoints
Mysql 09-Jan-2017

MySQL Group Replication Limitations: savepoints

Read More
Best NoSQL Database 2017
Nosql 06-Jan-2017

Best NoSQL Database 2017

Read More
THE HANGING QUERY
Mysql 05-Jan-2017

THE HANGING QUERY

Read More
MSSQL TO MYSQL DATA MIGRATION USING MYSQL WORKBENCH 6.3
Mysql 29-Dec-2016

MSSQL TO MYSQL DATA MIGRATION USING MYSQL WORKBENCH 6.3

Read More
MySQL Storage Engine – How to Convert MyISAM to InnoDB
Mysql 19-Dec-2016

MySQL Storage Engine – How to Convert MyISAM to InnoDB

Read More
MySQL 8.0 Data Dictionary: Status in the 8.0.0 DMR
Mysql 18-Nov-2016

MySQL 8.0 Data Dictionary: Status in the 8.0.0 DMR

Read More
How to use PDO database connection in PHP
Mysql 10-Nov-2016

How to use PDO database connection in PHP

Read More
Stop using PHP MySQL extension and start using MySQLi or PDO
Mysql 10-Nov-2016

Stop using PHP MySQL extension and start using MySQLi or PDO

Read More
Mysql 09-Nov-2016

difference between VARCHAR and CHAR?

Read More
Different Types of SQL Keys
Sql Server 09-Nov-2016

Different Types of SQL Keys

Read More
MySQL Server bootstrapping and dictionary initialization
Mysql 09-Nov-2016

MySQL Server bootstrapping and dictionary initialization

Read More
MYSQL Cheat Sheet Free Download
Mysql 07-Nov-2016

MYSQL Cheat Sheet Free Download

Read More
MySQL 8.0 Data Dictionary: Background and Motivation
Mysql 20-Oct-2016

MySQL 8.0 Data Dictionary: Background and Motivation

Read More
Best NoSQL Database 2016
Nosql 19-Oct-2016

Best NoSQL Database 2016

Read More
MySQL 8.0: Improvements to Information_schema
Mysql 17-Oct-2016

MySQL 8.0: Improvements to Information_schema

Read More
Sql Join
Sql Server 23-Sep-2016

Sql Join

Read More
Sql Server 23-Sep-2016

Lead and Lag Functions in SQL Server 2012

Read More
Sql Server 22-Sep-2016

Yes You Can ROLLBACK TRUNCATE

Read More
Sql Server 22-Sep-2016

MERGE Statement to Perform an UPSERT in sql

Read More
Open Source Database Now Available in Oracle Cloud
Mysql 20-Sep-2016

Open Source Database Now Available in Oracle Cloud

Read More
How to Monitor MySQL Replication?
Mysql 15-Sep-2016

How to Monitor MySQL Replication?

Read More
Tips & Tricks 07-Sep-2016

JData: Connect to MySQL using MySQLi and run SQL queries

Read More
Facebook Page
Coding-Help-Tech
Save & Follower
Newsletter Signup

Sign up to receive latest updates with Codinghelptech!

Recent Posts
Popular Tag
Tips & Tricks Mysql Nosql Sql Server Javascript Jquery Node Js Angular JS Codeigniter Wordpress Magento Html Css3 Bootstrap Php Html5 Tech-News React JS Laravel Python