mysql: Posts tagged "mysql" - Gabriel Harper's Blog

» Gabriel Harper's Blog » Browsing posts tagged "mysql"

mysql

Browsing 7 posts tagged "mysql"

How to Limit MySQL Usage for Individual User Accounts

Posted 2012-07-21 in Databases

Recently I had a website that was getting hammered with traffic. Every hit on the website requires multiple MySQL SELECT statements. While SELECTs are typically quite fast, the database in question has several million records. Upgrading hardware...

Adding Text to a Field in MySQL Without PHP

Posted 2012-07-17 in Databases

Every once in a while you want to add some text to a text field in a MySQL database, but it's not always convenient to invoke PHP for such a task. Wouldn't it be nice to use an SQL statement to take care of it for you? Fortunately, there is just...

SQL to Get Post Tags in Wordpress

Posted 2012-07-13 in Web Development

If you've ever tried to fetch all the tags for a Wordpress post in a single SQL statement, you've realized that tags aren't simply stored in an extra field in the posts table. Wordpress post tags are part of the taxonomy system and have a...

The Only Five Web Development Tools You Need

Posted 2009-05-07 in Web Development

I use a lot of different software in my job, but there are five software tools in particular that I can do nearly all of my Web development with. The best part is they are allcompletely free applications. You can download and install everything you...

vBulletin Similar Threads in PHP

Posted 2009-04-18 in Software & Scripts

This is a completely portable PHP script that fetches similar threads from a vBulletin forum. It does not require global.php or any other vBulletin scripts to run. The script uses full score matching, and supports search engine friendly URLs made by...

Complete inserts or Extended inserts in phpMyAdmin

Posted 2009-04-12 in Databases

I was recently using phpMyAdmin to export some records from an URL shortener I'm working on. As usual I verified that "Complete inserts" and "Extended inserts" were enabled for the SQL dump. Why? Using both of these options reduces your SQL filesize...

Introduction to Data Modeling

Posted 2004-04-07 in Databases

Data modeling is the practice of representing data structures and their relationships through conceptual modeling. The benefits of implementing this process during the design phase of your database project include improved data integrity, a more...

Gabriel Harper's Blog

“Business, Websites and Life”

mysql

How to Limit MySQL Usage for Individual User Accounts

Posted 2012-07-21 in Databases

Adding Text to a Field in MySQL Without PHP

Posted 2012-07-17 in Databases

SQL to Get Post Tags in Wordpress

Posted 2012-07-13 in Web Development

The Only Five Web Development Tools You Need

Posted 2009-05-07 in Web Development

vBulletin Similar Threads in PHP

Posted 2009-04-18 in Software & Scripts

Complete inserts or Extended inserts in phpMyAdmin

Posted 2009-04-12 in Databases

Introduction to Data Modeling

Posted 2004-04-07 in Databases

Categories

Search

Subscribe

Popular

Tag Cloud

Navigate

My Services

Blog