Search
Left Quote    It is possible to store the mind with a million facts and still be entirely uneducated.
- Alec Bourne    
Right Quote
 
[login] | [Register]
 

Introduction to SQL

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

Where



We can use the WHERE statement to be selective.




I'm sure you can understand that. Select the name column from the table people where the gender column is equal to male. What would this select?
Bob, Joe, Jeff

We could select every column from the table where the gender is female.




That would select all the information from the table where the gender contains "female". Simple enough? SQL speaks for itself, it does what it says, it isn't difficult at all.


Insert

We can insert new rows into the database if we wish, here's the structure.




That statement would insert a new row. In the first brackets we list the columns in which we want to enter a value (all in this case), in the second set of brackets we enter the value. The order of the values listed in the first bracket must match the order of the values to insert in the second brackets. So now we have a new row.
Table: People


ID NAME GENDER LOCATION AGE
1 Bob Male UK 31
2 Jill Female USA 24
3 Joe Male Germany 19
4 Jeff Male France 46
5 Sue Female UK 29
6 Fred Male Chile 25

Delete

Maybe we want to delete a row from the table, or delete multiple rows, here's how we do it.




This statement would delete any row where the name is Joe, read the query, it does what it says. So now we would have:
Table: People


ID NAME GENDER LOCATION AGE
1 Bob Male UK 31
2 Jill Female USA 24
4 Jeff Male France 46
5 Sue Female UK 29
6 Fred Male Chile 25

We could delete all the males from the table.




Now we would have:


Table: People

ID NAME GENDER LOCATION AGE
2 Jill Female USA 24
5 Sue Female UK 29

It really does speak for itself, you just need to learn the statements.



1  |  2  |  3  |  
Next »


No Comments for this page.

You Must be logged in or a member to comment.


Tutorial Stats

Tutorial Stats

25,134 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