MYSQL Basic Knowledge

1. Data type

ref:http://www.runoob.com/mysql/mysql-data-types.html

Decimal: single-/double-precision floating-point with no loss of precision

2. Backup/Restore

backup :c:\>mysqldump -u root-p mydb2 >d:\mydb2.sql carriage return (without semicolon end) password Enter

The SQL command is unique to MySQL and must be performed outside of the MySQL environment

Recovery: Mysql:\>source D:\mydb2.sql; return (semicolon-end required)

The SQL command is unique to MySQL and must be performed in a MySQL environment.

3, garbled

A) The current MySQL client modifies the input/output MySQL environment variable to GBK or GB2312, which is only valid in the current window

b) Modify the My.ini file in the MySQL directory to change the client's default encoding to GBK or GB2312 and restart the MySQL service

MYSQL Basic Knowledge