Shulou(Shulou.com)06/01 Report--

This article mainly explains "how to create a library with MySQL". The content in the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "how to create a library with MySQL".

A library is like a bookcase, which is used to store books and the library to store data.

It takes a lot of time and effort to build a bookcase, pay attention to wood materials, size, moving door links, but also paint, do one or two small drawers. In fact, it is the same to build a library, pay attention to all kinds of elements, in order not to frighten the beginner, the library here can be the same as a simple bookcase, just take four boards to seal one:

Create database BookCase

In this way, a library called BookCase was built.

There are all kinds of books, databases, operating systems, politics, economics, and novels on the bookcase. I will put all the relevant categories on one floor, so this layer can be regarded as a table. The book on each layer becomes the data in the table.

To sum up, so far, we have come into contact with the database, the table and the data in the table (commonly known as rows), corresponding to the bookcase, the first floor of the bookcase, and the book. A friend said that there is no room for books of the same category on the first floor, what should I do? Then change to another floor, as we often say, sub-meter!

Let's first build the first floor of the bookcase and build a new watch:

Create table book (bookId int, bookName nvarchar (50), bookPrice Numeric (9), bookAuthor nvarchar (20))

We are concerned about the general situation of a book: the title, the price, and the author of the book, so this information should be recorded and saved in bookName,bookPrice,bookAuthor.

Then the first book can be stuffed into the watch: a book called High performance MySQL, which costs 99 yuan, written by Taobao Ning Haiyuan.

Insert into book (bookId,bookName,bookPrice,bookAuthor) values (1) 'High performance MySQL',99,' Ning Haiyuan')

You can see at a glance that the book is put in the bookcase, but it is not so simple when you enter the table in the database. We need to use the command SELECT to see if the book is really stuffed in:

SELECT * FROM book

Really, the book is already in it!

Thank you for reading, the above is the content of "how to create a library with MySQL". After the study of this article, I believe you have a deeper understanding of how to create a library with MySQL, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.