More Questions Than Answers

Dan Atrill's blog site

MySQL Commands in brief

I was hunting for a few easy to follow commands for command line MySQL having been using Webmin and phpmyadmin for a while now. This site http://www.pantz.org/software/mysql/mysqlcommands.html came up trumps. Lots of other useful sysadmin stuff on there. Thanks pantz, you saved me hours.

Tags: commands, MySQL, sys admin

more... »

Wed, December 16 2009 » MySQL » No Comments

Search and replace

In very few lines it’s possible to search and replace text in MySQL:
UPDATE table_name SET column_name = replace(column_name,”find_this”,”replace_with_this”)
Thanks to Torkil Johnsen’s Search and replace in MySQL article

Tags: MySQL, search and replace, UPDATE

more... »

Wed, August 8 2007 » MySQL » No Comments

Calendar:
- March 2010
  
  M T W T F S S
  
  « Feb
  
  1 2 3 4 5 6 7
  
  8 9 10 11 12 13 14
  
  15 16 17 18 19 20 21
  
  22 23 24 25 26 27 28
  
  29 30 31

March 2010
M	T	W	T	F	S	S
« Feb
1	2	3	4	5	6	7
8	9	10	11	12	13	14
15	16	17	18	19	20	21
22	23	24	25	26	27	28
29	30	31

About

This is Dan Atrill's blog site covering new freelance web development work, Linux, Mac info, technology and anything to do with music and other distractions.

Most of the information should still be relevant but if anything is wrong, please let me know.

For more info on Dan Atrill visit the new portfolio site: http://dan.atrill.co.uk
Current Sites
Tags
@media ajax apple BBC beer browser christmas cms commands construction crewd crewd recordings forms freelance frosty hughes design IE6 internet jim beam london maylim Mobile phone MySQL Opera web browser PHP scriptaculous search and replace security Sony Ericsson south bank spring park motel stephen fry steve jobs sys admin trinity trinity pr UPDATE upgrade US web developer web development website wordpress
Recent Posts
Archives
- March 2010 (1)
- February 2010 (2)
- January 2010 (2)
- December 2009 (3)
- November 2009 (2)
- October 2009 (1)
- June 2009 (2)
- August 2008 (1)
- May 2008 (3)
- January 2008 (2)
- November 2007 (5)
- October 2007 (4)
- September 2007 (2)
- August 2007 (3)
- July 2007 (2)
- March 2007 (2)
- January 2007 (4)
- November 2006 (1)
- October 2006 (2)
- July 2006 (3)
- June 2006 (4)
- May 2006 (4)
- April 2006 (4)
- March 2006 (8)
- February 2006 (4)
- January 2006 (3)
- November 2005 (2)
- October 2005 (1)
- September 2005 (2)
- August 2005 (2)
- July 2005 (2)
- June 2005 (1)
- May 2005 (1)
- April 2005 (1)
- February 2005 (3)
- January 2005 (1)
- December 2004 (1)
- November 2004 (1)
- September 2004 (2)
- August 2004 (2)
- July 2004 (2)
- June 2004 (4)
- May 2004 (4)
Badges

Subscribe to More Questions Than Answers by Email

More Questions Than Answers

MySQL Commands in brief

Search and replace

Search this site

Calendar:

About

Current Sites

Tags

Recent Posts

Archives

Badges