MySQL – Select date from a range without table

October 19, 2016 17:52
Tags: ,

Sometimes you want to get the date range from MySQL without table. Here you are: It is useful when you want to generate some reports.

Comments Off

Delete all orders, reset bestseller and most viewed products in Magento

October 28, 2010 09:48

In your Magento development period, you may create many order to test the checkout process. Before the website launch, you should find that there is no “delete” action for orders. What? Is it crazy? Unfortunately, it’s really crazy (maybe) that you cannot delete order in Magento by default. Like me, there are over hundred orders [...]

Comments Off

MySQL Licensing Questions

September 27, 2004 17:35
Tags: ,

Although this article is published in International PHP Magazine website three weeks ago, but is still valuable for the people who is looking for the MySQL licensing. The author points out seven common questions for MySQL licensing clear and deep. If you don’t know how to choose a license, it is a place for you [...]

Comments Off

phpMyAdmin for multiuser

September 12, 2004 14:02
Tags: , ,

There is one article in PHPmac that is about the installation of phpMyAdmin for multiuser environment. This is useful for the web hosting company, or a company that contains multi database administrators with differnt permission. Of course one database for one user only is a great idea for the security reason.

Comments Off