Learning Mysql

to learn the other, although we believe that you’ll benefit from learning both languages.
In fact, almost any modern language can be used to perform this task most of them have the necessary interfaces to both web servers and database engines.
Structured Query Language
IBM is to be credited not only with inventing the relational database, but developing the language still used today to interact with such databases. SQL is a little odd, bearing the stylistic marks of its time and its developers. It’s also gotten rather bloated over the years—a process made worse by its being standardized (multiple times)—but in this book we’ll show you the essentials you really need and help you become fluent in them.
SQL shows many of the problems that are commonly attributed to computing standards it tries to accomplish too much, it forces new features into old molds to maintain backward compatibility, and it reflects uneasy compromises and trade-offs among powerful vendors. As a result, there are several standards that database management systems can adhere to. SQL dates back to 1992 and provides just about everything that you will need for beginning work. However, it lacks features demanded by some modern applications. SQL was standardized in 1999 and adds a huge number of new features, many of them considered overkill by some experts. There is also a more recent standard, SQL, that was published in 2003 and adds support for XML data.
Each development team has to decide on the trade-offs between the features requested by users and the need to keep software fast and robust, and so database engines generally don’t conform totally to anyone standard. Furthermore, historical differences have stayed around in legacy database engines. That means that even if you use fairly simple, vanilla SQL, you may have to spend time when porting your skills and your code to another database engine.
In this book, we’ll show you how to use MySQL’s flavor of SQL to create databases and store and modify data. We’ll also show you how to use this SQL variant toad- minister the MySQL server and its users.

Download 4.24 Mb.

Share with your friends: