Chapter 2 A of Mysql Enterprise Employee study surprise: Li Bingbing gives Ren Quan A surprise

Chapter 2 A of Mysql Enterprise Employee study surprise: Li Bingbing gives Ren Quan A surprise

Chapter 2 small A's surprise ----Recognize Databases

After dinner, John and John went home and started learning Mysql on the computer.

John: "A, how do you store Excell files in many cases to quickly find the files you want? ".

A: "Is this related to Mysql? ".

John: "Of course, you will know later. Let's talk about your practice first. ".

Small A: "In general, I will create A folder under my drive D, for example, name: Company A plan data, and then under this folder, create multiple folders in the name of the current day, and finally store the corresponding Excell file in it, just like this"

John: "Your method is good, so you can quickly locate the file you are looking for. It seems that you are not stupid. ".

A: "Now you can tell me what is the relationship between this and the database? ".

John: "Of course, as I said just now, a database can be understood as a data warehouse. So first, we have to build a local warehouse? This land is equivalent to your D disk. In databases, we call it a workspace. With the ground, we need to build a warehouse of the right size. This warehouse is equivalent to your folder 'Company A plan', which we call a database, in the warehouse, there are several partitions. These areas are used to store different types of goods. They are equivalent to the subfolders named after the current time. We call them tablespace, while in the area, naturally, you have to store things. It's like the Excell file you have stored. We call it a data table. This table is used to store data. ".

Xiao A: "I understand. I used to classify methods for convenience of searching. It seems that I admire myself more and more, Xiao Y, what is the relationship between Excell and Mysql? ".

John: "Haha, you have to open your eyes. I will show you a Mysql table, that is, let you see an Excell. You can compare it. "

John: "on the left is the Mysql table data, and on the right is the Excell that you often use. Now you can talk about your feelings. ".

A: "My days, how are they so similar! It surprised me! I have no words to swallow... let me feel overwhelmed by melon seeds ......".

John: "Haha, that's why we recommend you study the database. There are many similarities between the two. Let me analyze them for you. First, each Excell has its own name. The same is true for our data tables. We call it a table name, but note that you usually name Excell in Chinese, however, after all, databases are foreign products and cannot be very good at Chinese compatibility, but they are not very good. In addition, the rules of major companies and industries coincide with each other, we generally use English or pinyin for naming. Of course, you can also use Chinese, which will not affect it. ".

A: "Well, I know. Since everyone is doing this, I can use English. I really don't understand it. I can use Pinyin directly. ".

John: "Haha, this is just a specification. I will show you a simple table for storing pet information. PetName (pet name) is at your Excell, do you usually name his column name? Similarly, we also name the column name in the database. Now both the table and the column name are available, and the rest is the corresponding data and data type. ".

A: "It's A pleasant surprise. I can't think of A database that is similar to Excell. It will be much better if I learn it! John, I have to go out and buy a fried chicken ...".

Y :"......"

Chapter 1 of Mysql Enterprise Employee Learning