O'Reilly logo

Java 9 Cookbook by Nick Samoylov, Mohamed Sanaulla

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

How to do it...

We have already seen an INSERT statement. Here is an example of other types of statements:

The preceding SELECT statement requires bringing up all the columns of all the rows of the table. If the number of rows was bigger than the number of lines on the screen, the database console would show only the first screen and you would need to type a command (database-specific) to show the next screen:  

This SELECT statement has a WHERE clause that requires you to show only those rows where the value in the type column is vehicle

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required