Global Link Technologies

mysql how to add an Id column using auto increment

admin — Tue, 09 Feb 2010 00:08:28 +0000

alter table tablename add column id int auto_increment primary key;

uppercase first character of every word in string

admin — Mon, 08 Feb 2010 21:57:06 +0000

php string function

ucwords();

How to uppercase first letter in each word

admin — Mon, 08 Feb 2010 21:40:10 +0000

php function ucfirst();

how to copy files in php - the copy() function

admin — Mon, 25 Jan 2010 20:16:52 +0000

copy(”originalfile.php”, “newfile.php”);

How to lower case a column in mysql

admin — Sun, 24 Jan 2010 22:15:41 +0000

update cityfn set city = LOWER(city);

How to remove characters or string from a mysql table

admin — Sun, 24 Jan 2010 17:39:41 +0000

update tablename set column_name = replace(column_name, ‘find string to replace’, ‘replace with this string’);

Forr example, if you have asterisks in your data you want to delete:

update cities set city = replace(city, ‘*’, ”);

How to copy records back into original table

admin — Thu, 21 Jan 2010 22:19:02 +0000

insert into oldtable select * from newtable;

how to delete duplicate rows in mysql

admin — Thu, 21 Jan 2010 22:09:54 +0000

create table newtable as
select * from oldtable where 1 group by [specific column];

How to delete rows containing specific text string in a Mysql database

admin — Thu, 21 Jan 2010 21:54:32 +0000

“delete from tablename where columnname like ‘%text to match%’;

Make sure you know the text is contained in only the rows you want to delete otherwise MySQL may delete other database rows you didn’t want deleted

Web Design Portland Oregon

admin — Thu, 01 Oct 2009 15:39:00 +0000

Global Link is a Portland web design company providing custom website design and search engine optimization.

We offer high quality web page development with cutting edge and creative graphic design, search engine optimization that will empower your site for high search engine rankings, e-commerce website development, content management systems and more.

If your website needs targeted Portland Search Engine Optimization, we can help. Our SEO services specialize in targeted geographic SEO for specific cities and markets like Portland. And because we live and work here, understand the SEO landscape here.

We provide many other services as well. Contact us today for more information about our services.