Tag: mysql

ODBC Driver for MySQL: How to Install and Set up Connection (Step-by-step)

Tools & technologies

This article focuses on the step-by-step processes of installing and configuring the ODBC driver...
Read More

MySQL Create View, Replace View and Drop View Statements with Examples

Database development, MySQL, Statements, Views

An SQL view is a virtual table or a result-set generated by the SELECT query. Unlike physical tables, views do not store data in a...
Read More

CREATE TABLE MySQL vs T-SQL with Syntax Examples

Database development, MySQL, Statements, T-SQL, Tables

Are you a T-SQL developer learning the basics of MySQL? Then, one of the things you might want to learn is MySQL CREATE TABLE statement....
Read More

Understanding MySQL TRUNCATE TABLE by Practical Examples

Database development, MySQL, Statements, Tables

MySQL TRUNCATE TABLE statement is a DDL statement used for removing all records from the MySQL...
Read More

How to Parse Strings Like a Pro Using SQL SUBSTRING() Function?

Database development, Statements

Do you enjoy parsing strings? If so, one of the indispensable string functions to use is SQL SUBSTRING. It is one of those skills a...
Read More

10 Best MySQL GUI Tools

Tools & technologies, Utilities & Extensions

MySQL is among most widely-used and popular database technologies, so quite a lot of tools have been created in order to make the processes...
Read More

Conditional Split Transformation: Export Data from SQL Server into Oracle and MySQL Databases

Business intelligence, Database administation, SSIS, Work with data

In this article, I have explained how we can divide and export data of SQL Server database table...
Read More

Pivot Tables in MySQL

Database development, Tables • One Comment

Briefly about Pivot tables This article deals with the transformation of table data from rows to columns. Such transformation is called...
Read More