Moment For Technology

MySQL Learning Notes (1) - Overview

Posted on Aug. 9, 2023, 5:19 a.m. by Eshani Sule
Category: The back-end Tag: The back-end

1. The background

Use this article to record my process of learning mysql.

2. Knowledge

MySQL is a small relational database management system. It has the characteristics of small size, fast speed and low cost.

Mysql is an open source database, divided into community edition and enterprise edition. The community edition is free, but the official technical support is not provided.

Advantage:

  • Speed is fast
  • The price for free
  • Easy to use
  • Portability, support Windows, Linux, etc.
  • Rich interface and support for multiple development languages.
  • Supports standard SQL syntax
  • security

Json support is available as of Ver 5.7.

Mysql provides a common related tool mysqld: is the mysql daemon server. Clients can't access it until it's up and running. Mysql: An interactive command line tool to query statements. Mysqlbinlog: utility for reading statements from binary logs.

3. The installation

Create MySQL container and set remote connection in MysqlDocker

4. The extension

MySQL: Set the time zone

5. Reference:

Search
About
mo4tech.com (Moment For Technology) is a global community with thousands techies from across the global hang out!Passionate technologists, be it gadget freaks, tech enthusiasts, coders, technopreneurs, or CIOs, you would find them all here.