Import Command in mysql database mysql -u root -p DATABASE_NAME < user.sql Export Command in mysql database mysql -u
Continue readingCategory: mysql
How to Install Mysql in Ubuntu
Installing Mysql In Ubuntu follow these steps: Step 1: sudo apt-get update Step 2: sudo apt-get install mysql-server-5.6
Continue readingRENAME Table AND Column Name In Mysql Database
Rename Table Name In Mysql: RENAME TABLE old_name_of_table To new_name_of_table; Example: RENAME TABLE user12 To user; Rename Column Name IN
Continue readingHow To get Default Character set of Database And Table in mysql
If you want to know your mysql database default character set then use this query SELECT DEFAULT_CHARACTER_SET_NAME FROM information_schema.SCHEMATA S
Continue readingmysql tutorial for beginners
How to Install Mysql in Ubuntu Get Default Character set of Database and Table in mysql RENAME Table AND Column
Continue reading