Common MySQL queries...

Posted Mon, 02/02/2004 - 9:42am

# mysql -hdb3.pair.com -uusername -pXXXXXXXX username_dbname

# mysqldump -hdb3.pair.com -uusername -pXXXXXXXX username_dbname > file.txt

# mysql -hdb3.pair.com -uusername -pXXXXXXXX username_dbname < file.txt

shell> mysql -h host -u user -p
Enter password: ********

search and replace (update data):

UPDATE `table` SET `table_field` = 'tothisvalue' WHERE `table_field` = 'thisoldvalue'

UPDATE `table` SET `table_field` = 'NEWVALUE' WHERE `table_field` LIKE '%OLDVALUE%' OR `table_field`

• PHP / MySQL