Global Link Technologies

mysql how to add an Id column using auto increment

alter table tablename add column id int auto_increment primary key;

uppercase first character of every word in string

php string function

ucwords();

How to uppercase first letter in each word

php function  ucfirst();

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

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

How to lower case a column in mysql

update cityfn set city = LOWER(city);

How to remove characters or string from a mysql table

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

insert into oldtable select * from newtable;

how to delete duplicate rows in mysql

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

“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

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.