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.

Create

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.

Drop

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

• SQL Tutorial
• Introduction to SQL
• A Gentle Introduction To SQL
• Another Introduction To SQL
• Advanced SQL Techniques