SQLite Create Database To create a new database in SQLite, the sqlite3 command is used. Syntax: sqlite3 DatabaseName.db To create a database: Open the command prompt. Set the path. Check the SQLite directory. Command: dir Create a database. Example: sqlite3 example.db Check the created database. Command: .databases Or check the created database in the root … Read more
SQLite Expressions To evaluate the value, a combination of one or more values, operators and SQL functions can be used. These combinations are written in query language in SQLite and are called SQLite expressions. They are mostly used with the SQLite SELECT statement. Syntax: SELECT column_1, column_2, column_N FROM table_name WHERE [CONDITION | EXPRESSION]; Types … Read more
SQLite Operators The reserved words or characters used in SQLite statements to perform operations on a variable, an expression or a value are called the SQLite Operators. It is used to specify conditions. It also acts as a conjunction for multiple conditions in a statement. SQLite facilitates four types of operators. These are: Arithmetic … Read more
HTML Form A section of a document to control text fields, password fields, checkboxes, radio buttons, submit buttons, menus etc. is called and is created by the HTML form. The data thus entered in a form is sent to the server for further processing. Thus collecting some info from the site visitor is easy with … Read more
In the HTML Description list, entries are listed like a dictionary or encyclopedia, and hence it is also called a Definition List. To display a glossary, a list of terms, or other name-value lists, the HTML Description list can be the best choice. There are three tags used in an HTML Description list. These are: … Read more
As the name itself suggests, all the list items are marked with numbers by default in a Numbered List. It is popularly known as HTML Ordered List and hence starts with the <ol> tag. The list items in an HTML Ordered List start with the <li> tag. An HTML Ordered List can be mainly of … Read more
To specify lists of information, an HTML List is used, which can be any of the three different types. Ordered List or Numbered List (ol) Unordered List or Bulleted List (ul) Description List or Definition List (dl) HTML Ordered List or Numbered List: As the name itself suggests, all the list items are marked with … Read more
HTML Table To display a group of data in a tabular form the HTML table tag is used. To serve this purpose the HTML <table> element is used, with <tr> tag to define the table row, <th> tag to define the table header, and the <td> tag to define the table data. However, to manage … Read more
HTML Image To display an image on a web page, the HTML image tag is used. It is an empty tag with no closing tag. An empty tag in HTML usually contains attributes only. Attributes: The attributes of the HTML image tag are discussed below. src: It is used to describe the source or path … Read more
HTML Anchor To define a hyperlink to other web pages, files, locations, or any URL, using the “href” attribute, the HTML anchor tag is used. The “href” attribute specifies the address of the destination page. Appearance: Unvisited link: Underlined and Blue. Visited link: Underlined and purple. Active link: Underlined and red. Syntax: <a href = … Read more