SQL (Structured Query Language)

ยปTag: SQL (Structured Query Language)

Display Full SQL Query in Show Processlist of MySQL

In MySQL database system, by default the SHOW PROCESSLIST query displays only first 100 characters of the running SQL query or SQL statement in the Info column. The limited and trimmed length of SQL statement may prevent [...]

By |2016-12-09T08:38:43+08:00December 9th, 2016|Categories: Databases|Tags: , , |0 Comments

Remove or Trim First or Last Few Characters in MySQL Database with SQL

Another useful string function in MySQL database is TRIM() which will return a text string after removing the matching leading or trailing characters, also known as prefixes or suffixes. It's been described by MySQL reference as function [...]

By |2016-12-09T08:40:08+08:00December 9th, 2016|Categories: Databases|Tags: , , |6 Comments

How to Find and Replace Text in MySQL Database using SQL

MySQL database has a handy and simple string function REPLACE() that allows table data with the matching string (from_string) to be replaced by new string (to_string). This is useful if there is need to search and replace [...]

By |2016-12-09T08:40:08+08:00December 9th, 2016|Categories: Databases|Tags: , , |77 Comments

WordPress MySQL SQL Query Error in WPDB Class

WordPress plug-ins users or external scripts developers may encounter problems on when trying to perform query or manipulation on MySQL database by using $wpdb class, a class of functions for all database manipulations based on the ezSQL. [...]

By |2016-12-09T08:41:04+08:00December 9th, 2016|Categories: Databases|Tags: , , |1 Comment

Create New Table by Selecting Data from Other Tables with CREATE TABLE AS

By using SQL data manipulation statement, a new, temporary, backup or regular table can be created and filled or inserted with data from another table or tables retrieved by SELECT statement. The SQL data manipulation language is [...]

By |2016-12-09T08:41:38+08:00December 9th, 2016|Categories: Databases|Tags: , , , , |8 Comments