Web Detritus

If you often write applications that connect to database servers, it helps if you know how to install a MySQL database on your Windows machine for testing purposes. Connecting to a database with most applications usually just involves a specific connection string, so testing your application with one database server and then switching it later to a "production" server is very simple. In this article, we’re going to walk you through the steps of setting up your own local MySQL database on any Windows PC. ...

Structured Query Language (SQL) is a remarkably powerful tool, and one that is packed full of features. Once you’ve mastered the most important SQL commands, you can start to get a bit more creative with your SQL. Today I’ll show you everything you need to know about SQL concatenation strings. There are many different SQL dialects. For all these examples, I’m using the PostgreSQL variant. What Is Concatenation? Concatenation means to join two things together. You may have used it in a programming languag...

Databases drive the modern web. Every big or dynamic website uses a database in some way, and when combined with Structured Query Language (SQL), the possibilities for manipulating data really are endless. If you already know SQL, make sure you checkout these programming skills all website developers should know. Today I’ll be showing you some of the core commands you need to know as a programmer. There are many names for data returned from a database table. Data is commonly referred to as Rows, Re...