‘Mysql’ Archives
How to fetch multi-lingual content from database
The basic purpose of this post is to guide you all about fetching multilingual content from database. I mean to say that, if you have stored japanese text in your database, So in order to fetch the japanese content , you need to set the character encoding to UTF-8 format, while communication with the database for fetching the result. In Case [...]
How to import data into mysql db from sql file
Open your shell prompt navigate to the mysql directory (default is /var/lib/mysql) cd /pathToYourMysqlDirectory/ then type the below command $ mysql -u mysqlUserName -p Password -h HostName DatabaseName < /loactionOfYourSqlFile/yourSqlFileName.sql Where mysqlUserName = Mysql User Name Password = Mysql User Password HostName [...]
PHP Manual
