Apache Derby – Syntax This chapter gives you the syntax of all the Apache Derby SQL statements. All the statements start with any of the keywords like SELECT, INSERT, UPDATE, DELETE, ALTER, DROP, CREATE, USE, SHOW and all the statements end with a semicolon (;). The SQL statements of Apache Derby are case in sensitives […]
Category Archives: apache Derby
Apache Derby – Insert Data The insert query inserts data: new records, into the table. Syntax Following is the basic syntax of the INSERT statement − ij>INSERT INTO table_name VALUES (column_name1, column_name2, …); where column1, column2 are the column values in the row that is to be inserted. Example The following SQL INSERT statement inserts […]
Apache Derby – Drop Table The DROP TABLE statement is used to remove an existing table including all its triggers, constraints, permissions. Syntax Following is the Syntax of the DROP TABLE statement. ij> DROP TABLE table_name; Example Suppose you have a table named Student in the database. The following SQL statement deletes a table named […]