![]() So we begin the statement with CREATE TABLE. For our first table, we will create a table containing at least one field with a data type from each category. In a previous article, I discussed the different data types used in HSQLDB. ![]() Therefore, I will always quote my fields and tables names. In LibreOffice Base and HSQLDB SQL syntax, unquoted field and table names are converted to upper case. You can type keywords in upper or lower case, but for the sake of clarity, I will put keywords in upper case, as is the SQL standard. All SQL statements in LibreOffice must end with a semicolon ( ). ![]() SQL is a acronym for Structured Query Language and is the standard language for accessing and manipulating databases.Ī few thing you need to know before we get started. ![]() Once you create a database, you can access the SQL command dialog by Tools > SQL. While LibreOffice allows you to create tables using the GUI, knowing how to create tables using SQL can help you better understand how relational databases work. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |