-
Recent Posts
Recent Comments
Archives
- August 2020
- March 2020
- December 2019
- July 2019
- June 2019
- May 2019
- March 2019
- August 2018
- July 2018
- May 2018
- March 2018
- September 2017
- August 2017
- May 2017
- April 2017
- January 2017
- November 2016
- October 2016
- September 2016
- August 2016
- June 2016
- May 2016
- April 2016
- November 2015
- October 2015
- September 2015
- August 2015
- April 2015
- March 2015
- February 2015
- January 2015
- December 2014
- November 2014
- October 2014
- September 2014
- August 2014
- July 2014
Categories
Meta
Tag Archives: mysql
Prestashop: Searching orders by the products they contain via mysql
Source: https://www.prestashop.com/forums/topic/437518-searching-orders-by-the-products-they-contain/?tab=comments#comment-2033625 SELECT product_id, product_attribute_id, product_name, GROUP_CONCAT(id_order SEPARATOR ‘, ‘) AS orders FROM ps_order_detail group by product_name order by product_id, product_attribute_id Can add where product_id = to the number you want to narrow down the specific product SELECT product_id, product_attribute_id, … Continue reading
Posted in database
Tagged mysql, prestashop, prestashop 1.6
Comments Off on Prestashop: Searching orders by the products they contain via mysql
phpmyadmin: mysql export Simplified Chinese utf csv gibberish text issue
The database collation is utf8_unicode_ci but can’t guarantee the Chinese text encoding was 100% correct during data entry (may have mixed with Traditional Chinese?) When we use the usual route in phpmyadmin to export the data to .csv, the generated … Continue reading
Posted in database, troubleshoot
Tagged Chinese, csv, encoding, mysql, phpmyadmin
Comments Off on phpmyadmin: mysql export Simplified Chinese utf csv gibberish text issue
Database: MySQL Split value from one field to two
Source: http://stackoverflow.com/questions/2696884/split-value-from-one-field-to-two Unfortunately MySQL does not feature a split string function. However you can create a user defined function for this, such as the one described in the following article: MySQL Split String Function by Federico Cargnelutti With that function, … Continue reading
mysql: How to copy a database in phpMyAdmin
How to copy a database in phpMyAdmin This tutorial will demonstrate how to copy or duplicate a database in phpMyAdmin. Begin by accessing phpMyAdmin via cPanel . Select the database you wish to copy (by clicking on the database from … Continue reading
Posted in database
Tagged mysql, phpmyadmin
Comments Off on mysql: How to copy a database in phpMyAdmin
CSV to SQL Converter
Microsoft excel can’t seem to export csv with double quotes anymore =_=, can’t import csv directly using phpmyadmin. Found this really site that helps to make the conversion from csv to mysql statements. http://www.convertcsv.com/csv-to-sql.htm
mysql: Change character encoding for database and tables
http://stackoverflow.com/questions/6115612/how-to-convert-an-entire-mysql-database-characterset-and-collation-to-utf-8 Use the ALTER DATABASE and ALTER TABLE commands. ALTER DATABASE databasename CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE tablename CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; If not possible, Export structure and data with phpmyadmin Custom – display all … Continue reading
Posted in database
Tagged mysql, phpmyadmin
Comments Off on mysql: Change character encoding for database and tables