Getting Started with Data Manipulation Language in MySQL

Data Manipulation Language

So far we’ve been hitting what is arguably the more mundane aspects of dealing with Database Administration. This would be the DDL or data definition language portion of working with MySQL. It is by using DDL that we are able to build and modify your databases and tables. Of course this is needed stuff, we need a database and some tables before we can start inserting, reading, updating, and deleting some information.…

Creating Databases and Tables in MySQL

Creating Databases and Tables in MySQL

In this MySQL Series, we first have been taking a look at MySQL and SQL in general from a high level view. With the vocabulary, acronyms, and theory now out of the way, we can not focus on putting pen to paper so to speak. This is where the MySQL Rubber hits the road. We’re going to start working with databases and tables in MySQL, for without them, we’re not going to be able to store or retrieve much data.…

The Declarative Nature of SQL

declarative language

We’ve been covering a lot of information about database technology, terms, and ideas so far. Soon we will be diving in to using data manipulation language to insert, update, and delete data in various databases we’ll create. Before we get to that point, we need to take a look at a key aspect of the Structured Query Language in general. This would be the fact that SQL is a Declarative Language, which is very much a different animal altogether from a procedural language.…

Data Types in MySQL

mysql data types

Not all data is created equal! We know from working with variables in PHP and JavaScript that variables can hold all kinds of data. MySQL is not different in this sense. The various data types in MySQL will have an impact on how much space on disk the database will use. They will also have an impact on performance. If the data types in use for your fields are not optimized, you could run into a slow running application, with your database being the bottleneck.…

Introduction to MySQL

introduction to mysql

MySQL is the world’s most popular open source database and powers all kinds of different applications in the technology industry. Of course the blogging platform WordPress uses MySQL as it’s database technology, but MySQL goes far beyond just basic blog applications. Some of the biggest names in technology today make use of MySQL, including Twitter, Facebook, Etsy, and more. We also love working with MySQL when writing PHP either natively, or with a great framework like Laravel or Codeigniter.…