SQL Commands

This example is a lesson in double-checking what you think you’re seeing. I just invested a half hour in trying to solve a problem which […]

You’ve got your MySQL database up and running. Everything is going smoothly. But then for some reason you need to change your MySQL schema name. […]

One of the most troubling parts of ASP and SQL for new programmers can be how to handle apostrophes and other special characters. Here is […]

Do you have two tables, and want to be able to calculate totals and merge information across them? Just join them together! This isn’t even […]

If you are working with a MySQL database, it is important to optimize the database so it runs as quickly as possible. Here are some […]

Need to create a table to put data in? It’s very easy to put together SQL Syntax to build the table to store your newsletter […]

You understand the basics of using ASP, including loops and requests. Now you want to use this knowledge to select information out of a database. […]

An important step when using character data in SQL and ASP is making sure that any apostrophes (‘) in the data doesn’t interfere with your […]

The most common thing to do with ASP is show information stored in a database. Here are the basics of the SQL Select statement, to […]

There are many times that you will want to select all rows from a given database table. How do you move through the records, and […]