If we wanted to return less data, we would actually need to write more.įor example, if we only wanted pets named Fetch, we would add a WHERE clause that stipulated that requirement. The simplest SQL queries are usually the most powerful. That’s one of the beautiful things about SQL. It’s a quick and easy way to get all columns without having to type them all out. The asterisk ( *) is a wildcard character, which means “all columns”. It returns all columns and all rows from the table called Pets. This simple SQL statement actually does a lot. This is a perfect example of how easy it can be to write SQL. Here’s an example SQL statement: SELECT * This SQL tutorial will get you running SQL queries in no time! SQL Example In this SQL tutorial for beginners, you will create your own database, insert data into that database, and then run queries against that database.
0 Comments
Leave a Reply. |