Category Archives: database

Remove line breaks using Microsoft Word

Find ^p, replace with Find ^p, replace with http://www.iom3.org/web-editors-community/news/2011/jun/21/how-instantly-remove-unwanted-line-breaks-when-copying-pdf

Posted in database, Excel | Comments Off on Remove line breaks using Microsoft Word

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 , , , , | 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

Posted in database | Tagged | Comments Off on Database: MySQL Split value from one field to two

Prestashop: Additional field in product attributes

Added an additional field for product attributes Files updated and added to override folder override/classes Attribute.php line 36    public $barcode; line 50            ‘barcode’ =>             array(‘type’ => self::TYPE_STRING, ‘validate’ => ‘isAnything’, ‘size’ => 3), … Continue reading

Posted in database, ecommerce | Tagged | Comments Off on Prestashop: Additional field in product attributes

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 , | 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

Posted in database | Tagged , | Comments Off on CSV to SQL Converter

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 , | Comments Off on mysql: Change character encoding for database and tables