#1227 – Access denied; you need (at least one of) the SUPER privilege(s) for this operation

Welcome to the first post of 2016 🙂 This is a micropost about that annoying error #1227 – Access denied; you need (at least one of) the SUPER privilege(s) for this operation. I encountered this error while I was trying to import a .sql

Read More #1227 – Access denied; you need (at least one of) the SUPER privilege(s) for this operation

MySQL – Temporary Tables in Stored Procedures

MySQL Temporary Tables have the same functionality as standard disk-based tables except they exist in memory. Since memory is not long term storage, they are temporary tables, hence the name. Temporary Tables, or temp tables for short, allow you to

Read More MySQL – Temporary Tables in Stored Procedures

MySQL Cursors and Loops in Stored Procedures

Loops in stored procedures are quite useful and sometimes inevitable for achieving certain tasks in MySQL database. Instead of retrieving all records from the database and looping through all the data for subsequent manipulations using like PHP, which can be

Read More MySQL Cursors and Loops in Stored Procedures

MySQL – Joining Tables without Join Keyword

Here is another micro post… I used to use JOIN keyword whenever a table join was necessary in MySQL, but recently I have been using this other method of joining tables in MySQL (it should be applicable in MSSQL too). In

Read More MySQL – Joining Tables without Join Keyword

Encoding, Collation and Character Sets

Many people don’t seem to know the difference between these terms, what they mean and do. So here is a brief explanation of encoding, collation and character sets. Encoding: Encoding is the algorithm that translates numbers into binary so they

Read More Encoding, Collation and Character Sets

MySQL- Commands out of sync you can’t run this command now

Today, I coded a piece of PHP where there were 2 consecutive calls to 2 MYSQL stored procedures (select statements). The first “call” queried the database and populated a page area with the result, and the second call came right

Read More MySQL- Commands out of sync you can’t run this command now

Exporting and Importing MySQL Databases Using phpMyAdmin

It has been a long time since my last post but I have been pretty busy, sorry for that 🙂 Recently, I felt the need to export my MySQL database from one development machine and import it into another along with

Read More Exporting and Importing MySQL Databases Using phpMyAdmin

Php Script to Apply Regex Replace on MySQL Records

Use this script at your own risk. Never run scripts on your databases before backing them up! Recently I needed to apply REGEX replacement on my posts in this blog. I wanted to remove dead links from my posts to improve

Read More Php Script to Apply Regex Replace on MySQL Records

Insert Data into MySQL Database – Php Basics for Beginners

This will be a brief 101 post for inserting data into MySQL database using Php. I find it very easy and straight forward to insert data into MySQL database using Php, compared to inserting data into MS SQL using C#.

Read More Insert Data into MySQL Database – Php Basics for Beginners