Category Archive For "MySQL"

This is very basic and very useful command for mysql. I need user registration date by date. Firstly, i calculate with PHP, after i think it must be a basic way. I found this mysql command. I hope you’ll enjoy.

I have a big mail database but there are some dublicate email addresses. I need unique email address lists and i follow this way; Firstly i create temporary table for unique email address After i add unique email address to that temp table I dropped my real email table After all, i create new mail …

SELECT count(id) AS toplam,YEAR(tarih_dogum) AS YIL FROM uyeler GROUP BY YEAR(tarih_dogum) Advertising agencies wants to user profile for advertisements. I need my users age. I found a little solution. I write this SQL statement for select which year my users born and group them. After i copied this results to Excel. I calculate age groups …

I blogged Php 5.2.9 Upgrade. Some of my user updated with using this entry. But i miss something in these entry. Firstly, i have to say. If you upgrade php version, you have to upgrade mysql and php-mysql. To Upgrade Mysql and Php-Mysql tool And there one more thing, he was php4 and upgrade to …

We need get datas from last week, last month, yesterday and today. We can do it easily in MySQL. Getting Current Date Result : 2009-06-04 Getting Last Week Datas Getting Last Month Datas Getting Last Year Datas And Php example for this calculations, getting last month orders For more information of Date and time functions …

Web servers uses Plain-Text form based authentication. If an attacker with access to the network traffic to and from the target host may be able to obtain login credentials for other users by sniffing the network traffic. Solutions is data sent via HTML login forms is encrypted before being sent from the client to the …

Sometimes, i need to convert datas for search engine optimization (SEO). I use MySQL replace command for this. Just login to phpmyadmin or any tool for run SQL command. Paste command set, change table and field name than run.

Firstly; you need access to your MySQL Server and maybe access to your wp-config.php file in the root of your site. Go www.md5-creator.com and type in a password you want to use.Example type “123” then copy. “123 in MD5 :” ‘s result is “202cb962ac59075b964b07152d234b70” Than open your MySQL database, and click the wp_users table Change …