3 Issues in MySQL concatenate String in procedure for dynamic DML I was trying to figure out one of my long coding procedure issue in mysql that I just did and could not find exactly problem. Let’s have a look one of my sample issue as a use case during my experience. I create a procedure that contain a very long dynamic insertion string by using… Read More
MySQL Workbench – Error Code: 1175. You are using safe update mode When you execute the update/delete request in MySQL workbench and you got the message error as: You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column And in MySQL Workbench also mention how we solve this issue as well by following message: To disable safe mode, toggle the option in Preferences -> SQL Editor -> Query Editor and reconnect… Read More
Upgrade WampServer 2 to 2.2 or latest without losing data and less config WampServer is a Windows web development environment. It allows you to create web applications with Apache2, PHP and a MySQL database. I found WampServer is an easy tool for development PHP app in Windows. But since, I have to upgrade my development environment to match my production server for PHP 5.3.x and MySql 5.5.x, WampServer… Read More
Migrate from MySQL to MS SQL 2005 using MS Access 2003 as a bridge My friend asked me this topic “Migrate all tables of MySQL to MS SQL 2005 – what way”. I searched on the net as usual, got many questions and answer around one table import mostly but for many tables seem got a tip from a comment: This might not be the best solution. Nonetheless, it… Read More