Search
Left Quote    Choose a job you love, and you will never have to work a day in your life.
- Confucius    
Right Quote
 
[login] | [Register]
 

Introduction to SQL

by: Jester
Page: 3 of 3
(View All)

Update

We can change the information in existing rows in the database using the UPDATE statement.




Update the table people and change the location to Ohio WHERE the name is Jill.We could update more than one column field if we wanted.




Just separate them with commas.

Create

We can use the CREATE TABLE statement to make new tables.




Create a table named other_people, now we have to define each column field and the type of data it will contain, here is a list of some of them:


  • INTEGER - A whole number.
  • VARCHAR (10) - Up to 10 characters.
  • CHAR (10) - Only 10 characters.
  • DATE - A date.
  • DATETIME - Date and time.
  • FLOAT - Floating point numbers.

Read the SQL statement, it speaks for itself.

Drop

We can delete tables from our database with the DROP TABLE statement.




It's as simple as that.

Conclusion

That about wraps up this introduction to SQL. This is the extreme basics, but it's these foundations you need so you can build on them and advance your skills in SQL. Practice with what you have learned, then look below if you want to learn more.


Bibliography

Here are a few links to learn more about SQL.

-Jester

1  |  2  |  3  |  


No Comments for this page.

You Must be logged in or a member to comment.


Tutorial Stats

Tutorial Stats

25,053 Views
0 Total Comments
2 Rating of 5 (1 Votes)

Options

Tutorial Options

· Login to Rate This Article
· Login to Post a Comment
· Read more by this author
Digg This Article! Del.icio.us: Bookmark This Article Reddit: Bookmark This Article BlinkList: Blink This Article! YahooMyWeb BlogMarks: Add This Mark! Furl: Save This Article Spurl: Mark This Article

Articles

Related    

Your Article Here



"AllSyntax.com" Copyright © 2002-2018; All rights lefted, all lefts righted.
Privacy Policy  |  Internet Rank