Shulou(Shulou.com)06/01 Report--

Backup database

Mysqldump-uroot-p abc > abc.sql

Import database

Mysql-uroot-p abc

Use mydb

Mysql > alter database mydb character set utf-8

Access to the database

Use databasename

View table contents

Select * from tablename

View table structure

Desc tablename

View time

Select now ()

The solution to garbled code when the content of the table is in Chinese

Charset utf8

View the encoding format of the test database:

Show create database test

View the encoding format of the yjdb data table:

Show create table yjdb

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.