Welcome to phpMyBackupPro Here on the offcial homepage you will find all informations about phpMyBackupPro (pMBP). phpMyBackup Pro is a very easy to use, free, web-based MySQL backup application, licensed under the GNU GPL. You can create scheduled backups, manage and restore them, download or email them and a lot more!
Tag Archives: MySQL
Mysql utf-8 characters
mysql_query(“SET CHARACTER SET utf8”); mysql_query(“SET NAMES ‘utf8′”); mysql_query(“SET COLLATION_CONNECTION=utf8_general_ci”); mysql_query(“SET CHARACTER_SET_CLIENT=utf8”); mysql_query(“SET CHARACTER_SET_RESULTS=utf8”); [ad code=1]
Storing Hierarchical Data in a Database
Whether you want to build your own forum, publish the messages from a mailing list on your Website, or write your own cms: there will be a moment that you’ll want to store hierarchical data in a database. And, unless you’re using a XML-like database, tables aren’t hierarchical; they’re just a flat list. You’ll have …
Mysql Concat + Join fields
SELECT CONCAT(last_name,’, ‘,first_name) full_name FROM mytable ORDER BY full_name; [ad code=1]
Mysql connect 3 Tables
SELECT *, (SELECT * FROM tb2 WHERE tb2.tb2_id=tb1.id LIMIT 1) as newname FROM ((tb1 Left Join tb3 ON tb3 = tb3)) WHERE tb1.ok=1 ORDER BY tb1.date DESC
Mysql ORDER by Random
“SELECT * FROM talbe ORDER BY RAND()”;