Very handy function if you need to replace a string in your MySQL database tables. UPDATE table SET field = REPLACE(field, 'Old Value', 'New Value') Reference MySQL String Functions http://dev.mysql.com/doc/refman/5.1/en/string-functions.html...
When you are finished with development and staging reviews there are some database changes that need to be made in order for your WordPress blog to work properly. You can use any MySQL tool you have available, my favorite is Navicat. Options Table The options table stores all of the main settings for your blog. ...
Design Color Pallete Color Schemer Colour Lovers Color Combos CSS Forms Spruce up Your Search Box with CSS and a Background Image Fancy Form Design with CSS Layouts Fluid 3 Column – Content First in Code Three Column Layouts Perfect multi-column CSS liquid layouts – iPhone compatible The Perfect 3 Column Liquid Layout (Percentage widths) ...
Microsoft has a great Outlook PST backup tool. It’s main function is to backup your Outlook.pst file, which is your entire Outlook profile; Calendar, Emails, Contacts, Journals, everything. Download http://www.microsoft.com/downloads/details.aspx?FamilyId=8B081F3A-B7D0-4B16-B8AF-5A6322F4FD01&displaylang=en Usage http://office.microsoft.com/en-us/outlook/HA010875321033.aspx...
A common query is to return a single value from a SQL query such as an aggregate to get the total number of rows in a table. I will show you how to do just that with SQL Server Stored Procedures and C#. Preparation You will need some table data to query against. I am ...
Microsoft provides some sample databases to use to experiment with your code; because you wouldn’t dare query against your live customer data with untested code right? Samples http://www.codeplex.com/SqlServerSamples SQL Server Database Examples http://www.codeplex.com/SqlServerSamples#databases I use the Northwind tables from the SQL Server 2000 Sample DBs. How to Install the Northwind Sample Database Unzip the sample database ...
Firefox has a great plugin called Screengrab. It gives you several options if you want to copy the entire page, a small portion or what viewable. Usage Download https://addons.mozilla.org/en-US/firefox/addon/1146 Download, install and restart Firefox....
