Mysql fundamental knowledge

  • Mysql 5.1, 5.5 are more stable than other versions.

 

  • postgresql has more strict "sql standard " than mysql.

 

  • A server contains multiple databases, a database contains multiple tables, a table contains multiple records.

 

  • Transaction(事务):  a series of database's options which have strong connection.

 

  • Relationship of cmd and mysql:   cmd(client) <-->  mysql(server)

 

  • connect mysql in dos:

　　　　1. move to the folder where there is your mysql's installation is located.

　　　　2.> mysql -u[username] -p[password]

 

  • mysql's default port is 3306
posted @ 2019-12-27 23:39  code_explorer  阅读(88)  评论(0)  编辑  收藏  举报