MySQL Function Tutorial

MySQL Function Tutorial

It’s been a great MySQL tutorial series so far and now we’re going to dig even further into the language. The introduction to MySQL, data types, declarative nature, and using data manipulation language is a great foundation to start practicing some queries that are just slightly more advanced. Don’t worry, we’re taking baby steps here but there are a bunch of concepts that we need to get our feet wet with.…

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.…