Posts Tagged ‘sql’

Char or Varchar

Monday, July 7th, 2008

When you are defining the fields for your database tables you will have a lot of fields that contain text. In this article we look at the difference between defining those fields as char or varchar and the situations where one may be better than the other. Of course you may be using a database where the optimiser will automatically switch the type if you specify the less efficient one for you in which case you may not need this information to be able to make the choice but it will still be useful in letting you know how each actually works.

Char or Varchar

Adding, Replacing, and Deleting Records

Sunday, April 6th, 2008

All relational databases support the same basic structured query language commands to access and update the database. Of course some of them also have custom extensions to the SQL as well. In this article I look at the basic SQL required for adding, updating, and deleting records in any relational database.

Adding, Replacing, and Deleting Records