If you get this error, you do not have privileges on user_* to use Create. HostGator needs to correct this issue for you. If you open your database which you plan to import to your hostgator web hosting, you can… Read moreERROR 1044 (42000): Access denied for user ‘username1’@’localhost’ to database ‘006’
Sometimes we need to convert upper case to lower case, for example, x-cart, by default, its category and product url shows as category or product name. if a category or product name has upper case, the its related url also… Read moreSimple way to convert Upper Case to Lower Case via MySQL
I have a mysql database, about 8 GB, and i have tried several types to import it to mysql databases, such as bigdump, phpmyamdin…, all faile. Finally I found a way successfully. I am very glad to share this with… Read moreHow to import extra big data to mysql databases?
Listen, if you have 10,000 companies url at your mysql, now you need to add about-us.html just after each url, for example, one of your company url is absorking-desiccat, how to let it become to absorking-desiccant/company_profile.html?
At the end of every month we need to know how much we have earned, or how much we have sold every day, in a year for our Zen-Cart based shop cart. Usually we have to login our admin panel,… Read moreHow to Calculate Certain Period Net Sale for Zen-Cart