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
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
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
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
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
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
PHP/MySQL is one of the most common stacks for web development. To be able to get data from a MySQL database or put data into a MySQL database you must first create a connection from inside your PHP script to
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
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
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#.