Submitted by
guvnor on Tue, 03/01/2011 - 19:33
Introduction
The following is a quick ready reckoner for mySQL stored procedure commands.
List the stored procedures
From a mysql command interface run the following command:
Describe the stored procedures
You need to know the name of a strored procedure you wish to see or describe
For example if my procedure is called "update_user_password" and I wish to see the commands that make up this procedure I would type:
show create procedure update_user_password;
Submitted by
guvnor on Mon, 07/26/2010 - 15:56
There are occasions where you might need to update a group of products weight. Recently I had a whole bunch of products that were in correctly set as 2KG when they should have been set to 0.2KG (200 grams). I started off manually changing them and then thought..no thanks this will take all day.
Luckily mySQL is your friend!
Using this query I was able to update all products weight within a certain category from 2KG to 0.2KG.
I knew the category I wanted to update was category 3 so I ran the following query:
UPDATE ps_product
SET weight = 0.2
WHERE weight = 2
Submitted by
guvnor on Wed, 06/23/2010 - 11:16
Introduction
Submitted by
guvnor on Thu, 04/08/2010 - 22:11
This is a tip for me as much as anyone since I have a mental block about it for some reason...
Update Column values to null
If i want to remove all the data in a mysql column. I can do it by setting the values to null like so...
UPDATE tablename Set `column_name` = Null
Submitted by
guvnor on Sat, 02/27/2010 - 00:21
Check you have a working WAMP installation
WAMP stands for Windows, Apache, mySQL, PHP. It refers to the key components used to run a lot of dynamic websites on a Windows machine. It often used for developing web applications on your local machine before putting it live on your server. You can get prebuilt installation routines that make installing a WAMP a real breeze. The one I am using for this article can be found here www.wampserver.com.
Submitted by
guvnor on Thu, 08/13/2009 - 21:45
Introduction
Using a QNAP linux NAS you can backup MYSQL databases on remote servers. This article shows you how to write a script to do this. This script can then be run at set intervals using the cron scheduler to ensure your mysql data server is backed up safely.
This guide assumes your server is running the SSHD and allows you to run remote commands. For example a
VPS server is the perfect example of this.
Step 1
