- 1). Open your database application. You can use either a command line interface or the graphical user interface provided by your database vendor.
- 2). Connect to your database.
- 3). Create the update query by typing the "UPDATE" keyword followed by the table name to update. It should say "UPDATE MyTable."
- 4). Type the keyword "SET" followed by the column name that the data will be changed in and an equal sign.
- 5). Type the new value for the column. Character data uses single quote marks around the value. Numeric data does not require quotes. You can update multiple columns by repeating the column equals value pattern, separated by commas. For example, "SET Column1=44, Column2='new value'" is a proper value column.
- 6). Add a "WHERE" clause to limit updates to only specific records, if desired.
- 7). Execute the SQL statement.
- Advertisement -
- Advertisement -
EDITOR PICKS & Articles
- Non-profit raising event are volunteers
- SEO Services - Door Of Success
- The Way Satellite Internet Delivers a Different System
- How to Create Themes for Outlook 2007
- How to Check an SSL Encryption
- What is a Channel Manager and Should You Get One?
- Get Effective Web Design Services in Milwaukee WI
- Do you know how to work with hidden Wi-Fi networks in Windows?
- Financial Studies Delhi. Unemployed Student Loan Offers A Big Financial Help For Higher Studies
- Is There Any Way to Find Out If Someone Is Checking Your Facebook?
Subscribe to our newsletter
Sign up here to get the latest news, updates and special offers delivered directly to your inbox.
You can unsubscribe at any time
"Technology" Categories
Stay With Us
"Technology" MOST POPULAR
"Technology" Lastest Articles