line

Add to any feed reader

End Query with \G instead of ;

You can use \G instead of ; for tables with lots of fields.

mysql> SHOW STATUS LIKE ‘Qcache%’;
+————————-+———–+
| Variable_name | Value |
+————————-+———–+
| Qcache_queries_in_cache | 6990 |
| Qcache_inserts | 6990 |
| Qcache_hits | 3987 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 621 |
| Qcache_free_memory | 176329432 |
| Qcache_free_blocks | 1 (more…)

Hide and Restore Rows and Columns

This script displays a table and allows the user to remove and restore both rows and columns. This allows the user to remove the details and products that he is not interested in. (more…)

Networking to Build Back Links to Your Web Site

If you ve been doing SEO for a while you know about the concept of linkbait. This is content that is so cool or useful or entertaining that people can t resist linking to it thus improving your page rank and your position in the search engine results pages. But how do you get the word out about your linkbait …

Rackspace: Save on Web Hosting in March! Start working with The Hosting Experts today and Save - Get Free Setup in March! (more…)

SEO: A Career with a Future

It s not unusual for those working in respected fields to be asked questions by those just entering or re-entering the job market. Naturally the newcomers want to know about the future prospects of those fields. Search engine optimizers face those questions regularly. So what will the field look like five or ten years from now Is it a good career choice …

Search Site Optimized for Developers and IT Pros Fast and relevant. Find technical documents, podcasts, whitepapers, research and blog posts. (more…)

Re: Increase MySQL field value by 1

How about using UPDATE command?

UPDATE yourtable SET column=column+1 WHERE uniqueid=yourvalue

/Georg (more…)

« Previous PageNext Page »