MySQL first-time experience _ MySQL

Before MySQL's initial experience, SQL Server databases were used for testing, while Oracle was used for projects by the company.

I have heard that MySQL is very small. it's incredible that 40 MB is missing when I Download it. The win32 installation version of MySQL 5.1.55 is selected. because it does not have a built-in client, you also need to go to the management software of the next client. the MySQL-Front version is 5.1.

Next, we will perform simple database operations, including creating a database, creating a table, and adding updates. You must first enable the MySQL server and operate on the client software. The procedure is as follows:

1. enter the ../mysql-5.1.35/bin directory, double-click to run mysqld.exe, enable Server.

2. double-click MySQL-Front to enable the client software ,:

Because I use a local computer as the server, set the IP address to 127.0.0.1, select utf8 for the character set, and then confirm. Double-click the Server set for connection. the default user name is root and the password is blank. The following page is displayed:

3. there are many database operation icons in the menu bar to facilitate database creation, table creation, and table processing.

It's just a simple introduction to MySQL. I hope you will not laugh at it.