Public domain
CHECK TABLE radacct EXTENDED;
REPAIR TABLE radacct;
ALTER TABLE table_name ADD new_column INT NOT NULL;
ALTER TABLE table_name ADD new_column VARCHAR(50) AFTER existing_column;
ALTER TABLE table_name ADD new_column VARCHAR(50) FIRST;
ALTER TABLE table_name CHANGE old_name new_name VARCHAR(50);
ALTER TABLE table_name ADD UNIQUE (existing_column);
ALTER TABLE table_name DROP COLUMN column_name;
mysqldump -uroot -p database -d > databse-schema.sql
mysqldump -uroot -p database > databse-backup.sql
mysqldump -u root -p --all-databases --routines --max_allowed_packet=512M > mysql_full_backup.sql
mysql> SELECT INET_ATON('192.168.10.50');
+----------------------------+
| INET_ATON('192.168.10.50') |
+----------------------------+
| 3232238130 |
+----------------------------+
1 row in set (0.00 sec)
mysql> SELECT INET_NTOA('3232238130');
+-------------------------+
| INET_NTOA('3232238130') |
+-------------------------+
| 192.168.10.50 |
+-------------------------+
1 row in set (0.00 sec)
UPDATE wp_posts SET post_content = REPLACE (post_content, 'http://oldlink.com', 'http://newlink.com');
SELECT datediff( pr_endtime, pr_starttime ) AS date_diff FROM problem_reports;
SELECT TIME_TO_SEC(TIMEDIFF(pr_endtime,pr_starttime))/86400 FROM problem_reports;
SELECT TIME_TO_SEC( TIMEDIFF( pr_endtime, pr_starttime))/3600 FROM problem_reports;
BY: Pejman Moghadam, Farid Ahmadian
TAG: mysql, wordpress
DATE: 2011-06-08 10:36:58
With many thanks and best wishes for dear Pejman Moghadam, someone who taught me alot in linux and life :)