eHow launches Android app: Get the best of eHow on the go.
(20)
(14)
(7)Top 50
If you need to convert an MS SQL or MS Access database to a MySQL database and either do or do not have access to the MS SQL server that contains the original database, then this article is for you.
SQL offers a great way to get the average value of your data in a single statement. In my example I am going to use MS Access's Northwind Database.
An SQL programmer uses Structured Query Language to construct relational databases to assist companies in storing, tracking and interfacing different types of information. Of course, the role of...
website hacking is the rapidly spreading threat to website. This article describes tips to prevent your web pages from hackers.
Joining two tables is common and fairly easy, but what happens when you need data from multiple tables. Here is how you join them together to get the data you need. In my example I am using MS...
Have you ever needed to combine data from two or more tables or queries with the same number of columns? A lot of times this happens when you create separate tables for each month or each year,...
At its most basic level writing an UPDATE statement in SQL is a very straightforward task. Below I will detail the three core sections that make up an UPDATE statement.
SQL queries use Structured Query Language (SQL), a standard scripting language, to make requests from databases. You can use four types of SQL queries in Access 97: union, pass-through,...
SQL Server is a great database to use and easy to connect to using VB.net. Here is how you do it.
The power of a relational database such as Oracle, SQL Server, MySQL and Access is the ability to relate two or more tables based on common fields. Here is how you can join two tables on a common...
Most people who use Microsoft office Access do not realize you can write most SQL queries in Access in order to query the Access data base. It is not straight forward so unless you know it was...
When you extract information from a database, you may have to look through thousands of duplicate values. Fortunately, there's a way to see only unique values. Here's how to get the data you...
SQL is Structured Query Language, a standard programming language for use with databases. SQL allows you to access a database, make queries of the database, and retrieve data from a database. Your...
If you are a website owner or developer, you are probably aware of the threat of hackers. There are many ways to protect your database-driven ASP or PHP website from hacker attacks, ranging from...
This article will teach users with a basic knowledge of PHP 5 and database structure to create a connection to a database, retrieve, add, change, and delete data from that database using PHP 5 and...
Any relational database gives you the ability to join various tables together through different types of joins. In this example I am using Access and the database Northwind to show how you join...
This simple how-to article will explain how to link SQL Server tables to a MS Access Database Application.
Are you a hardcore MS Access SQL user? If you use the SQL view often, you may find the default font too small to easily work with. Using the fonts available on your computer, you can change it to...
Odds are high that if you are reading this article, you are using an Oracle database and already discovered duplicates in one or many of your tables. Not to worry, eliminating duplicates through...
Web sites built solely with HTML code might still be fine for personal Web sites with two or three pages, but the Internet is really about data. Whether that data is sales numbers or a member...
As a hiring manager, I have reviewed hundreds of resumes and only a few have stood out from the pack. Those stand out resumes have led to interviews and if selected, a position in my department. ...
Using the timestamp in SQL is an easy way to store the current date and time, however some instances, having the time as part of the data will give you unwanted results. This is how to remove the...
Microsoft SQL Server is a database application used by small to large businesses. Even home users can use a light version called SQL Server Express. Knowing how to access and configure a SQL...
Have you ever wanted to remain anonymous for something? Just as people can chose to be anonymous for various things sometimes in the coding language PL/SQL blocks can be anonymous or unnamed. ...
You can select from five query types in Microsoft Access: select query, SQL query, crosstab query, parameter query or action query. These instructions apply to Access 97.
To create a SQL (Structured Query Language) query in Access 2003, you’ll need enough information to create a SQL statement. Fortunately, the program will create the statement for you, so it’s not...
Choosing the right query to use in Access 2003 can save you loads of time. Microsoft Access can seem tricky and complicated, but using queries effectively can make Access 2003 seem a lot simpler....
Tons of data can be stored within a MySQL database. With its capability to store large amounts of data, accessing a single piece of information within the MySQL database can seem like a daunting...
MySQL is a database software that will help you store and manage data. SQL has become quite a convention in the business world. Its syntax is built on a series of words that will allow you to do...
A web application is simply a website that offers users a forum to do things such as shop online, pay bills or renew a driver's license. As the creator of this forum, you want to make it as user...
Structured Query Language (SQL) is a language that was developed by IBM for processing data in mainframe databases. The relational nature of databases and the ease of SQL usage has made SQL the...
Informix SQL queries are very important to managing a database. You can look up anything you want in any database as long as you know what the table and row names are.
One of the most important Informix SQL commands to learn is the update command. By using the update command you can change data in the database you are working with. It can be a dangerous command...
There are three primary actions that a SQL programmer must make with information in a database. These are the insert command, the update command and the delete command. The delete command allows...
Copying a table is simple and quick using Microsoft Access SQL. Here’s how it’s done.
Deleting a table in Microsoft Access is surprising easy using SQL, maybe a little too easy.
Sometimes, you need to look at values from more than one table. That's when you need to create an inner join.
Using Microsoft Access SQL, you can easily combine the results of two or more queries. Here’s how you do it.
Sometimes, you want to delete all the records in a table without deleting the table itself. Here’s how it’s done.
Here’s how to find the average for a group of numbers in a column using SQL in Microsoft Access.
Adding numbers in a column is easy using SQL in Microsoft Access. See how it's done.
Here’s how to count the number of values in a column using SQL in Microsoft Access.
Although, it may be simpler to create a table using design view in Microsoft Access, it’s useful to know how to create one using SQL, too. Here's how.
Adding a record to a table is a bit tricky. But the following will help you master this common database task.
If information in your Access database needs to be updated, you can do it quickly using SQL. Here's how it's done.
It’s a snap to find the largest value in a column: just use the MAX function.
Sorting database records in Microsoft Access SQL is easier than you think. Read on.
A view is a virtual table: it doesn’t really exist and no actual data is stored, so it can save memory if your computer resources are limited. Also, you can create custom views for others so they...
You don’t have to use the Select Query window in Microsoft Access to extract information from your database. Using Structured Query Language (SQL) is often quicker and easier. Here are the basics.
Sometimes, you may need to redesign a table column in your database. For example, you may want to increase the number of characters your address column can hold. Or allow your salary field to...
Copyright © 1999-2009 eHow, Inc. Use of this web site constitutes acceptance of the eHow Terms of Use and Privacy Policy. en-US Portions of this page are modifications based on work created and shared by Google and used according to terms described in the Creative Commons 3.0 Attribution License.
