MySQL – Select date from a range without table
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.
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.
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 [...]
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 [...]
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.